SQL Mobile CE - Removing records from table with RDA TrackingOn

[iKiLL]

Hi all,

I am sure that some one has solved this problem before.
i am using RDA to do Data syncronisation from SQL CE to SQL2005.

It seems that if you PULL a Table with TrackingOn and then delete the Record
from the server. It does not get reflected on the PDA after next PUSH.

It also seems that if you Delete a Record from the PDA it DOES get deleted
from the server.

And Finaly if you try to edit the record that is now deleted from the Server
but not the PDA and then sync it you get an error record.

What i would like is.

I have and audit record on the PDA when that Audit is completed it the gets
sent back to the server and removed from the PDA.

The problem is i have Heaps of Audits and i am trying to keep the Trafic
down as it will be syncing over GPRS, so i don't want to have to rePULL All
the audit data. However there is no need for it to be on the PDA once it has
been completed.

Does any one have any sugestions to this problem?

Thanks
ink

 

[iKiLL]

From alot of testing and reading i think i am convinced that there is no
solution to this problem.

So i have decided to use Merge Replication instead.