Does just

VarArrayOf([parm1,parm2]) work ?

I just use

SQLCDF.Locate('Code',FTMSmain.ClientCode,[lopartialKey]);

=================================

Tobias Giesen wrote:

>
> Hi!
>
> I think the TIBQuery.Locate method has a pitfall which should be removed.
>
> I tried to pass my desired field values as am array of this type:
> VarArrayCreate( [0,2], varOleStr);
>
> I expected that since elsewhere, many things are done via a field's string
> representation, that this would work here also. It didn't. I had to use an
> array such as this:
> VarArrayCreate( [0,2], varVariant);
>
> In the former case there had been no error message, no hint, nothing, it
> simply returned false.
>
> Cheers,
> Tobias
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/