Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

itemstatus problem

12 posts in DataWindow Last posting was on 2008-12-10 16:28:11.0Z
Benjamin Kemner Posted on 2008-12-09 09:58:08.0Z
From: Benjamin Kemner <look@my-signature.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: itemstatus problem
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493e4130$1@forums-1-dub>
Date: 9 Dec 2008 01:58:08 -0800
X-Trace: forums-1-dub 1228816688 10.22.241.152 (9 Dec 2008 01:58:08 -0800)
X-Original-Trace: 9 Dec 2008 01:58:08 -0800, vip152.sybase.com
Lines: 28
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88348
Article PK: 417601

Hi,

I have some strange issues setting the itemstatus of a column. The case
is, that a user inserts a new row in a datawindow and edits a column.
The status of the row is newModified!. Before I save the dw to the
database I want to keep some columns away from insert statement. So I
try to set that columns to the status notModified!.

Example:

// user inserts row and edits column "a"
[...]
// dont't save "a" in this case ( but in another )

IF <thisCase> THEN
// "a" is Modified!
setItemStatus ( 1, "a", primary!, notModified! )
// "a" is Modified at all!
END IF

Any ideas what's wrong?

regards

Benjamin

--
kemnerAT_NOSPAMsf-datentechnikDOTde


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-12-09 13:46:12.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493e76a4@forums-1-dub>
Date: 9 Dec 2008 05:46:12 -0800
X-Trace: forums-1-dub 1228830372 10.22.241.152 (9 Dec 2008 05:46:12 -0800)
X-Original-Trace: 9 Dec 2008 05:46:12 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88351
Article PK: 417604

What did SetItemStatus return?

"Benjamin Kemner" <look@my-signature.de> wrote in message
news:493e4130$1@forums-1-dub...
> Hi,
>
> I have some strange issues setting the itemstatus of a column. The case
> is, that a user inserts a new row in a datawindow and edits a column. The
> status of the row is newModified!. Before I save the dw to the database I
> want to keep some columns away from insert statement. So I try to set that
> columns to the status notModified!.
>
> Example:
>
> // user inserts row and edits column "a"
> [...]
> // dont't save "a" in this case ( but in another )
>
> IF <thisCase> THEN
> // "a" is Modified!
> setItemStatus ( 1, "a", primary!, notModified! )
> // "a" is Modified at all!
> END IF
>
> Any ideas what's wrong?
>
> regards
>
> Benjamin
>
> --
> kemnerAT_NOSPAMsf-datentechnikDOTde


Benjamin Kemner Posted on 2008-12-09 14:11:05.0Z
From: Benjamin Kemner <look@my-signature.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: itemstatus problem
References: <493e4130$1@forums-1-dub> <493e76a4@forums-1-dub>
In-Reply-To: <493e76a4@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493e7c79$1@forums-1-dub>
Date: 9 Dec 2008 06:11:05 -0800
X-Trace: forums-1-dub 1228831865 10.22.241.152 (9 Dec 2008 06:11:05 -0800)
X-Original-Trace: 9 Dec 2008 06:11:05 -0800, vip152.sybase.com
Lines: 41
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88352
Article PK: 417608

returncode is 1

Jerry Siegel [TeamSybase] schrieb:

> What did SetItemStatus return?
>
> "Benjamin Kemner" <look@my-signature.de> wrote in message
> news:493e4130$1@forums-1-dub...
>> Hi,
>>
>> I have some strange issues setting the itemstatus of a column. The case
>> is, that a user inserts a new row in a datawindow and edits a column. The
>> status of the row is newModified!. Before I save the dw to the database I
>> want to keep some columns away from insert statement. So I try to set that
>> columns to the status notModified!.
>>
>> Example:
>>
>> // user inserts row and edits column "a"
>> [...]
>> // dont't save "a" in this case ( but in another )
>>
>> IF <thisCase> THEN
>> // "a" is Modified!
>> setItemStatus ( 1, "a", primary!, notModified! )
>> // "a" is Modified at all!
>> END IF
>>
>> Any ideas what's wrong?
>>
>> regards
>>
>> Benjamin
>>
>> --
>> kemnerAT_NOSPAMsf-datentechnikDOTde
>
>

