>Hello,
>I created a form in which a cursor is made. I want to print the information from this cursor into a report, but I want to open this report from another form (where some printoptions can be set.) But when I open the second form (from a button on the first form), the cursor is not 'visible' for this (second) form.
>How can I make a Cursor 'public?'
>Thank you for your time.
This only works for SQL views, but is something you may consider in the future. If you know the DataSessionID where the view is currently open, you can issue a
USE MyView NoRequery DSID> where DSID is the DataSessionID where the view is currently open. I use this on 1 of my LOCAL views, and it works fast. The VFP Help says this if for remote views, but it worked on one of my local views. This lets me maintain private data sessions.
Mark McCasland
Midlothian, TX USA