BorlandTalk.com

Ron Sawyer · Guest

I have been trying to use the locate method to locate a database that is
indexed on two integer fields.

Database:
long BitID;
long TokenID;

I have tried a variety of ways of setting up the variant, the most
recent being:
bool Found;
Variant Tmp[] = { TokenID, MyBitID};
Found = MyBitTable->Locate("TokenID;BitID",
Tmp,
Opts);

The help indicates that I should use the OPENARRAY macro, but I can't
find any help on how to use it, so I'm turning to you guys for help.

Thanks

bcb · Guest

Hi Ron

Please try,

Variant locvalues[2];

locvalues[0] = Variant(TokenID);
locvalues[1] = Variant(MyBitID);

bool found = MyBitTable->Locate("TokenID;BitID", VarArrayOf(locvalues,1),
Opts);