Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parametized Views
Message
 
To
20/09/1998 22:15:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00138750
Message ID:
00138904
Views:
15
Hi John,
>Does the question mark only work on 5 and above?

Works in VFP 3 too.

>
>Thanks
>
>
>>Views are generally used to get a set of data, for example, all customers in New York. The SQL would include something like WHERE State = "NY". If you put this "NY" constant into the view designer, then you would always get New York customers. You'd never get California customers, so you use a view parameter and your SQL looks like WHERE State = ?vpState. The view parameter is simply a variable. When the query runs, if vpState does not exist, a window will pop up asking for a value. If vpState exists, then it will be used.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform