Subject Re: [firebird-support] Inserting Rows into DB
Author Martijn Tonies
Hello Rick,

>I have successfully created a Firebird Database, table and am now ready to
>insert some test data. I've read about the INSERT FROM syntax.

Make that INSERT INTO ;-)

>It appears that the examples insert one row at a time using the VALUES
>clause. In my program I will read from a CSV or Random Access file or get
>some data for several rows, perhaps 30 to 100 in some other way, then want
>to insert these new rows into the FB database table. Is there some syntax
>to build multiple VALUES list entries and insert them with one execute
>statement I can research further?

No, there's currently no such thing, only 1 row can be inserted with a
VALUES clause.

>Or, do I have to loop through the logic to define the COLUMN VALUES for
>row and perform an EXECUTE for each row I want to insert?
>I'm considering performance, of course.

You have to "execute" for each new row.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!