>>>>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.

Hmmm you're right, I was just being lazy, I was trying to avoid having to do the clean up. Never mind. Thanks for the help

Mace