Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't close table!
Message
 
 
À
16/03/2011 09:28:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01503862
Message ID:
01503865
Vues:
44
You should use a cursor instead
SELECT * from parts WHERE ponum=mponum INTO CURSOR partstank READWRITE
...
* Close the cursor
USE IN partstank 
>I create a table with:
>SELECT * from parts WHERE ponum=mponum INTO TABLE partstank.dbf
>
>After using this table as a record source for a grid, I can't get the thing to close no matter what I do, and no matter where I do it! Is there any way apart from USE to close a table?
>
>The code I have tried is:
>SELECT partstank
>use
>
>Also tried:
>
>USE in SELECT("partstank")
>
>After trying to close the file, I try to delete the file with:
>DELETE FILE('partstank.dbf')
>and get a VFP error "File in use..."
>
>ANY ideas welcome!
>Thanks!
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform