ADO locate record gives Multi-Step Operation Generated Errors

Thread View: borland.public.cppbuilder.database.ado

3 messages

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

3 total messages Started by Caleb Wed, 17 May 2006 12:04

#471

Author: Caleb
Date: Wed, 17 May 2006 12:04

20 lines
1424 bytes

I am trying to see if a record already exists.  Here is the code I am
using, any help would be appreciated.  It gives the error stated in
the subject.  The error occurs after the Locate statement.

    if(ADOTab->Active == true)
       ADOTab->Active = false;



    ADOTab->CursorLocation = clUseClient;
    ADOTab->TableDirect = true;
    ADOTab->TableName = "Auctions";

    ADOTabAuctions->Active = true;

    TLocateOptions Opts;

    Opts.Clear();

   if(ADOTab->Locate("ItemNo", Variant(edtItemNo->Text), Opts)){}

Re: ADO locate record gives Multi-Step Operation Generated Errors

#470

Author: Caleb
Date: Wed, 17 May 2006 12:08

24 lines
1586 bytes

ADOTab is a TADOTable*

On Wed, 17 May 2006 08:04:19 -0400, Caleb <nospam@nospam.net> wrote:

>I am trying to see if a record already exists.  Here is the code I am
>using, any help would be appreciated.  It gives the error stated in
>the subject.  The error occurs after the Locate statement.
>
>    if(ADOTab->Active == true)
>       ADOTab->Active = false;
>
>
>
>    ADOTab->CursorLocation = clUseClient;
>    ADOTab->TableDirect = true;
>    ADOTab->TableName = "Auctions";
>
>    ADOTabAuctions->Active = true;
>
>    TLocateOptions Opts;
>
>    Opts.Clear();
>
>   if(ADOTab->Locate("ItemNo", Variant(edtItemNo->Text), Opts)){}

Re: ADO locate record gives Multi-Step Operation Generated Errors

#472

Author: Caleb
Date: Wed, 17 May 2006 14:37

3 lines
1118 bytes

OK, I was able to resolve this.  It turned out the table's  column
was numeric and smaller in digits than the search string when the
error was thrown.

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