I'm sure this is possible, how do I get started?<BR>Instead of doing a delete here I would like to move the record to another table . <BR><BR> Do Until valid = objRs("num") <BR> objRs.MoveNext<BR> Loop<BR> objRs.Delete
.. to first insert the record into the 2nd table and then delete it from the first.<BR><BR>You can do all of this with straight SQL so that ASP doesn't have to do the work.<BR><BR>To put the record from Table1 into Table2, you would do somethine like:<BR>sSQL = "INSERT INTO Table2 (FieldA, FieldB, FieldC) " & _<BR> "SELECT FieldA, FieldB, FieldC " & _<BR> "FROM Table1 " & _<BR> "WHERE RecordID = " & valid<BR>ConnectionObj.Execute sSQL<BR><BR>sSQL = "DELETE FROM Table1 " & _<BR> "WHERE RecordID = " & valid<BR>ConnectionObj.Execute sSQL
If ur DB is Oracle.... Execute this query first<BR><BR>Insert into Table2 Select * From Table1;<BR>Similar query is also available in SQL Server. You need not use Recordset for this....<BR><BR>Then you can issue command to delete the records from first table.