>I'm updating ExcelListener.vcx to take advantage of Greg Green's excellent class vfpxWorkbookXlsx.vcx, which creates Excel files with xlsx format.
>
>To optimize speed I want to make sure cursors remain in memory only. I believe this is the default VFP behavior, but am confused by the fact that you can append from a cursor by referring to it as DBF('CursorName') and the fact that that that file actually exists on disk.
>
>I'd appreciate any clarifications. No need for ram disks, right?
>
>TIA,
>
>Alex
Hi.

By default cursors are dbf's with a sys(2015) name and .tmp extension they are adressed with an alias.
So cursor temp will be in reality a file like 4ZM101K36.TMP and stored in your sys(2023) directory. On normal closing down they are distroyed. Sure you can abnormal terminate a VFP session in which case your cursors will not be destroyed. Use a HD scanning utiliy like e.g. Everything and you will be amazed of the number of .TMP files with a filename like sys(2015) you can even open that file with VFP and you are able to browse. So if you are concerned about the existance of confidential data in one of your cursors on your HD be sure to get dsiposed of your cursor when not in need anymore ( use in ) However since the use in does nothing more than set a bit to delete and if you want to be 100% sure the .tmp file is realy gone a good thing is to make use of the VFP ability to overwrite an exisiting cursor with new data, same .tmp file. Make a non-sense select into your cursor with the NOFILTER parameter. After that a 'use in' and data is gone for peering eyes.
Regards,
Koen