Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do multiple find ?
Message
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00384377
Message ID:
00387519
Views:
39
Yees, now I can see it. So, it's available in ADO 2.5 only.

Thank you Eric


>>Eric,
>>
>>Thank you for this information.... but the problem still there..
>>as I told you befor I can't use Filter and as u said Find does not work for multi cariteria... what is left is Seek and this what I want but I can't find it in the record set objects and I searched for it in the "Object Browser" and I found it in the VBA & DAO only.
>>
>>what Iam missing man...
>>
>
>You need at least ADO 2.5 in order to use the Seek method of the Recordset Object. Notice that not all provider are supporting Seek.
>
>Here is what the help file says about Seek:
>
Searches the index of a Recordset to quickly locate the row that matches the specified values, and changes the current row position to that row.
>
>Syntax
>
>recordset.Seek KeyValues, SeekOption
>
>Parameters
>
>KeyValues   An array of VARIANT values. An index consists of one or more columns and the array contains a value to compare against each corresponding column.
>
>SeekOption   A SeekEnum value that specifies the type of comparison to be made between the columns of the index and the corresponding KeyValues. Can be one of the following comparison constants.
>
>Constant Description
>adSeekAfterEQ Seek either a key equal to KeyValues or just after where that match would have occurred.
>adSeekAfter Seek a key just after where a match with KeyValues would have occurred.
>adSeekBeforeEQ Seek either a key equal to KeyValues or just before where that match would have occurred.
>adSeekBefore Seek a key just before where a match with KeyValues would have occurred.
>adSeekFirstEQ Seek the first key equal to KeyValues.
>adSeekLastEQ Seek the last key equal to KeyValues.
>
>
>Remarks
>
>Use the Seek method in conjunction with the Index property if the underlying provider supports indexes on the Recordset object. Determine whether the underlying provider supports indexes with the Supports (adIndex) method.
>
>If Seek does not find the desired row, no error occurs, and the row is positioned at EOF. Set the Index property to the desired index before executing this method.
>
>This method can only be used when the Recordset object's CursorLocation property has a value other than adUseClient.
>
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>
Previous
Reply
Map
View

Click here to load this message in the networking platform