General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Michelle,
This will work just fine. We have a customer who needs to print our reports to a PDF file. Since our product is in 2.6 and you can't print to a PDF file without user intervention in 2.6 I had to find a way to save the complete environment in 2.6 and then call an exe written in VFP that restores the environment and then prints the report to a PDF file. Since most of our reports use cursors for the detail I needed a way to save them. You could check the Alias() against the DBF() but you have probably already realized that that approach is not reliable. The only way I found to be reliable is the way you described with ".TMP" $ upper(dbf()).
Mike
>The CREATE VIEW command doesn't save any open cursors. This makes sense, given their temporary nature, but I need to save them.
>
>We were thinking of scanning through all the aliases to see which had ".TMP" $ UPPER(DBF("whatever")). It seems like this would give a list of which aliases wouldn't be saved by CREATE VIEW. I could then save those to disk and recall them later.
>
>Does anyone see a reason why this wouldn't work, or know a better way? And, yes, I do need to save the cursors for this, so please don't write just to tell me that saving the cursors is a bad idea. :)
>
>Thanks,
>
>Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only