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:
00138899
Views:
11
yep. Heck, it even works in Access :)

>Does the question mark only work on 5 and above?
>
>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.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform