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.

datastore update problems

4 posts in Appeon (partner product) Last posting was on 2008-07-31 15:15:45.0Z
Tim Posted on 2008-07-11 19:20:59.0Z
Sender: 7012.4877aec1.1804289383@sybase.com
From: Tim
Newsgroups: sybase.public.appeon
Subject: datastore update problems
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4877b29b.70a7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Jul 2008 12:20:59 -0700
X-Trace: forums-1-dub 1215804059 10.22.241.41 (11 Jul 2008 12:20:59 -0700)
X-Original-Trace: 11 Jul 2008 12:20:59 -0700, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2175
Article PK: 13316

We have many datawindows that build their sql dynamically.
When we try to update a datastore with one of these dw's as
dataobject, we get "row changed between retrieve and update"
and update sql is built w question marks; e.g., update table
set column_a = ? where column_b = ? and column_c = ?...
We ran Appeon's sql script for dynamic dw fix which created
two procedures, but still get problem. What I don't
understand is how are procedures executed? I'm working with
Appeon support but they can't seem to tell me if fix is
applied correctly or not. Do we need to add code to execute
procs? Can someone tell me how to confirm that fix is
applied correctly? Or is this not the dynamic dw problem?
Appeon 6, PB 10.5.2, EAServer 6.1, XP SP 2, Oracle 10

Thanks for any insight
Tim


Steven Posted on 2008-07-18 09:30:15.0Z
Sender: 2276.487c4f8d.1804289383@sybase.com
From: Steven
Newsgroups: sybase.public.appeon
Subject: Re: datastore update problems
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <488062a7.3f84.1681692777@sybase.com>
References: <4877b29b.70a7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2008 02:30:15 -0700
X-Trace: forums-1-dub 1216373415 10.22.241.41 (18 Jul 2008 02:30:15 -0700)
X-Original-Trace: 18 Jul 2008 02:30:15 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2178
Article PK: 13318

Hi Tim,
Could you provide a reproducible sample?

Regards,
Steven


Paul Horan[TeamSybase] Posted on 2008-07-18 17:22:52.0Z
From: "Paul Horan[TeamSybase]" <phoran_nospam@sybase.com>
Newsgroups: sybase.public.appeon
References: <4877b29b.70a7.1681692777@sybase.com>
Subject: Re: datastore update problems
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880d16c$1@forums-1-dub>
Date: 18 Jul 2008 10:22:52 -0700
X-Trace: forums-1-dub 1216401772 10.22.241.152 (18 Jul 2008 10:22:52 -0700)
X-Original-Trace: 18 Jul 2008 10:22:52 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2179
Article PK: 21558

Make sure the datawindow has its Update Properties set to Key and Modified
Columns. It sounds like you're having that set to Key and Updateable
Columns.

Paul Horan[TeamSybase]

<Tim> wrote in message news:4877b29b.70a7.1681692777@sybase.com...
> We have many datawindows that build their sql dynamically.
> When we try to update a datastore with one of these dw's as
> dataobject, we get "row changed between retrieve and update"
> and update sql is built w question marks; e.g., update table
> set column_a = ? where column_b = ? and column_c = ?...
> We ran Appeon's sql script for dynamic dw fix which created
> two procedures, but still get problem. What I don't
> understand is how are procedures executed? I'm working with
> Appeon support but they can't seem to tell me if fix is
> applied correctly or not. Do we need to add code to execute
> procs? Can someone tell me how to confirm that fix is
> applied correctly? Or is this not the dynamic dw problem?
> Appeon 6, PB 10.5.2, EAServer 6.1, XP SP 2, Oracle 10
>
> Thanks for any insight
> Tim


Tim Posted on 2008-07-31 15:15:45.0Z
Sender: 212a.4891d495.1804289383@sybase.com
From: Tim
Newsgroups: sybase.public.appeon
Subject: Re: datastore update problems
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4891d721.2174.1681692777@sybase.com>
References: <4880d16c$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Jul 2008 08:15:45 -0700
X-Trace: forums-1-dub 1217517345 10.22.241.41 (31 Jul 2008 08:15:45 -0700)
X-Original-Trace: 31 Jul 2008 08:15:45 -0700, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2186
Article PK: 21562

Thanks for the response.
The K+U setting works when running in PB, it's only a
problem in Appeon. However, it apparently IS related to the
update properties: I created a test dw using same dataobject
and successfully updated when using K+M instead of K+U. But
when running app normally, it still does not work with the
K+M setting. The app uses a framework(not PFC) and I feel
it's something to do w the way datastore refs are passed
thru the framework and/or the way data is being set on the
datastores. There's a lot of dynamic processing. But it's
hard to troubleshoot w/out knowing what Appeon is doing; I
don't know what to look for. And it's difficult to create a
test case for Tech Support because of the framework's
complexity.
Again, thanks for insight/ideas.

> Make sure the datawindow has its Update Properties set to
> Key and Modified Columns. It sounds like you're having
> that set to Key and Updateable Columns.
>
> Paul Horan[TeamSybase]
>
> <Tim> wrote in message
> > news:4877b29b.70a7.1681692777@sybase.com... We have many
> > datawindows that build their sql dynamically. When we
> > try to update a datastore with one of these dw's as
> dataobject, we get "row changed between retrieve and
> > update" and update sql is built w question marks; e.g.,
> > update table set column_a = ? where column_b = ? and
> > column_c = ?... We ran Appeon's sql script for dynamic
> > dw fix which created two procedures, but still get
> > problem. What I don't understand is how are procedures
> > executed? I'm working with Appeon support but they can't
> > seem to tell me if fix is applied correctly or not. Do
> > we need to add code to execute procs? Can someone tell
> > me how to confirm that fix is applied correctly? Or is
> > this not the dynamic dw problem? Appeon 6, PB 10.5.2,
> EAServer 6.1, XP SP 2, Oracle 10 >
> > Thanks for any insight
> > Tim
>
>