How to: Open Tables in Work Areas

JavaScript Editor js editor     Web development 



Main Page

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

  1. Open the tables you want to work with in the data session.

  2. On the Window menu, choose Data Session.

    The Data Session window opens.

  3. 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



JavaScript Editor js editor     Web development