Multiple Updates of the same DataSet

Multiple Updates of the same DataSet

Postby nuntio2000 » Sat 20 Nov 2004 13:11

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?
nuntio2000
 
Posts: 19
Joined: Fri 19 Nov 2004 18:51
Location: South Italy

Re: Multiple Updates of the same DataSet

Postby Oleg » Mon 22 Nov 2004 11:16

You can fill your key field values as it was described in topic How do I retrieve an Auto Increment Primary Key after Insert
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL