Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized View help please
Message
De
01/07/2002 16:28:20
Dennis Schuette
Customized Business Services, Llc
Yuma, Arizona, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Parameterized View help please
Divers
Thread ID:
00674130
Message ID:
00674130
Vues:
65
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
Dennis Schuette
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform