What is work area in foxpro?

Answer 1

A work area is a type of slot in memory for opening tables. These slots are numbered, but once a table is opened, they can also be referred by the name of the table opened (more precisely: by its alias).

Here is an example of opening tables:

* close all tables first, just in case

close database all

* open table "client" in work area 1

select 1

use client

* open table "invoice" in work area 2

select 2

use invoice

* go back to table client, and set an index order

select client && "select 1" would also work here

set order to ClientId

Instead of "select 1" and "select 2", in the above examples, it is preferable to issue "select 0", letting FoxPro automatically select an available work area.