PDA

Click to See Complete Forum and Search --> : ADO Seek on Jet-Access with multi-column key

SilvioArdito
March 3rd, 2003, 02:16 AM
hi

I am working with MSVC 6.0 C++, ADO, Jet, .mdb.
When i use the -Seek- method on a recordset with the a single-column key, all is OK.
I am not able to use the same method on a multi-column key.
Thanks.

Silvio
antares686
March 3rd, 2003, 04:23 AM
See the following KB Article

ACC2000: How to Use the Seek Method with a Multiple-Field Index (http://support.microsoft.com/default.aspx?scid=kb;en-us;210445)
SilvioArdito
March 3rd, 2003, 07:58 AM
All MS examples are in Visual Basic, I am working with C++.
After the construction of the safe array for es.: Customer (first column) + Invoice Number (second column), it seems that the Seek method does not take in account the content of the Invoice Number.
Probably the safe array is not well done.