You could always use direct SQL Insert into table xyz select blah blah from pqr where criteria met
This syntax is valid in InterBase and has been since 5.x at least so it should work in Firebird... --- Richard Vowles, Solutions Architect, Borland New Zealand email: [EMAIL PROTECTED] phone: +64-9-9184573 cell: +64-21-467747 other: MSN [EMAIL PROTECTED], skype: rvowles -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Lowman Sent: Tuesday, 9 August 2005 5:19 p.m. To: Delphi List Subject: [DUG] Firebird copying tables Whats the best way of copying selected records from one database/table to another database/table. I am currently doing it one by one and it is very slow ... ;-( Cheers Paul Lowman _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
