Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO Filtering
Message
De
22/10/2001 11:44:18
 
 
À
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:
00571680
Vues:
22
Jim,
I think you need to include quotes:
objRS.Filter = "contactname = '" + txtSearch.text + "'"
Additionally, your code looks like VB code. If this is in VFP, you need to use the + operator instead of & to concatenate strings.

HTH
>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
>
>The contactname field is from a SQL Server Database and is type Char.
>
>Any ideas?
>
>Thanks
>
>Jim
Daniel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform