Hello Helen,

I forgot to write in the e-mail the word " into ". THE complete script below is what gives the problem mentioned in the previous e-mail:

CONNECT 'C:\Maxiteq\MBA\Dados\LCCosta\MBA2001.GDB' USER 'ABDMBA2001MXQ' PASSWORD 'aqbxdmm1b0a02';
EXEC SQL
set transaction;


insert into produto (CODIGO, DESCRICAO, DESCRICAORESUMIDA, REFERENCIA, COD_UNIDADE_COMPRA, COD_UNIDADE_VENDA, COD_GRUPOPRODUTO, COD_CLASSEPRODUTO, ATIVO, COD_TIPOPRODUTO, COD_SITUACAOTRIBUTARIA, BASEICMS, PRODUTOCOMPOSTO)
select
CODIGO, DESCRICAO, DESCRICAO, REFERENCIA, UNICOMPRA, UNIVENDA, GRUPO, CLASSE, SITUACAO, '00', '00', 100, '0'
FROM PXprodutos WHERE CODIGO >= 15590;
delete FROM PXPRODUTOS WHERE CODIGO >= 15590;
commit;
EXEC SQL
disconnect;

Thank you

Humberto


Helen Borrie <helebor@...> wrote:At 08:46 PM 10/03/2003 +0000, you wrote:

>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

Insert into Clientes (Campo1, campo2, campo3)
select xCampo1, xCamp02, xCampo3
from XClientes ;

>
>this same command, with the limitation of the number of records,
>executes with success.

I would be extremely surprised if it did.

heLen



Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Busca Yahoo!
O serviço de busca mais completo da Internet. O que você pensar o Yahoo! encontra.

[Non-text portions of this message have been removed]