By Ian Hammond - 3/6/2011
I have a number of datatables each contain a column labeld tableId. My configuration utility alllows the user to copy a selected table structure. One table contains the name of a database, a tablename, and a tableId. What I want to do is foreach table that contains the tableId, I want to take a copy of all the records, change the tableId to the new tableId and write the records back as new records. I can't seem to find away of doing this without actually overwriting the original data with the new tableId. Could anyone please suggest a solution, many thanks.
|
|