Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View help please
Message
From
01/07/2002 19:28:56
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:
00674193
Views:
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,
Thanks so much for the prompt and accurate reply!
Dennis
Dennis Schuette
Previous
Reply
Map
View

Click here to load this message in the networking platform