I have been using the Picture example and adapting it to update images and data from pocket pc 2005 to MYSQL tables.
The statement
SELECT * FROM mysqlnet_pictures ORDER BY UID DESC LIMIT 1
limits the amount of information I have to download to 1.
The following works fine on update
Cursor.Current = Cursors.WaitCursor;
if (dataSet.Tables.Count != 0)
mySqlDataAdapter.Update(dataSet, "Table");
However this does not work when the tables have been updated by another user as it creates duplicate UID numbers.
How do I change the above to Insert the new records into the table.
Cheers
SteveW