Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized view keeps prompting for parameter - VFP 3
Message
 
 
To
14/11/1997 17:34:48
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00060373
Message ID:
00060380
Views:
45
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform