Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with writeable cursors
Message
From
17/01/2000 14:39:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with writeable cursors
Miscellaneous
Thread ID:
00319138
Message ID:
00319138
Views:
41
Dear All,

I found the following syntax to make a cursor writeable:

USE DBF("cMyCursor") IN 0 AGAIN ALIAS cAnotherCursor

But if I use the following :

select anyfield from MyTable into cursor cMyCursor

then DBF() gives back the path of the original table, but I don't want to write into the original table.
After some reasonong, I have tried using the following:

select anyfield from MyTable into cursor cMyCursor nofilter

then DBF() gives a really temporary filepath.

According to the VFP documentation, neither of the previous syntax creates phisical files. But practically, the second syntax still produces one.

Is it sure, that the second syntax always produces a temporary file, and thus, is safe to write into the cursor after making it writeable?

P.S.: I know, that

select anyfield, .t. from MyTable into cursor cMyCursor

does the job, but I would like to understand the theoretical background.

TIA

bb
Next
Reply
Map
View

Click here to load this message in the networking platform