--
kemnerAT_NOSPAMsf-datentechnikDOTde


Chris Pollach Posted on 2008-12-09 14:14:50.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493e7d5a$1@forums-1-dub>
Date: 9 Dec 2008 06:14:50 -0800
X-Trace: forums-1-dub 1228832090 10.22.241.152 (9 Dec 2008 06:14:50 -0800)
X-Original-Trace: 9 Dec 2008 06:14:50 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88353
Article PK: 417606

Hi Benjamin;

Can you tell us ...

1) What PB release you are using?
2) Where are you coding the SetItemStatus command (ie Event).
3) Is there a chance that Column "A" is modified after the SetItemStatus is
done but before the Update?

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Benjamin Kemner" <look@my-signature.de> wrote in message
news:493e4130$1@forums-1-dub...
> Hi,
>
> I have some strange issues setting the itemstatus of a column. The case
> is, that a user inserts a new row in a datawindow and edits a column. The
> status of the row is newModified!. Before I save the dw to the database I
> want to keep some columns away from insert statement. So I try to set that
> columns to the status notModified!.
>
> Example:
>
> // user inserts row and edits column "a"
> [...]
> // dont't save "a" in this case ( but in another )
>
> IF <thisCase> THEN
> // "a" is Modified!
> setItemStatus ( 1, "a", primary!, notModified! )
> // "a" is Modified at all!
> END IF
>
> Any ideas what's wrong?
>
> regards
>
> Benjamin
>
> --
> kemnerAT_NOSPAMsf-datentechnikDOTde


Benjamin Kemner Posted on 2008-12-09 15:59:38.0Z
From: Benjamin Kemner <look@my-signature.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: itemstatus problem
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub>
In-Reply-To: <493e7d5a$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493e95ea@forums-1-dub>
Date: 9 Dec 2008 07:59:38 -0800
X-Trace: forums-1-dub 1228838378 10.22.241.152 (9 Dec 2008 07:59:38 -0800)
X-Original-Trace: 9 Dec 2008 07:59:38 -0800, vip152.sybase.com
Lines: 30
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88359
Article PK: 417613

1 ) My current release is 11.5 2506. I tested it down to PB 8 with the
same result.
2 ) In my "real" application from a method triggered after inserting a
row, in my sandbox from a clicked event.
3 ) I'm not sure understanding your question. The column is definetly
modified after the setItemStatus with "notModified!" is fired. The
result of the setItemStatus is 1 but nothing is changed. The Update
takes the column in the insert.

I also tried to set the the status of row to dataModified!, set the item
to notModified! and reset the row status to newModified! ... no success.

regards

Benjamin

Chris Pollach schrieb:

> Hi Benjamin;
>
> Can you tell us ...
>
> 1) What PB release you are using?
> 2) Where are you coding the SetItemStatus command (ie Event).
> 3) Is there a chance that Column "A" is modified after the SetItemStatus is
> done but before the Update?
>

--
kemnerAT_NOSPAMsf-datentechnikDOTde


Chris Pollach Posted on 2008-12-09 16:45:17.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493ea09d$1@forums-1-dub>
Date: 9 Dec 2008 08:45:17 -0800
X-Trace: forums-1-dub 1228841117 10.22.241.152 (9 Dec 2008 08:45:17 -0800)
X-Original-Trace: 9 Dec 2008 08:45:17 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88360
Article PK: 417614

Thought: How about your DWO "Update Properties"?

In particular - did you set the "Where clause for Update/Delete" option to
"Key and Modified Columns"?

"Benjamin Kemner" <look@my-signature.de> wrote in message
news:493e95ea@forums-1-dub...
>1 ) My current release is 11.5 2506. I tested it down to PB 8 with the same
>result.
> 2 ) In my "real" application from a method triggered after inserting a
> row, in my sandbox from a clicked event.
> 3 ) I'm not sure understanding your question. The column is definetly
> modified after the setItemStatus with "notModified!" is fired. The result
> of the setItemStatus is 1 but nothing is changed. The Update takes the
> column in the insert.
>
> I also tried to set the the status of row to dataModified!, set the item
> to notModified! and reset the row status to newModified! ... no success.
>
> regards
>
> Benjamin
>
> Chris Pollach schrieb:
>> Hi Benjamin;
>>
>> Can you tell us ...
>>
>> 1) What PB release you are using?
>> 2) Where are you coding the SetItemStatus command (ie Event).
>> 3) Is there a chance that Column "A" is modified after the SetItemStatus
>> is done but before the Update?
>>
>
>
> --
> kemnerAT_NOSPAMsf-datentechnikDOTde


