>Can I take out the SELECT lookupbc command in the following block of commands? I think so.
>And there is no way to get rid of the USE command in the first line and have the SELECT-SQL command work, is there?
>
>

>USE \data\reference\lookupbc IN 0 SHARED
>PUBLIC ARRAY acareloc(1,2)
>SELECT alltrim(desc), id FROM lookupbc WHERE code = 4 INTO ARRAY acareloc
>SELECT lookupbc
>USE
>

If you are pathed through \data\reference then i believe you don't have to pre open the table (though I suspect that its faster if you do).

The last 2 lines can be combined to become

use in lookupbc

HTH