Hi,
The Temp Table (obviously) mimics the Main Table. The Main Table has a
column, recordNo which is a integer primary key (which autoincrements). Now
I periodically move Data from the Temp into the Main Table (and then delete
records from the Temp Table). It succeeds the first time, but fails
subsequently because of duplicate recordNo values (I presume).
Do I have to maintain the last recordNo value in the Main Table and pass it
to the Temp Table so that it starts using those values during insertion to
avoid a clash? Is there a better way of working around this problem?
Thanks!