Benjamin Kemner Posted on 2008-12-09 16:55:50.0Z
From: Benjamin Kemner <look@my-signature.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: itemstatus problem
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub> <493ea09d$1@forums-1-dub>
In-Reply-To: <493ea09d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493ea316@forums-1-dub>
Date: 9 Dec 2008 08:55:50 -0800
X-Trace: forums-1-dub 1228841750 10.22.241.152 (9 Dec 2008 08:55:50 -0800)
X-Original-Trace: 9 Dec 2008 08:55:50 -0800, vip152.sybase.com
Lines: 47
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88361
Article PK: 417615

Yes, it's "key and modified columns"


Chris Pollach schrieb:

> Thought: How about your DWO "Update Properties"?
>
> In particular - did you set the "Where clause for Update/Delete" option to
> "Key and Modified Columns"?
>
>
> "Benjamin Kemner" <look@my-signature.de> wrote in message
> news:493e95ea@forums-1-dub...
>> 1 ) My current release is 11.5 2506. I tested it down to PB 8 with the same
>> result.
>> 2 ) In my "real" application from a method triggered after inserting a
>> row, in my sandbox from a clicked event.
>> 3 ) I'm not sure understanding your question. The column is definetly
>> modified after the setItemStatus with "notModified!" is fired. The result
>> of the setItemStatus is 1 but nothing is changed. The Update takes the
>> column in the insert.
>>
>> I also tried to set the the status of row to dataModified!, set the item
>> to notModified! and reset the row status to newModified! ... no success.
>>
>> regards
>>
>> Benjamin
>>
>> Chris Pollach schrieb:
>>> Hi Benjamin;
>>>
>>> Can you tell us ...
>>>
>>> 1) What PB release you are using?
>>> 2) Where are you coding the SetItemStatus command (ie Event).
>>> 3) Is there a chance that Column "A" is modified after the SetItemStatus
>>> is done but before the Update?
>>>
>>
>> --
>> kemnerAT_NOSPAMsf-datentechnikDOTde
>
>

--
kemnerAT_NOSPAMsf-datentechnikDOTde


Chris Pollach Posted on 2008-12-09 18:25:58.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub> <493ea09d$1@forums-1-dub> <493ea316@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493eb836$1@forums-1-dub>
Date: 9 Dec 2008 10:25:58 -0800
X-Trace: forums-1-dub 1228847158 10.22.241.152 (9 Dec 2008 10:25:58 -0800)
X-Original-Trace: 9 Dec 2008 10:25:58 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88362
Article PK: 417617

Yep .. its a problem - but only when during an InsertRow ( ) command. I
would open a case for this with Sybase.

In the meantime, I would suggest doing a GetItemStatus (row, 0, ....) to
get the "Row" status. If the Row is NewModified! - then set the column you
want cancelled to NULL using a SetItem ( ) command. This works in my quick
test.

HTH

"Benjamin Kemner" <look@my-signature.de> wrote in message
news:493ea316@forums-1-dub...
> Yes, it's "key and modified columns"
>
>
> Chris Pollach schrieb:
>> Thought: How about your DWO "Update Properties"?
>>
>> In particular - did you set the "Where clause for Update/Delete" option
>> to "Key and Modified Columns"?
>>
>>
>> "Benjamin Kemner" <look@my-signature.de> wrote in message
>> news:493e95ea@forums-1-dub...
>>> 1 ) My current release is 11.5 2506. I tested it down to PB 8 with the
>>> same result.
>>> 2 ) In my "real" application from a method triggered after inserting a
>>> row, in my sandbox from a clicked event.
>>> 3 ) I'm not sure understanding your question. The column is definetly
>>> modified after the setItemStatus with "notModified!" is fired. The
>>> result of the setItemStatus is 1 but nothing is changed. The Update
>>> takes the column in the insert.
>>>
>>> I also tried to set the the status of row to dataModified!, set the item
>>> to notModified! and reset the row status to newModified! ... no success.
>>>
>>> regards
>>>
>>> Benjamin
>>>
>>> Chris Pollach schrieb:
>>>> Hi Benjamin;
>>>>
>>>> Can you tell us ...
>>>>
>>>> 1) What PB release you are using?
>>>> 2) Where are you coding the SetItemStatus command (ie Event).
>>>> 3) Is there a chance that Column "A" is modified after the
>>>> SetItemStatus is done but before the Update?
>>>>
>>>
>>> --
>>> kemnerAT_NOSPAMsf-datentechnikDOTde
>>
>>
>
>
> --
> kemnerAT_NOSPAMsf-datentechnikDOTde


