tray this:

INSERT INTO CLIENTs(FIELD1,FEILD2,FIELD3)
VALUES (XVALUE1,XVALUE2,XVALUE3)

----- Original Message -----
From: "Humberto Reis" <humbertoreis2000@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, March 10, 2003 12:46 PM
Subject: [ib-support] connection was lost


> Hi,
>
> I am using Firebird, version 1.0.2.986, SO W2k and IBExpert/IbAdmin.
> When executing a command SQL to insert many records (above 10000) the
> connection was lost. Below the command:
>
> Insert Clientes(Campo1, campo2, campo3)
> values xCampo1, xCampo2, xCampo3
> from XClientes
>
> this same command, with the limitation of the number of records,
> executes with success.
>
> How to solve the problem?
>
> Thank you...
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>