Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bizarre temp file problem
Message
From
21/12/1999 18:44:13
 
 
To
21/12/1999 17:28:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00306991
Message ID:
00307014
Views:
25
Mike, the parentheses are not necessary. What was wrong was the missing "IN 0". Attempting to open the DBF() of the cursor in the same work area in which the cursor itself was open caused the cursor to be closed, which deletes the temporary file, which results in the "file not found" error.

The following works fine:
   SELECT * FROM myTable into cursor myCursor
   SELECT myCursor  && this is redundant, but OK
   USE DBF() AGAIN IN 0 ALIAS myTable
If the cursor is not the selected work area, then you can write
USE DBF("myCursor") AGAIN IN 0 ALIAS myTable
>Hi Michelle,
>
>>USE DBF() ALIAS testcur AGAIN
>
>This needs to be
>
>USE (DBF()) ALIAS testcur AGAIN IN 0
>
>Without the () you are looking for a file called dbf().dbf, and without the IN 0 you actually are closing the cursor. USE will close whatever is in the current wa and then open the new file, thats why you can do:
>
>USE Table SHARED
>USE Table EXCL
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform