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.

Some DW Synchronization issues

2 posts in General Discussion (old) Last posting was on 2000-03-10 20:03:57.0Z
Vladimir Uzlaner Posted on 2000-03-10 19:20:34.0Z
Newsgroups: sybase.public.easerver
From: "Vladimir Uzlaner" <vuzlaner@telsource.com>
Organization: 209.123.44.169
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Some DW Synchronization issues
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 10 Mar 2000 14:20:34 -0500
Lines: 21
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_wI7X1Wsi$GA.251@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26643
Article PK: 157644

Hi, all

I've got some unexplainable situation during DataWindow synchronization.

Does anybody can explain it to me, please?

1. On the component side ids_data.SetChanges( ablob_1) returns -1, if there was
not changes in appropriate DataWindow on the client side which is referenced
through the blob? It is mean "Method failure"!

2. If I try SetItem() between ids_data.SetChanges( ablob_1 ) and
ids_data.Update()( on the server side ) it returns 1, but it doesn't make the
changes in DataStore:

ll_rc = ids_data.RowCount()
ll_rc = ids_data.SetItem(1, "status_cd", 'C' )
ll_rc = ids_data.Update()

Did anybody had similar problems?

Thank you,
Vladimir Uzlaner


---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Bill Burtnik Posted on 2000-03-10 20:03:57.0Z
Newsgroups: sybase.public.easerver
From: "Bill Burtnik" <bill.burtnik@cyrus-solutions.com>
Organization: 209.167.242.235
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Re: Some DW Synchronization issues
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 10 Mar 2000 15:03:57 -0500
Lines: 47
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_cLh1Evsi$GA.74@forums.sybase.com>
References: <347_wI7X1Wsi$GA.251@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26631
Article PK: 157632

SetChanges will return -1 if the blob has a length of zero. If no changes were
made on the client, GetChanges on the client will produce a blob of zero.
You need to check for the blob lenght before calling setchanges. I had
an issue where I wanted to send a blob to the server
even when changes were not made. My solution was to check the row status: if its
NotModifed!, I changed the primary key column to DataModified! and then checked
the reverse on the server. My assumption was the primary key cannot be changed
by the user, so anytime I encountered a primary key column status of
DataModified!,
I changed it back to NotModified! to prevent the row from being updated.
There may be a better solution, but I think it might be one of the only ones
to get the blob to the server. Better approach might be resultsets, but have
not tried them.



On Fri, 10 Mar 2000 14:20:34 -0500,
in powersoft.public.easerver

Vladimir Uzlaner <vuzlaner@telsource.com> wrote:
>Hi, all
>
>I've got some unexplainable situation during DataWindow synchronization.
>
>Does anybody can explain it to me, please?
>
>1. On the component side ids_data.SetChanges( ablob_1) returns -1, if there was
>not changes in appropriate DataWindow on the client side which is referenced
>through the blob? It is mean "Method failure"!
>
>2. If I try SetItem() between ids_data.SetChanges( ablob_1 ) and
>ids_data.Update()( on the server side ) it returns 1, but it doesn't make the
>changes in DataStore:
>
> ll_rc = ids_data.RowCount()
> ll_rc = ids_data.SetItem(1, "status_cd", 'C' )
> ll_rc = ids_data.Update()
>
>Did anybody had similar problems?
>
>Thank you,
> Vladimir Uzlaner
>
>
>---== Posted via the PFCGuide Web Newsreader ==---
>http://www.pfcguide.com/_newsgroups/group_list.asp

Bill