FindKey - weird error
C++ Builder 2007 + NexusDB 3.09
I have a simple table with a WideString field and an int32 field, both of which are in an index.
I want to use FindKey to find a record so I use this syntax:
TVarRec vr = (path, map);
(path is a WideString and map is an int. Both have valid values).
The call to FindKey always fails with the message 'Invalid Value for Field DriveMap'.
If I change my code to use SetRangeStart() (etc) with the same values it works ok.
If I change my WideString search variable to a regular AnsiString then the call to FindKey succeeds. So it looks to me that there's a bug either in Nexus v3.09 or in C++ Builder 2007 (or both) with using FindKey (and the other Find... functions) when one of the parameters is a WideString.
Other than giving up on the Find functions, does anyone know a way to make this work?
Re: FindKey - weird error
> Invalid Value
It's possible the error is raised in
TnxIndexDataSet.idRefIndexSetFields, in unit nxdb.pas.
It indicates either a problem with the array passed in, or the type
used in the variant record. There are several types available for
strings; check type you are using against the types supported in the
|Thread||Thread Starter||Forum||Replies||Last Post|
|Weird error message||Ole Willy Tuv||nexusdb.public.support.sql||1||9th August 2006 11:20 PM|
|Weird Query Error||Surjanto||Binaries||0||12th April 2005 06:53 PM|
|Weird error when autoinc field has value of -1||Nathan Sutcliffe||nexusdb.public.support.sql||4||1st April 2004 01:59 PM|
|Weird error when autoinc field has value of -1||Nathan Sutcliffe||Binaries||0||31st March 2004 11:33 AM|
|Weird 15465 error...||Tor Tveitane||nexusdb.public.support||3||10th December 2003 07:33 PM|