Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement