HELP!!!! Upload table records deletes existing records instead of appending.

  • Thread starter Thread starter rbagley
  • Start date Start date
R

rbagley

You put data I the history table on the device, then do an upload only
to Sql Sever history table, then after the sync is complete I delete
all records from the device history table. Problem is if I do a sync
again it removes all existing records from the previous sync from SQL
Server history table. I need to be able to append all new records to
the Sql Server history table and the remove them from the devices
databases history table.

Thank you
Rodney
 
Thats pretty much the idea of 'sync', ie keeping the tables in sync.
I've not much experience of the 'sync' methods so can't say whether it
can be configured to work in a way suitable to your requirements.
Alternatively, try looking at the RDA SubmitSQL method to run "insert"
sql statements.

Chris
 
Back
Top