Benjamin Kemner Posted on 2008-12-10 08:57:59.0Z
From: Benjamin Kemner <look@my-signature.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: itemstatus problem
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub> <493ea09d$1@forums-1-dub> <493ea316@forums-1-dub> <493eb836$1@forums-1-dub>
In-Reply-To: <493eb836$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493f8497$1@forums-1-dub>
Date: 10 Dec 2008 00:57:59 -0800
X-Trace: forums-1-dub 1228899479 10.22.241.152 (10 Dec 2008 00:57:59 -0800)
X-Original-Trace: 10 Dec 2008 00:57:59 -0800, vip152.sybase.com
Lines: 70
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88368
Article PK: 417622

OK, thanks for your support.

regards

Benjamin

Chris Pollach schrieb:

> Yep .. its a problem - but only when during an InsertRow ( ) command. I
> would open a case for this with Sybase.
>
> In the meantime, I would suggest doing a GetItemStatus (row, 0, ....) to
> get the "Row" status. If the Row is NewModified! - then set the column you
> want cancelled to NULL using a SetItem ( ) command. This works in my quick
> test.
>
> HTH
>
>
> "Benjamin Kemner" <look@my-signature.de> wrote in message
> news:493ea316@forums-1-dub...
>> Yes, it's "key and modified columns"
>>
>>
>> Chris Pollach schrieb:
>>> Thought: How about your DWO "Update Properties"?
>>>
>>> In particular - did you set the "Where clause for Update/Delete" option
>>> to "Key and Modified Columns"?
>>>
>>>
>>> "Benjamin Kemner" <look@my-signature.de> wrote in message
>>> news:493e95ea@forums-1-dub...
>>>> 1 ) My current release is 11.5 2506. I tested it down to PB 8 with the
>>>> same result.
>>>> 2 ) In my "real" application from a method triggered after inserting a
>>>> row, in my sandbox from a clicked event.
>>>> 3 ) I'm not sure understanding your question. The column is definetly
>>>> modified after the setItemStatus with "notModified!" is fired. The
>>>> result of the setItemStatus is 1 but nothing is changed. The Update
>>>> takes the column in the insert.
>>>>
>>>> I also tried to set the the status of row to dataModified!, set the item
>>>> to notModified! and reset the row status to newModified! ... no success.
>>>>
>>>> regards
>>>>
>>>> Benjamin
>>>>
>>>> Chris Pollach schrieb:
>>>>> Hi Benjamin;
>>>>>
>>>>> Can you tell us ...
>>>>>
>>>>> 1) What PB release you are using?
>>>>> 2) Where are you coding the SetItemStatus command (ie Event).
>>>>> 3) Is there a chance that Column "A" is modified after the
>>>>> SetItemStatus is done but before the Update?
>>>>>
>>>> --
>>>> kemnerAT_NOSPAMsf-datentechnikDOTde
>>>
>>
>> --
>> kemnerAT_NOSPAMsf-datentechnikDOTde
>
>

--
kemnerAT_NOSPAMsf-datentechnikDOTde


Chris Werner Posted on 2008-12-10 14:15:08.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub> <493ea09d$1@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493fceec@forums-1-dub>
Date: 10 Dec 2008 06:15:08 -0800
X-Trace: forums-1-dub 1228918508 10.22.241.152 (10 Dec 2008 06:15:08 -0800)
X-Original-Trace: 10 Dec 2008 06:15:08 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88372
Article PK: 417631

Hi Chris,

