General information
Category:
Forms & Form designer
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only