Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Views based on Views
Message
From
06/10/2001 23:35:21
Gil Munk
The Scarborough Group, Inc.
Baltimore, Maryland, United States
 
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00565188
Message ID:
00565240
Views:
19
>>Here's the deal:
>>
>>(view1 is a view used in view2)
>>
>>If I open/requery view2 which based, in part, on view1 everything is fine IF view1 was populated directly from it's underlying data (either used without the NODATA clause or requeried.
>>
>>If I have populated view1 programatically from, let's say, a multi-select list on a form (this view1 is still a view based on a real table but was opened with the NODATA clause) then attempted to use or requery view2, view2 will not get popultated with any data.
>>
>>So it appears to me that view2 will not work unless view1 has data in it directly pulled from it's underlying table.
>>
>>This has been forcing me to use standard SQL Cursors for my reporting, which I don't mind, but I'd like to keep to the framework ideals. Does anyone have a suggestion? The data in view1 is usually the Id of it's underlying table.
>>
>>Thanks in advance,
>
>Have you tried coding this logic in the init event of your report dataenvironment? You can do alot with the methods that are available to you.

James,
I am using the init method to set up the cursors after coming back from the modal form with the choices made by my users. Those choices would be inserted into a view (view1) but as I stated, I can't get view2 to work if view1 is populated this way.
I was hoping that I was overlooking something in the view based on a view...
Gil Munk


"If a nation expects to be ignorant and free, it expects what never was and never will be." - Thomas Jefferson
Previous
Reply
Map
View

Click here to load this message in the networking platform