Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO Filtering
Message
De
22/10/2001 11:45:47
 
 
À
22/10/2001 10:42:41
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00571634
Message ID:
00571682
Vues:
16
>All,
>
>Below is code I am using to set the filter on a recordset. I am getting the following error and don't know why. The error is: run time error '3001': The application is using arguments that are the wrong type, are out of the acceptable range, or are in conflict with one another.
>
>Here is the code: objRS.Filter = "contactname = " & txtSearch.Text

Aside from the fact that you are using VB's string concatenator, you should use quotes around the filter expression:

objRS.Filter = [contactname = "] + THISFORM.txtSearch.Value + ["]

Also, note that the filter property only applies to client-side recordsets.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform