RDA PULL Recover

[Harry Simpson]

I'm using RDA Pull and obviously you must destroy the device local table
before you can pull down a table.
I've got a problem where users may jerk the device from the cradle in the
middle of a sync....possibly right after I've deleted the local table but
before the new table is retrieved......you see the problem.

I've added a warning like "Please Wait....Syncing" but this can be
overlooked or ignored.

What's the best practice....can I simply rename the local table....pull down
the new table and then upon successful sync complete delete the renamed
table.....upon unsuccessful sync, rename the table back to the original
name?

What's the best practice or method....

THANKS in Advance!
Harry

 

[chris-s]

Couple of simple options come to mind...

1) Make an entire backup of the database before comms, then if comms
fails for whatever reason you can go back to the original.

2) Make a backup of the table only, not sure if you can just rename a
table in the db or whether you would need to dump the data into a)
another table b) an external xml file

3) Pull the NEW data into a temporary table


Regards

Chris

 

[Harry Simpson]

<<1) Make an entire backup of the database before comms, then if comms
fails for whatever reason you can go back to the original.So just use local file I/o to copy out the SDF and upon failure - copy it
back to the normal location....

Thanks for the simple solutions...i like those better!

Harry