Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
....Recordset.find Error
Message
De
16/12/1999 09:29:45
 
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00304573
Message ID:
00304625
Vues:
24
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform