error with key violation....

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by AMG Fri, 14 Sep 2001 14:39

#506

Author: AMG
Date: Fri, 14 Sep 2001 14:39

45 lines
1804 bytes

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

Re: error with key violation....

#507

Author: Tharun Pillay
Date: Sat, 15 Sep 2001 07:27

4 lines
1066 bytes

There's a "key violation error" post in the sqlservers group. Maybe that
will help you.

Tharun

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads