Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized view keeps prompting for parameter - VFP 3
Message
 
À
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:
00060380
Vues:
47
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform