Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized view keeps prompting for parameter - VFP 3
Message
De
14/11/1997 17:34:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00060373
Message ID:
00060375
Vues:
33
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform