Daniel,

This one is interesting - a real example of when it starts to happen...

If the cursor wasn't readonly I could consider appending a load of records to it then deleting them

Thanks

Will

>Will,
>The NOFILTER clause prevents VFP from filtering the original table in case of a simple SELECT and creates a real cursor. However, it doesn't necessarily create a file on disk. If VFP has enough memory to handle the cursor in RAM, there won't be a physical file. This is the same behaviour as with cursors created with the CREATE CURSOR command.
>Try running the following code:
>

>CREATE CURSOR test (mTest M)
>
>DO WHILE .t.
>	INSERT INTO test VALUE(REPL("X", 65000))
>	IF FILE(DBF())
>		MESSAGEBOX("Now we've got a file on disk: " + DBF())
>		EXIT
>	ENDIF
>ENDDO
>

>On my system with 128MB, VFP creates a file on disk after approx. 1400 records which corresponds to 85MB.
>HTH