>Hi All,
>
>I am trying to implement a feature in my app. where I provide the ability to save a cursor (workarea) as a table. If I want to go back and continue where I was working, I would use getfile() to get the file name then
>
>select * from (lcgetfile) into cursor bulkchg_rw readwrite
>
>after working on the cursor, I want to be able to save it again, using puftile() but if I select the same file, I get a "File is in use" message.
>
>I have tried an implicit "use in (lcgetfile)" as well as selecting lcgetfile, but neither resolves the issue. If I call the SET window, I can close it that way but can't seem to programatically.
>
>Any ideas.. ( I could use the getfile as alias, but because of other actions being performed, I would prefer to keep the changes as a volatile workarea and only save when done.
If you select ... into table, the table gets open, and yes, you'd have to close it to repeat the selection.
But if you use simple "copy to" command instead, the table doesn't get open and you can just copy again and again.