Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread lLoadfromstream and autoinc behavior
Wed, Jul 24 2013 10:14 PMPermanent Link

jccarta

Hi

I am develop synchronizing aplication for accounting software that using dbisam 4.28. But i need to know how is the behavior of autoinc fields when i load data with loadfromstream because in the server register transactions too. This transactions incrementing tha autoinc fields in the server.

By example in the client i have the A table with autoinc field field1 with  values of 1,2,3,4 but in the server i have other records with the same values  of field1 autoincrementing field of 1,2,3,4

What Happen with autoinc fields when i use savetostream to save rows from A table into stream file and then send files to the server  and loadfromstream this file in A table on the server. Theres a conflict and produce an exception? or the rows added on the server take 5,6,7,8 values on field1 on table A on the server.

Thank You In Advance for your answers

Regards


Juan Carlos Carta
Thu, Jul 25 2013 3:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

jccarta


I could take a guess but why not just try it and see? You'll have to test no matter what anyone tells you.

Roy Lambert

Mon, Jul 29 2013 12:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Juan,

<< What Happen with autoinc fields when i use savetostream to save rows from
A table into stream file and then send files to the server  and
loadfromstream this file in A table on the server. Theres a conflict and
produce an exception? >>

There will be an exception if you try to add rows via LoadFromStream that
already exist (via the autoinc primary index) in the target table.

Tim Young
Elevate Software
www.elevatesoft.com
Image