I don't understand what the connection between the
values inserted by an INSERT statement for of a new
row in the DataWindow and the update property
"Where clause for Update/Delete" is? I believe that's
missleading.

Chris Werner
f+s software gmbh


"Chris Pollach" <cpollach@travel-net.com> schrieb im Newsbeitrag
news:493ea09d$1@forums-1-dub...

>
> Thought: How about your DWO "Update Properties"?
>
> In particular - did you set the "Where clause for Update/Delete" option to
> "Key and Modified Columns"?
>
>
> "Benjamin Kemner" <look@my-signature.de> wrote in message
> news:493e95ea@forums-1-dub...
>>1 ) My current release is 11.5 2506. I tested it down to PB 8 with the
>>same result.
>> 2 ) In my "real" application from a method triggered after inserting a
>> row, in my sandbox from a clicked event.
>> 3 ) I'm not sure understanding your question. The column is definetly
>> modified after the setItemStatus with "notModified!" is fired. The result
>> of the setItemStatus is 1 but nothing is changed. The Update takes the
>> column in the insert.
>>
>> I also tried to set the the status of row to dataModified!, set the item
>> to notModified! and reset the row status to newModified! ... no success.
>>
>> regards
>>
>> Benjamin
>>
>> Chris Pollach schrieb:
>>> Hi Benjamin;
>>>
>>> Can you tell us ...
>>>
>>> 1) What PB release you are using?
>>> 2) Where are you coding the SetItemStatus command (ie Event).
>>> 3) Is there a chance that Column "A" is modified after the SetItemStatus
>>> is done but before the Update?
>>>
>>
>>
>> --
>> kemnerAT_NOSPAMsf-datentechnikDOTde
>
>


Chris Werner Posted on 2008-12-10 14:28:19.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 76
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493fd203$1@forums-1-dub>
Date: 10 Dec 2008 06:28:19 -0800
X-Trace: forums-1-dub 1228919299 10.22.241.152 (10 Dec 2008 06:28:19 -0800)
X-Original-Trace: 10 Dec 2008 06:28:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88373
Article PK: 417635

Hi Benjamin,

> 2 ) In my "real" application from a method triggered after inserting a
> row, in my sandbox from a clicked event.

After inserting the row but before editing the data in the new row? That
would indeed explain why it fails.

The next step in your investigation should be to check the itemstatus
after setting it (and, because we are snoopy, prior to it):

dwItemStatus le_stat1, le_stat2
le_stat1 = getItemStatus(1, "a", primary!)
setItemStatus ( 1, "a", primary!, notModified! )
le_stat2 = getItemStatus(1, "a", primary!)

It would be interesting if the status changes from dataModified!
to notModified! If that is the case check the latter again in the
updateStart event:

dwItemStatus le_stat
le_stat = getItemStatus(1, "a", primary!)

Still notModified!? Is there some code in the sqlPreview event?
You could check the status here again:

dwItemStatus le_stat
if buffer = primary! then
le_stat = getItemStatus(row, "a", primary!)
end if

Debug that to be sure the status is still notModified! but the generated
INSERT statement contains column"a". If so, you should report that to
Sybase.

Good luck!

Chris Werner
f+s software gmbh



"Benjamin Kemner" <look@my-signature.de> schrieb im Newsbeitrag
news:493e95ea@forums-1-dub...
>1 ) My current release is 11.5 2506. I tested it down to PB 8 with the same
>result.
> 2 ) In my "real" application from a method triggered after inserting a
> row, in my sandbox from a clicked event.
> 3 ) I'm not sure understanding your question. The column is definetly
> modified after the setItemStatus with "notModified!" is fired. The result
> of the setItemStatus is 1 but nothing is changed. The Update takes the
> column in the insert.
>
> I also tried to set the the status of row to dataModified!, set the item
> to notModified! and reset the row status to newModified! ... no success.
>
> regards
>
> Benjamin
>
> Chris Pollach schrieb:
>> Hi Benjamin;
>>
>> Can you tell us ...
>>
>> 1) What PB release you are using?
>> 2) Where are you coding the SetItemStatus command (ie Event).
>> 3) Is there a chance that Column "A" is modified after the SetItemStatus
>> is done but before the Update?
>>
>
>
> --
> kemnerAT_NOSPAMsf-datentechnikDOTde


