[DUG] Firebird copying tables

[Richard Vowles]

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: richard.vowles at borland.com
phone: +64-9-9184573
cell: +64-21-467747
other: MSN richard.vowles at borland.com, skype: rvowles

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
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
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi