>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.
>
>Thanks in advance
>
>Al
You can fill your cursor differently, just to avoid problems:
set safety off
zap in bulkchg_rw
set safety on
insert into bulkchg_rw select * from (lcgetfile)
use in (lcgetfile)
Edward Pikman
Independent Consultant