Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use more than one tables in a form
Message
From
04/07/2006 09:16:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
04/07/2006 09:11:08
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:
01133571
Views:
12
>Hi,
>Thank you for your reply but how to put new tables at runtime as a data environment in a form?Thank you.
>
>Regards
>
>Syah N

You can open tables at runtime with the USE command. If you need to open more than one table, you need the SELECT command to select a free work area (otherwise, opening one table will close another table). If you have controls that refer to the tables (through their ControlSource property), you should do all this in the Form.Load() event.

Example:
* Form.Load()
use Table1
select 0
use Table2
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform