In VFP an open table is referenced by an alias of the workarea where it's open. An alias can only start with a letter or underscore and can include Letters, digits and underscores. In case when table name follow that requirement, VFP uses it as an alias. Otherwise it generates its own alias. You can see it by running following code

CREATE TABLE abc (sno n(3))
? ALIAS()
CREATE TABLE 123 (sno n(3))
? ALIAS()

I would recomend that you use table names that follow VFP names requirements.


>
>When I run following line of codes, then it works fine
>

>CLOSE ALL
>CREATE TABLE abc (sno n(3))
>insert into abc values(10)
>
>select abc
>brow
>

>But When I run following codes, then it generates this error message
>No tables is open in the current work area
>

>CLOSE ALL
>CREATE TABLE 123 (sno n(3))
>insert into 123 values(10)
>
>select 123
>brow
>

>What done when I replace table name 123 instead of abc?
>Please help