Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use more than one tables in a form
Message
From
05/07/2006 12:52:35
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
05/07/2006 09:38:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
OS:
Windows XP
Database:
Informix
Miscellaneous
Thread ID:
01133509
Message ID:
01133913
Views:
14
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform