SQL Anywhere Mobile - Behaviour of Download cursor

Author

Behaviour of Download cursor

Roy

2005-06-09, 7:24 am

9.0.2.2451

How does the download cursor work for record update? Just update the record
or delete and then insert? Thanks!

Breck Carter [TeamSybase]

2005-06-09, 7:24 am

The download_cursor script runs on the consolidated database so it has
no idea whether the rows already exist on the remote or not. The
dbmlsync client uses the primary key to determine that, then does
inserts or updates as required.

Breck

On 9 Jun 2005 02:50:03 -0700, "Roy" <abc@abc.com> wrote:

>9.0.2.2451
>
>How does the download cursor work for record update? Just update the record
>or delete and then insert? Thanks!
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

David Fishburn

2005-06-10, 1:24 pm

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
news:a4ega1pngcekhv2
gajlk8i47h03a9bqlcm@
4ax.com of
sybase.public.sqlanywhere.mobilink:

BC> The dbmlsync client uses the primary key to determine that, then
BC> does inserts or updates as required.

Not quite, it uses this form of the INSERT statement:
INSERT INTO table_name ...
ON EXISTING UPDATE
VALUES(...)

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links