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.

updateable columns - does not work with "Key and Modified Columns"

7 posts in DataWindow Last posting was on 2009-01-28 16:49:08.0Z
Frank Steinmann Posted on 2008-11-21 09:32:15.0Z
Reply-To: "Frank Steinmann" <Frank.Steinmann@cs-edv.de>
From: "Frank Steinmann" <Frank.Steinmann@cs-edv.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: updateable columns - does not work with "Key and Modified Columns"
Lines: 8
Organization: CS-Software E. GmbH
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; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4926801f$1@forums-1-dub>
Date: 21 Nov 2008 01:32:15 -0800
X-Trace: forums-1-dub 1227259935 10.22.241.152 (21 Nov 2008 01:32:15 -0800)
X-Original-Trace: 21 Nov 2008 01:32:15 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88215
Article PK: 417469

is this correct?

I think not!

Greetings Frank
Using PowerBuilder 11.2 Build 8616


Chris Pollach Posted on 2008-11-21 12:29:10.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4926801f$1@forums-1-dub>
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
Lines: 24
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: <4926a996$1@forums-1-dub>
Date: 21 Nov 2008 04:29:10 -0800
X-Trace: forums-1-dub 1227270550 10.22.241.152 (21 Nov 2008 04:29:10 -0800)
X-Original-Trace: 21 Nov 2008 04:29:10 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88217
Article PK: 417471

Hi Frank;

This feature is working great for me (PB 11.2 build 8407).

1) What DBMS are you using?
2) What DB connectivity mechanism are you using?

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

"Frank Steinmann" <Frank.Steinmann@cs-edv.de> wrote in message
news:4926801f$1@forums-1-dub...
> is this correct?
>
> I think not!
>
> Greetings Frank
> Using PowerBuilder 11.2 Build 8616
>


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-11-21 14:32:45.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
References: <4926801f$1@forums-1-dub> <4926a996$1@forums-1-dub>
In-Reply-To: <4926a996$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4926c68d$1@forums-1-dub>
Date: 21 Nov 2008 06:32:45 -0800
X-Trace: forums-1-dub 1227277965 10.22.241.152 (21 Nov 2008 06:32:45 -0800)
X-Original-Trace: 21 Nov 2008 06:32:45 -0800, vip152.sybase.com
Lines: 12
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88218
Article PK: 417470

Also, what are the data types of the updateable columns? And are there
any triggers on the updated table?

Chris Pollach wrote:
> Hi Frank;
>
> This feature is working great for me (PB 11.2 build 8407).
>
> 1) What DBMS are you using?
> 2) What DB connectivity mechanism are you using?
>


Frank Steinmann Posted on 2008-11-21 15:33:13.0Z
Reply-To: "Frank Steinmann" <Frank.Steinmann@cs-edv.de>
From: "Frank Steinmann" <Frank.Steinmann@cs-edv.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4926801f$1@forums-1-dub> <4926a996$1@forums-1-dub> <4926c68d$1@forums-1-dub>
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
Lines: 27
Organization: CS-Software E. GmbH
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: <4926d4b9@forums-1-dub>
Date: 21 Nov 2008 07:33:13 -0800
X-Trace: forums-1-dub 1227281593 10.22.241.152 (21 Nov 2008 07:33:13 -0800)
X-Original-Trace: 21 Nov 2008 07:33:13 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88219
Article PK: 417473

i have computed Fields. I didn't list them in "updateable columns". however,
powerbuilder is using them for building the where-statement.
I'm using ASA902. If you have computed columns, you can only take the
where-clause "only key columns"

I dont have any problem, i only wanted to tell about, if a column is not
updateable, it should not be uses for the where-statement.

Greetings Frank

"Jason 'Bug' Fenter [TeamSybase]"
<NO_SPAMMING_jason.fenter_@_teamsybase.com> schrieb im Newsbeitrag
news:4926c68d$1@forums-1-dub...

> Also, what are the data types of the updateable columns? And are there any
> triggers on the updated table?
>
>
> Chris Pollach wrote:
>> Hi Frank;
>>
>> This feature is working great for me (PB 11.2 build 8407).
>>
>> 1) What DBMS are you using?
>> 2) What DB connectivity mechanism are you using?
>>


Chris Pollach Posted on 2008-11-21 16:10:08.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4926801f$1@forums-1-dub> <4926a996$1@forums-1-dub> <4926c68d$1@forums-1-dub> <4926d4b9@forums-1-dub>
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
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: <4926dd60$1@forums-1-dub>
Date: 21 Nov 2008 08:10:08 -0800
X-Trace: forums-1-dub 1227283808 10.22.241.152 (21 Nov 2008 08:10:08 -0800)
X-Original-Trace: 21 Nov 2008 08:10:08 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88220
Article PK: 417474

Hi Frank;

Correct, for SQL computed columns you need to use the "Key only" option.

You have two other choices (IMHO) to get around this avenue where optimistic
locking is required - they are: 1) use a 2nd DWO to perform the updating
that has NO CC's or 2) convert the SQL Computed columns to either dummy
retrieval arguments (can be included in the DW objects) or better yet DW
Computed columns.

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

