Luiz Rafael Culik Guimaraes wrote:

>Dear Friends
>
>Is their an way, via C api to execute multiples in one call to
>isc_dsql_execute_immediate()
>
>I'm getting this error when executing this command
>Dynamic SQL Error - Native error code 335544569
>Command sent to database :
>INSERT INTO AM_BAIRRO ( C_BAIRRO, NOME, LIMPEZA, ALTERADO, SETOR, DIAS,
>SR_recno ) VALUES ( '001','CENTRO','*','*','10',0, 1);INSERT INTO
>AM_BAIRRO ( C_BAIRRO, NOME, LIMPEZA, ALTERADO, SETOR, DIAS, SR_recno )
>VALUES ( '002','VILA ARAPUTANGA','*',' ',' ',0, 2);INSERT INTO
>AM_BAIRRO ( C_BAIRRO, NOME, LIMPEZA, ALTERADO, SETOR, DIAS, SR_recno )
>VALUES ( '003','VILA GOIAS','*',' ',' ',0, 3);
>
>Any ideia?
>
>REgars
>Luiz
>
>

Luiz,

AFAIK you should use prepared statements and send one at a time.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br