Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parametrized view and multiples parameters
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00430842
Message ID:
00431163
Views:
12
All you need to do is set lcWhere to whatever expression you want. That can be anything that evaluates to a value expression. Some examples:
lcWhere = '(dCreate > tdCreate or empty(tdCreate)'
lcWhere = '((X <= Y and Y > Z) or (A = B and C < A))'
lcWhere = 'x*5+3 > A-2/B'
The point is, it doesn't matter what variables you need in the WHERE clause. They can be completely different every time.

>Hi
>
>But I need establish properties every time for update the data source?
>Anyway, I create a view using eview (UT files!!!) with where like:
>where dCreate>?tdCreate or empty(?tdCreate)"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform