Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use more than one tables in a form
Message
De
05/07/2006 12:52:35
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
05/07/2006 09:38:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
OS:
Windows XP
Database:
Informix
Divers
Thread ID:
01133509
Message ID:
01133913
Vues:
15
>Don't forget to close any tables in the form's unload or destroy if you manually opened them...
>
>
>IF USED('mytable')
>   USE IN mytable
>ENDIF
>
Or, as an one-liner:
use in select("mytable")
The nice part here is that select("tablenotinuse") will return a zero; Use in 0 then does nothing - closes the table which is open in first free workarea, and "free workarea" is the one with no table open in it :). One nice thing with VFP is that closing a table in such a workarea does nothing, gives no error, and I think it was so ever since dBase III (or maybe IIa).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform