Allies Xposs wrote:

> I HAVE 2 DATABASE
> 1. MYOFF.GDB
> A. TABLE : MYSS08
>
> 2. MYXPOSS.GDB
> A. TABLE : MYSS
>
> HOW CAN I INSERT FROM MYXPOSS-MYSS TO MYOFF-MYY08??
> (SQL COMMAND)
>
> I DEVELOP WITH CLIENTDATASET:
>
> sOURCE :
>
> WHILE NOT IBCLIENTDATASET.EOF DO
> BEGIN
> // IM USE SQLCOMMAND
> IBQUERY.CLOSE;
> IBQUERY.SQL.CLEAR;
> IBQUERY.SQL.ADD('INSERT INTO MYSS (P_TGL,P_ORD,......) VALUES ( IBCLIENTDATASET['P_TGL'],.......);
> IBQUERY.EXECSQL;
> IBCLIENTDATASET.DELETE;
> END;
>
> THATS SO SLOW.....1 RECORD NEED 1 SECOND TIME...
>
> HELP... GIVE ME A GOOD IDEA...
>
> THANKS....
> BES REGARD ALLIES
>
>
>

Use prepared statements.

see you !

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