"Frank Steinmann" <Frank.Steinmann@cs-edv.de> wrote in message
news:4926d4b9@forums-1-dub...
>i have computed Fields. I didn't list them in "updateable columns".
>however, powerbuilder is using them for building the where-statement.
> I'm using ASA902. If you have computed columns, you can only take the
> where-clause "only key columns"
>
> I dont have any problem, i only wanted to tell about, if a column is not
> updateable, it should not be uses for the where-statement.
>
> Greetings Frank
>
> "Jason 'Bug' Fenter [TeamSybase]"
> <NO_SPAMMING_jason.fenter_@_teamsybase.com> schrieb im Newsbeitrag
> news:4926c68d$1@forums-1-dub...
>> Also, what are the data types of the updateable columns? And are there
>> any triggers on the updated table?
>>
>>
>> Chris Pollach wrote:
>>> Hi Frank;
>>>
>>> This feature is working great for me (PB 11.2 build 8407).
>>>
>>> 1) What DBMS are you using?
>>> 2) What DB connectivity mechanism are you using?
>>>
>
>


M. Searer Posted on 2008-11-21 17:34:03.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4926801f$1@forums-1-dub> <4926a996$1@forums-1-dub> <4926c68d$1@forums-1-dub> <4926d4b9@forums-1-dub> <4926dd60$1@forums-1-dub>
In-Reply-To: <4926dd60$1@forums-1-dub>
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
Lines: 53
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4926f10b@forums-1-dub>
Date: 21 Nov 2008 09:34:03 -0800
X-Trace: forums-1-dub 1227288843 10.22.241.152 (21 Nov 2008 09:34:03 -0800)
X-Original-Trace: 21 Nov 2008 09:34:03 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88221
Article PK: 417475

bug or needed enhancement?
either way, the dw has the sql, so it should be smart enough to not include it.

"Chris Pollach" <cpollach@travel-net.com> wrote in message news:4926dd60$1@forums-1-dub...
> Hi Frank;
>
> Correct, for SQL computed columns you need to use the "Key only" option.
>
> You have two other choices (IMHO) to get around this avenue where optimistic
> locking is required - they are: 1) use a 2nd DWO to perform the updating
> that has NO CC's or 2) convert the SQL Computed columns to either dummy
> retrieval arguments (can be included in the DW objects) or better yet DW
> Computed columns.
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Frank Steinmann" <Frank.Steinmann@cs-edv.de> wrote in message
> news:4926d4b9@forums-1-dub...
>>i have computed Fields. I didn't list them in "updateable columns".
>>however, powerbuilder is using them for building the where-statement.
>> I'm using ASA902. If you have computed columns, you can only take the
>> where-clause "only key columns"
>>
>> I dont have any problem, i only wanted to tell about, if a column is not
>> updateable, it should not be uses for the where-statement.
>>
>> Greetings Frank
>>
>> "Jason 'Bug' Fenter [TeamSybase]"
>> <NO_SPAMMING_jason.fenter_@_teamsybase.com> schrieb im Newsbeitrag
>> news:4926c68d$1@forums-1-dub...
>>> Also, what are the data types of the updateable columns? And are there
>>> any triggers on the updated table?
>>>
>>>
>>> Chris Pollach wrote:
>>>> Hi Frank;
>>>>
>>>> This feature is working great for me (PB 11.2 build 8407).
>>>>
>>>> 1) What DBMS are you using?
>>>> 2) What DB connectivity mechanism are you using?
>>>>
>>
>>
>
>


Michael Kramer Posted on 2009-01-28 16:49:08.0Z
From: "Michael Kramer" <mkr@geokon.dk>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4926801f$1@forums-1-dub> <4926a996$1@forums-1-dub> <4926c68d$1@forums-1-dub> <4926d4b9@forums-1-dub>
Subject: Re: updateable columns - does not work with "Key and Modified Columns"
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49808c84$1@forums-1-dub>
Date: 28 Jan 2009 08:49:08 -0800
X-Trace: forums-1-dub 1233161348 10.22.241.152 (28 Jan 2009 08:49:08 -0800)
X-Original-Trace: 28 Jan 2009 08:49:08 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88685
Article PK: 417939

There is actually a way around this problem. Same problem occurs if you have
columns from multiple tables and user can edit columns from both tables
although you only update one table in the database.

The trick is to use the undocumented DW column property UpdateWhereClause.
By default this property is UpdateWhereClause=yes.
You may set it using dw.Modify("mycomputedcolumn.updatewhereclause='no'")

I wrote a PFC DW service that sets the updatewhereclause to 'no' for all
columns outside the table being updated. That service needs augmentation to
ensure it also sets the property to 'no' for computed columns. If you have
difficulties with precision of floating numbers you might also set such
columns to 'no'.

Look at [Edit Source] for your DataWindow to get a feel for the columns and
their attributes.


HTH
/MicKr-
Michael Kramer, Denmark

"Frank Steinmann" <Frank.Steinmann@cs-edv.de> wrote in message
news:4926d4b9@forums-1-dub...
>i have computed Fields. I didn't list them in "updateable columns".
>however, powerbuilder is using them for building the where-statement.
> I'm using ASA902. If you have computed columns, you can only take the
> where-clause "only key columns"
>
> I dont have any problem, i only wanted to tell about, if a column is not
> updateable, it should not be uses for the where-statement.
>
> Greetings Frank
>
> "Jason 'Bug' Fenter [TeamSybase]"
> <NO_SPAMMING_jason.fenter_@_teamsybase.com> schrieb im Newsbeitrag
> news:4926c68d$1@forums-1-dub...
>> Also, what are the data types of the updateable columns? And are there
>> any triggers on the updated table?
>>
>>
>> Chris Pollach wrote:
>>> Hi Frank;
>>>
>>> This feature is working great for me (PB 11.2 build 8407).
>>>
>>> 1) What DBMS are you using?
>>> 2) What DB connectivity mechanism are you using?
>>>
>
>