Board index » Visual Basic/VB

All times are UTC



 Seek Nearest Match if exact match not found ? 
Author Message
Luqma
#1 / 2
 Seek Nearest Match if exact match not found ?

Using Seek of ADO, If I search for 12 and it is not found, the match should
return nearest to the match say, 11 or 14. Is it possible ?

Just like "Set Near On" command in Foxpro.

Best Regards,

Luqman



Tue, 23 Mar 2004 16:16:07 GMT  
Hercules Gunte
#2 / 2
 Seek Nearest Match if exact match not found ?
Look up the Seek Method (ADO) in MSDN, and also SeekEnum - explains all.
Quote:

> Using Seek of ADO, If I search for 12 and it is not found, the match should
> return nearest to the match say, 11 or 14. Is it possible ?

> Just like "Set Near On" command in Foxpro.

> Best Regards,

> Luqman



Wed, 24 Mar 2004 01:37:17 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Seek Nearest Match if exact match not found ?

2. Using FIND method to get Exact match

3. using Find Method for Exact match

4. non-exact matches

5. exact matches in an array

6. Exact match in array?

7. RegExp question: match within another match

8. Filefirstfile api , find in win95 and dos dir /s do not match

9. How to refresh Form after seek method match

10. Seek sometimes doesn't match record

11. Finding records that don't match

12. Testing to see if a filter found any matches

  

 
Powered by phpBB® Forum Software