>Hi Gregory,
>i've put that () to the my stored proc and i've created myguid c(32) on my table and also allready set defauly value that () result = it works :) thanks
>
>and additional question from me ,
>i think i will use this field for data synchronization between tables for server and sales force laptops . how would be the your synchronization syntax for this ? and also datetime stamp is important . why probably may some records has been changed . syntax will check first if record on the server will copy it to the server table and second check will be if record exist but on the laptop tables record never than server table will update
>
>how would be this ?
>
>TIA

hi Soykan,

Well I would basically do a merge of the two tables

Then for each record there are the following possibilities

(1) in tableA and not in TableB
>>> insert into tableB

(2) in tableB and not in TableA
>>> insert into tableA

(3) exists in both tableA and tableB
You can do a scatter memo name for both tableA and tableB
You then compare each property of the two objects (with a loop (amembers()) and eval or macro subsitution)
In case there's a difference you will have to decide which one takes precedence over the other and change the object property
Finally you do a gather name obj memo one one or both the tables

Cannot help you much with this, the rules for precedence will have to be set up by you