Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another wierd one
Message
From
08/03/2001 03:39:38
 
 
To
08/03/2001 03:22:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00482754
Message ID:
00483050
Views:
13
Will,
Stupid question, but why do you need a file presence? As mentioned by someone else, you can always make the cursor Read/Write if you need to modify it after the SQL SELECT. If you really need a file, then use INTO TABLE. Of course this has the disadvantage that you need to do the house keeping yourself.
HTH

>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
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform