Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized View help please
Message
 
À
01/07/2002 16:28:20
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:
00674157
Vues:
23
>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 Correa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform