🚀 go-pugleaf

hai...

i have a problem ...
i have create temporary table with sql statement like create table....and it
create...

my program is like this...:

while (query1->EOF)
{

    if (a)
    {
        define query1;
        open query1;

        if (!query1->isempty())
        {
            define query2;
            open query2 ;
        }
    }

I append from dataset query to temporary table like this:
table1->append();
table1->fieldbyname("company_id")->asstring =
query1->fieldbyname("company_id")->asstring;
table1->post();

query ->next;
}

when recordset 50 from query , it show an error message it say key
violation....
it happens when number recordset 50....
i can check it to my temporary table and it only contain 50 record

but when i not use IF section....my program success and temporary table
contain all record from query.

anyone have a solution...
thx....
bye..

AMG