squarefish
06-14-2005, 10:45 AM
I have developed an application that runs on handheld devices which lets the user download a record from a table in a database, add some info and save it back to the database.
The only problem is that the record saved back HAS to be saved to a different table in the database. So now you have two records in two tables that hold the same data - but one is incomplete.
My question is - Is it possible to has some kind of script that sits on a website and checks these two tables for any records that have the same uniqueID (it is the same for both tables) and update the first table with the values in the second table?
The reason it has to save it to the second table in the first place it that the application has been developed with a RAD Tool that only allows you to save to a different table to the one you got the record from.
Any help, or others ideas on how to achieve the same result will be greatly appreciated.
Regards
Richard Fuller
The only problem is that the record saved back HAS to be saved to a different table in the database. So now you have two records in two tables that hold the same data - but one is incomplete.
My question is - Is it possible to has some kind of script that sits on a website and checks these two tables for any records that have the same uniqueID (it is the same for both tables) and update the first table with the values in the second table?
The reason it has to save it to the second table in the first place it that the application has been developed with a RAD Tool that only allows you to save to a different table to the one you got the record from.
Any help, or others ideas on how to achieve the same result will be greatly appreciated.
Regards
Richard Fuller