Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized View help please
Message
De
01/07/2002 19:28:56
Dennis Schuette
Customized Business Services, Llc
Yuma, Arizona, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00674130
Message ID:
00674193
Vues:
22
>>1] When the local view loads in the DE, how do
>> I prevent the prompts for the parameters from
>> popping up?
>Set NoDataOnLoad to true for the view in the DE.
>
>
>>2] Do I have the correct defaults in the
>> properties for a date and character type value?
>You probably do, but without NoDataOnLoad=true the view is trying to use those values before the exist.
>
>Setting NoDataOnLoad=true will probably fix this problem.
>
>
>>I have a grid based on a local view, lvSchedule based on BB!Schedule.dbf. It works fine, and now I am trying to make it a parameterized view.
>>
>>I setup two Form properties,
>> ScheduleDate [default value is =date()]
>> ScheduleGroup [default value is ' ']
>>
>>The filter clause of the local view:
>>Schedule.Date = ?Thisform.ScheduleDate
>>Schedule.Group = ?ThisForm.Group
>>
>>The lvSchedule view is loaded in the DataEnvironment
>>
>>When I try to run the form, I get the following error:
>> Error loading file - record number 5. SCHEDULE >> members>.Loading form or the data environment :
>> Operator/operand type mismatch
>>
>>1] When the local view loads in the DE, how do I prevent the prompts for the parameters from popping up?
>>2] Do I have the correct defaults in the properties for a date and character type value?
>>
>>Dennis Schuette, McElhaney Cattle Company

Hector,
Thanks so much for the prompt and accurate reply!
Dennis
Dennis Schuette
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform