Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter for view, type mismatch
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00263501
Message ID:
00263567
Views:
20
Mary-Ann,
What problem are you having? On the Filter tab, enter each of the variables
Field Name          Not Criteria     Example       Case     Logical
MyTable.CharVar          =            ?MyChar                 AND
MyTable.NumVar           =            ?MyNum
I just tested it and it works fine. One thing to remember, if your character variable is digits only, you must put quotes around it when the view asks for the value of the ?variable.

HTH
Barbara

>how do you set the filter tab to filter on two vars that are of character and number types. Using the QuestionMark for both vars.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform