🚀 go-pugleaf

This sounds very strange to me why you want to do what you are asking, I
would relook at the keys I have created in the table and change them or
remove them completely (but I probably may not understand your question
fully).  The other way is to use the Locate function of the table and only
append records that are not located

if(!Table1->Locate("KeyField","New Value",TLocateOptions()))
    {
      Table1->Append()  //or Table1->Insert();
      Table1->FieldByName("KeyField")="New Value";
      Table1->Post();
    }


"Robert Emmons" <remmons@aurigen.com> wrote in message
news:oe5460dfppnhmbe99n4500cudggmntqhet@4ax.com...
> I am using a TADOQuery to insert records in a Microsoft Access 2000
> (MSA) database table.  If I run the query in MSA I get the opportunity
> to ignore any key violations and append the records which do not
> create key violations.  However, I see no such option in the TADOQuery
> class.  If there is a single key violation, it refuses to append *any*
> of the records.
>
> My work around is to use a select and delete query to delete the key
> violation records, but I'd prefer a simpler way.
>
> Is there a way or property to set the TADOQuery to append the records
> without key violations, and omit those with violations?
>