>I have a local view that is slow to load (because it contains some field expressions). I would like to create a SQL cursor of the whole view at the start of my app and have it available for use in several forms with data environments.
>
>Two question:
>
>--How do I scope the cursor so as to be available throughout the app?
>
>--How do I add it to the data environments of my forms?
>
>TIA
>
>Jim
What I've done with this sort of thing is to put it to a table instead.
Once the view is loaded, copy it to a app_tables folder that the application can access.
AFA adding it do the form's DE - don't worry about it. Use it (or select from it) in the Load() event of the form (or later, in the Init() ) - this can be done at the superclass level.
When the form is released, the table should be closed as well.
Insanity: Doing the same thing over and over and expecting different results.