Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
....Recordset.find Error
Message
From
16/12/1999 09:29:45
 
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00304573
Message ID:
00304625
Views:
25
>Dear Frinds,
>I am facing a problem in the .find syntax. I am trying to find a selected word from a DataCombo.text in the ADO or DAO but keep getting the same error
>
>"OPeration is not supported for this type of object"
>
>the syntax is :
>Data1.Recordset.FindFirst "username_a = cdUser.Text"
>I tried also with .Seek & have the same problem
>'Data1.Recordset.Seek "=", cdUser.Text
>
>Kindly, anyone can help..
>
>Regards

The correct syntax is:
Data1.Recordset.FindFirst "username_a = '" & cdUser.Text & "'"

The syntax on the Seek seems OK but you need to have an index set for the recordset that matches the expression you are searching for.
Previous
Reply
Map
View

Click here to load this message in the networking platform