Hi,
I have a strange problem while PUSHing data to SQL server from mobile
device. I'm using batchon option. If the connection crashes while the
PUSH method is running, normally an exception thrown and none of the
rows are inserted on server and none of the rows are deleted from the
mobile device. Then I re-RUSH the table and there's no problem. But
sometimes when the connection goes off, all rows of the table can be
pushed but cannot be deleted from the table on mobile device. So when
I re-PUSH the table, the PUSH method try to push the same rows again
and I get primary key violation.
Any ideas?
Regards,
Aykut
|
Similar Threads
