How to: Open Tables in Work Areas
You can open tables in work areas within data sessions. You can also reference or move to the next available work area before opening a table. For more information, see Work Areas in Data Sessions and How to: Use Data Sessions.
Note
More than one table cannot be open in the same work area. When you open another table in the same work area, the currently open table closes automatically.
To open a table in a work area
Open the tables you want to work with in the data session.
On the Window menu, choose Data Session.
The Data Session window opens.
In the Alias list, click the alias for the table you want to open, and then Open.
The table whose alias you selected is now open.
To open a table in multiple work areas
In the Alias list of the Data Session window, click the alias for the same table, and then Open.
Visual FoxPro assigns a different alias to the same table.
To open a table in a work area programmatically
Use the USE command with the table name and work area number.
Tip
To open the same table in another work area, repeat the USE command with the same table name and include the AGAIN keyword.
For more information, see USE Command.
When you open a table from the File menu, the table also opens in a work area.
To reference the next work area
- Use the SELECT command and include the work area number or table alias.
For more information, see SELECT Command.
See Also
Tasks
How to: Close Tables in Work Areas
How to: Create and Use Table Aliases
How to: Set Temporary Relationships Between Tables