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

Click here to load this message in the networking platform