Chris Pollach Posted on 2008-12-10 16:28:11.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <493e4130$1@forums-1-dub> <493e7d5a$1@forums-1-dub> <493e95ea@forums-1-dub> <493fd203$1@forums-1-dub>
Subject: Re: itemstatus problem
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493fee1b$1@forums-1-dub>
Date: 10 Dec 2008 08:28:11 -0800
X-Trace: forums-1-dub 1228926491 10.22.241.152 (10 Dec 2008 08:28:11 -0800)
X-Original-Trace: 10 Dec 2008 08:28:11 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88375
Article PK: 417627

Hi Chris;

FYI: I did a quick test application in PB 11.5 and found that the flags
are changed in the DW buffer OK. If you do a Retrieve ( ), then set the
SetItemStatus to NotModified, the generated SQL for that column is bypassed.
However, if you do an InsertRow, allow the user to enter data and then do
the SetItemStatus to NotModified!, the action takes - but the DWO will
ALWAYS generate an update for that column with the NEW data. Hence, exactly
what Benjamin initially described as his problem. AFAIA once you set any
columns status to NotModified! there should be no entry for it in the Update
SQL flow.

In all the years I have been using PB and developing applications, I
have never used this approach for an Insert operation. I would always deny
or by pass the data entry operation on the affected column as it happens. I
can see though that if there is a dependency on other column data for
validation that Benjamin's approach would be good - even for an insert.
Logically, I think that the ItemStatus setting should be honoured for any
row in the DWO - regardless of the operation that allowed it to be
instantiated.


--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Chris Werner" <cwAT{PleaseNoSpam}f-s.de> wrote in message
news:493fd203$1@forums-1-dub...
> Hi Benjamin,
>
>> 2 ) In my "real" application from a method triggered after inserting a
>> row, in my sandbox from a clicked event.
>
> After inserting the row but before editing the data in the new row? That
> would indeed explain why it fails.
>
> The next step in your investigation should be to check the itemstatus
> after setting it (and, because we are snoopy, prior to it):
>
> dwItemStatus le_stat1, le_stat2
> le_stat1 = getItemStatus(1, "a", primary!)
> setItemStatus ( 1, "a", primary!, notModified! )
> le_stat2 = getItemStatus(1, "a", primary!)
>
> It would be interesting if the status changes from dataModified!
> to notModified! If that is the case check the latter again in the
> updateStart event:
>
> dwItemStatus le_stat
> le_stat = getItemStatus(1, "a", primary!)
>
> Still notModified!? Is there some code in the sqlPreview event?
> You could check the status here again:
>
> dwItemStatus le_stat
> if buffer = primary! then
> le_stat = getItemStatus(row, "a", primary!)
> end if
>
> Debug that to be sure the status is still notModified! but the generated
> INSERT statement contains column"a". If so, you should report that to
> Sybase.
>
> Good luck!
>
> Chris Werner
> f+s software gmbh
>
>
>
> "Benjamin Kemner" <look@my-signature.de> schrieb im Newsbeitrag
> news:493e95ea@forums-1-dub...
>>1 ) My current release is 11.5 2506. I tested it down to PB 8 with the
>>same result.
>> 2 ) In my "real" application from a method triggered after inserting a
>> row, in my sandbox from a clicked event.
>> 3 ) I'm not sure understanding your question. The column is definetly
>> modified after the setItemStatus with "notModified!" is fired. The result
>> of the setItemStatus is 1 but nothing is changed. The Update takes the
>> column in the insert.
>>
>> I also tried to set the the status of row to dataModified!, set the item
>> to notModified! and reset the row status to newModified! ... no success.
>>
>> regards
>>
>> Benjamin
>>
>> Chris Pollach schrieb:
>>> Hi Benjamin;
>>>
>>> Can you tell us ...
>>>
>>> 1) What PB release you are using?
>>> 2) Where are you coding the SetItemStatus command (ie Event).
>>> 3) Is there a chance that Column "A" is modified after the SetItemStatus
>>> is done but before the Update?
>>>
>>
>>
>> --
>> kemnerAT_NOSPAMsf-datentechnikDOTde
>
>