Virusim,

If you actually use single-letter alias names, that's your problem. Originally, work areas could be referred to by single letters the way we can refer to them now like SELECT 1.

Be sure to run through your routine with the debugging tools and data session window open. Look to see that they are all actually open when you get to the SELECT line. Make sure that no tables are opened on top of each other (like USE Table1; USE Table2 SELECT Table1 won't work.)




>Hi,
>
>Thank a lot for your help and advise. It really help me to understand
>it more in details.
>
>However, how come my application when I open a bundles of dbf files in the
>begining like
>
>* open of dbf files first
>USE tbla IN 0 ALIAS A
>USE tblb IN 0 ALIAS B
>USE tblc IN 0 ALIAS C
>
>* Next, do other command
>SELECT A <=========== Error, alias not found
>* do other command too
>
>* Finally, close the dbf file
>USE IN A
>USE IN B
>USE IN C
>
>Why do the above happen, please advise. It really confused me.
>Thank a lot