ADO syntax for <recordset>.Find method? 
Author Message
 ADO syntax for <recordset>.Find method?

Can anybody offer an example which shows how the "recordset.FIND" works?

I am replacing code from the old DAO structure and I cannot get past the
need to get an equivalent to the old <recordset>.FINDFIRST command.

the syntax I used as best as I understand the MSDN explanation is:

EmpRs.Find(EmpRs!StaffNumber Like Trim(txtID.Text), , adSearchForward)


this doesnt work. The only syntax which does parse is where the entire
structure in parenthesis is entered as a string, but then the ADO fails!

Any ideas?

Matthew



Sat, 22 Sep 2001 03:00:00 GMT  
 ADO syntax for <recordset>.Find method?
ADO Find does not support the "Like" operator.  You will need to build a
recordset using SQL to accomplish this.

The Find method is much simpler than DAO;

FindString = "Employee = 'John'"
- or -
Firstname = "John"
FindString = "Employee = ' " & Firstname & " ' "
ADOrs.Find

Quote:
>EmpRs.Find(EmpRs!StaffNumber Like Trim(txtID.Text), , adSearchForward)



Mon, 24 Sep 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. <<<<<<<<ComboBox>>>>>>>>>>>>

2. HELP >>>>>>WIN API <<<<<<<<<<

3. help me out please!!!!<<<<<<<<<<<<<<<<<<<<<<<thanks>>>>>>>>>>>>>>>>>>>>>>>>

4. <><><>HELP<><><> PCMCIA Motorola Montana 33.6

5. <<<<HELP- OLE container Control>>>>>>>>>

6. VB5<->RDO2<->ODBC<->ORACLE Procedure Problem

7. <<<Cneck Box>>>

8. <<<Gif Files>>>

9. <<<CD ROM>>>

10. <<<Win32Api.TXT>>>

11. <<<NetWork Drv>>>

12. >>>> WAV file GRAPH <<<<<<<

 

 
Powered by phpBB® Forum Software