Subject Re: [firebird-support] Inserting Rows into DB
Author Andre Dostal
Richard Thomas wrote:
> Hi All:
> Or, do I have to loop through the logic to define the COLUMN VALUES for each
> row and perform an EXECUTE for each row I want to insert?
> I'm considering performance, of course.
When you have a large amount of data you can use "prepared" inserts. For fixed
length text data you can use an external table
(see Re: [firebird-support] Importing large amount of data, thanks Martijn).

> Just some keywords would help me research further as I've been through many
> GOOGLE pages and only found the FROM where it uses another SELECT statement
> on a DB TABLE to supply VALUES in this way.
> Thanks for any pointers.
> By the Way, all your help has worked and I'm now able to use Firebird with
> Liberty Basic under the ODBC32 Driver Manager!
> Rick Farmington Mich. USA

Best wishes/Liebe Grüße aus einem sonnigen Wien