Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00141953
Message ID:
00142025
Views:
34
Thanx... Will try that out...

Bob

>>Pulling my Hair out...
>>
>>I have a Parameterized View that calls for Variable
>>iCustomer... In the View I have a ?iCustomer in the
>>Filter Expression section. Where on the FORM do
>>I place the code that says iCustomer=0 (For the
>>first run through) so it doesnt prompt me for the
>>Customer # everytime I run the form?
>>
>>Thanx for any advice (On the Code, Not the Hair :-))
>>Bob
>
>This takes two steps.
>First set the cursors NodataOnLoad property to .T.. This causes the view to be used with the NODATA clause, which basically opens it up empty.
>Then, wherever you REQUERY() the view, set your parameter before hand. IF you want data to be in there when the form loads, best to do this in the init or from some method called by init.
Previous
Reply
Map
View

Click here to load this message in the networking platform