Subject Re: [firebird-support] Re: Problem in Bulk Insertion in Firebird - Please Help
Author Alexandre Benson Smith
Manish Lal Joshi wrote:

> Now after i created the external table,
> i queried the table like select col1,col2 from ext_table
> while(
> {
> (a) getvalues
> (b) typecast it
> (c) insert into my real table.
> }

Here is where you have made a mistake...

Use the server to do the work.

Use a single statement to insert all rows from your external table,
something like:

insert into Table (ColumnA, ColumnB, ColumnC) select ColumnA, ColumnB,
ColumnC from ExternalTable

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil