Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View
Message
 
To
29/06/1999 23:14:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00235627
Message ID:
00235725
Views:
19
>I need it to recognize the variable which is created and updated in prior code.
>
>Can this be done?
>
>Thanks

That's what a view parameter is made for. Suppose you have your view defined with one parameter, vp_MyParm.
When you'll load the view, make sure to set NODATAONLOAD = .T., this will load your view with no data, and above all it will not claim for a parameter.

Now, in your code
LOCAL vp_MyParm
vp_MyParm = "MyValue"
SELECT yourView
REQUERY()

That's all there is to it.

José
Previous
Reply
Map
View

Click here to load this message in the networking platform