tonyscarpelli
New member
I am writing an article on using a MySql database on the Pocket PC.
Most of the writing and coding has been done, however, I'm at the point where I'm thinking about how to keep the tables on one or more devices and on the PC/Network synchronized.
I know this is a common problem with keeping normal SQL tables in sync, and I've done it with a FoxPro applciation, but here I am doing something new again, I'm not that secure in my SQL knowledge.
So here are my problems:
The tables each have an ID, auto incrementing on the PC, but not yet on the device. How do we keep the ID's in sync, or is this necessary?
We might have a records added on the PPC so now I just find the highest ID and increment it for the local table, and this might work with one device, but what happens when we have multiple PPC's when many users are adding records?
I've added flags on the tables so that the application knows which records to Add, Delete, and which have been Changed. These work when going to from the PPC to the PC. But is this the best way going from the PC to the PPC when new records have to added to the tables?
So, anyone have ideas on this type of thing?
Thanks
Most of the writing and coding has been done, however, I'm at the point where I'm thinking about how to keep the tables on one or more devices and on the PC/Network synchronized.
I know this is a common problem with keeping normal SQL tables in sync, and I've done it with a FoxPro applciation, but here I am doing something new again, I'm not that secure in my SQL knowledge.
So here are my problems:
The tables each have an ID, auto incrementing on the PC, but not yet on the device. How do we keep the ID's in sync, or is this necessary?
We might have a records added on the PPC so now I just find the highest ID and increment it for the local table, and this might work with one device, but what happens when we have multiple PPC's when many users are adding records?
I've added flags on the tables so that the application knows which records to Add, Delete, and which have been Changed. These work when going to from the PPC to the PC. But is this the best way going from the PC to the PPC when new records have to added to the tables?
So, anyone have ideas on this type of thing?
Thanks
