Board index » delphi » Move records to another table

Move records to another table

What is the best way to delete several records from one table and move
them to another table?

Thanks
John  M. Freisen

 

Re:Move records to another table


Quote
John M. Freisen wrote in message <3576942F.8B960...@netincom.com>...
>What is the best way to delete several records from one table and move
>them to another table?

>Thanks
>John  M. Freisen

You have three solutions for two cases :
1. If you must transfert all records and then delete them
     take advantage of batchmove and MyTable.emptyTable
     procedure.
2 If you must transfert only some records it is better you use query
     and batchmove to transfert them then delete your record by record
     in a WHILE loop or
3 you can transfert and delete each record by record in a WHILE
     loop.

I hope this will help you !

regards !
Godinas-Andrien Alain from ADDX Computers Belgium.

Other Threads