Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Filtering
Message
From
22/10/2001 11:45:47
 
 
To
22/10/2001 10:42:41
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00571634
Message ID:
00571682
Views:
17
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform