Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid display using view as recordsouce
Message
From
04/08/2003 08:50:21
 
 
To
04/08/2003 07:35:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00816350
Message ID:
00816452
Views:
24
Thanks Marcia That did it - works great. This is my first venture with views and grids and you have been a big help. From past practices, I had gotten in the habit of alway setting the record source from code as I usually had tables as the recordsource and used this to combat the blank grids that the table closing or losing focus created.

Thanks again.

Gaylen




>Hi Gaylen.
>
>It is a parameterized view. In the load event I set up some dummy variable for the view and open the view. I then reset the variables based on the parameters I send over from the calling program, so I only see the records which meet the criteria from the calling program.
>
>You can USE the view NODATA. As long as you do this in the form's load or in the form's DE, you can still specify the view as the grid's RecordSource in the property sheet of the form designer. Then, in the form's Init(), you just REQUERY() the view based on the parameters you receive from the calling form.
>
>This will not close the view, thereby resetting the grid.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform