Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bizarre temp file problem
Message
 
 
À
21/12/1999 17:28:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00306991
Message ID:
00307014
Vues:
24
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform