>>>I'm creating a temporary cursor which is based on a .frx and would like to use the temporary cursor to run the report. 80% of the time this is ok as I can obtain the filename using dbf() and run the report from here, but sometimes the cursor seems to exist only in memory and not as a file. Is there anyway to make sure that the temp cursor exists as a file as well as a cursor?
>>>
>>>Thanks,
>>>
>>Hi Mace,
>>
>>Try using NOFILTER in the SQL statement.
>
>Yeah, I was doing this, but it still isn't working. In fact there was a bit of a discussion about it yesterday - dbf() not working, where it was said that a minor change in the file would result in the file appearing with dbf or in explorer, but that doesn't seem to be the case.
As a last resort you could do a COPY TO < filename > from the cursor or select into table. Of course, you'll have to take care of the cleanup chores yourself.
BTW, you mentioned that you were doing this from a report file. If you add the FRX extension when you copy, VFP will properly give the memo file the FRT extension.
George
Ubi caritas et amor, deus ibi est