🚀 go-pugleaf

There is only one method.  The key value is being cast to a single element
Variant array internally.  Since there is only one key field, only the first
element is being accessed, so all is ok.  For consistancy, you could code it
as follows:

TLocateOptions options;
TVariant vKeys[1];
vKeys[0] = "KeyValue";

TADOTable->Locate( "FieldName", vKeys, options );

If you need more than one key field, increase the array size and assign the
indicies accordingly.

Mark

"Kim L. Utley" <kimutley@coserv.net> wrote in message
news:3dbac521@newsgroups.borland.com...
> Hello,
>
> I figured out that when calling Locate() using a single key field you
should
> not create a Variant for the key value but simply pass the value itself
> (e.g., TADOTable->Locate( "FieldName", "KeyValue", options ); ). However,
I
> would like to not have separate methods of calling Locate() depending on
the
> number of field names. Is there a way to accomplish this?
>
> TIA,
>
> Kim
>
> > Hello,
> >
> > I'm getting an exception "Could not convert variant of type (Array
> Variant)
> > in type (String)" when the Locate() function is called. In my
application
> I
> > need to dynamically create the field name(s) and key value(s) although
in
> my
> > example I'm hard coding the data for testing. Most of the time they will
> be
> > strings but other data types will need to be used.
> >
> > Any help would be appreciated.
> >
> > TIA,
> >
> > Kim
> >
> >  int   bounds[2] = { 0, 1 };
> >  Variant  keyVal = VarArrayCreate( bounds, 1, varVariant);
> >
> >  keyVal.PutElement( "01-01-0002", 0 );
> >
> >  bool success = adoTable->Locate( "AccountNumber", keyVal, opts );
> >
> >
>
>