🚀 go-pugleaf

Mark,

When I use the TVariant (TVariant vKey[1]) I get an exception "Arguments are
of the wrong type, are out of acceptable range, or are in conflict with one
another".

If I use (Variant vKey[1]) no exception and appears to fetch the correct
record.

IAE, thanks for your help.

Kim


"Mark Guerrieri" <markg11@comcast.net> wrote in message
news:3dbc6d21$1@newsgroups.borland.com...
> 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 );
> > >
> > >
> >
> >
>
>