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


---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

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