>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

Can you create the cursors as tables instead right from the beginning?
If not, sounds like you're on the right track.