Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized view keeps prompting for parameter - VFP 3
Message
From
17/11/1997 08:47:55
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00060373
Message ID:
00060636
Views:
32
>>>I use a parameterized view in a form and I have it in the data environment. Whenever I start the form the view prompts me for the parameter even though I set the value of the parameter.
>>>
>>>In the Init of the form I have:
>>>
>>>ld_sched = date()
>>>=requery("schedname")
>>>
>>>ld_sched is the parameter of the view.
>>>
>>>Below is the view definition. Ignore everything except the where clause with the parameter.
>>>
>>>SELECT Schedule.dialtime, Demogrph.name, Schedule.rfid, Schedule.rundate,;
>>> Schedule.nurse_clas, Schedule.pat_loc, Schedule.dial_loc, Schedule.hrs,;
>>> Schedule.dial_type, Schedule.pat_type, Schedule.sched_type,;
>>> Schedule.modality;
>>> FROM patdb!demogrph, patdb!schedule;
>>> WHERE Schedule.rfid = Demogrph.rfid;
>>> AND Schedule.rundate = ?ld_sched;
>>> ORDER BY Schedule.dialtime, Demogrph.name
>>>
>>>Why do I get prompted for the parameter?
>>
>>IN the DE, set the view's nodataonload Property to .T.
>
>Won't this simply delay the inevitable? I want to programatically set the parameter and not have the user input the value.

No, this means that that the view won't be queried until you issue a REQUERY(). This gives you time to programmatically set the variable, and then requery.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform