Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View help please
Message
 
To
01/07/2002 16:28:20
Dennis Schuette
Customized Business Services, Llc
Yuma, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00674130
Message ID:
00674157
Views:
24
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform