Page 1 of 1

Multiple Updates of the same DataSet

Posted: Sat 20 Nov 2004 13:11
by nuntio2000
Hi,
I'm using your procedure CopyDataSet to insert new data in the database. I've left the PK of my Dataset setted to NULL and the MySQLDirect performs a perfect update process.
Well, but how can i avoid multiple update of the same data?
The remote Database is very big, so i think that to fill a local dataset and
use Data.Merge to find the diff could be really hard.
Do you have some idea to help me?

Re: Multiple Updates of the same DataSet

Posted: Mon 22 Nov 2004 11:16
by Oleg
You can fill your key field values as it was described in topic How do I retrieve an Auto Increment Primary Key after Insert