Use agin trouble

[phabio]

Hi all,
I'm tryng to use the "AGAIN" clause inside USE.

open database southwind
use suppliers in 0
select suppliers
brow

Ok..

use suppliers again alias suppliers_2
select suppliers

mar 2. dic 20:03:36 2014
**** Lianja error ****
select suppliers
^
Variable/field 'SUPPLIERS' not found

Is a bug or my mistakes?
I want to use this to "preserve" the original table as I read in another way the main table.

thanks
Fabio

[davefoss]

Hi Fabio,

Did you SELECT a new workspace before issuing the USE ... AGAIN?

[phabio]

Hi Dave,
yes, I've try with
select 0 before the "Use again"
and with use suppliers again alias suppliers_2 in 0

thanks

[phabio]

Hi all,
I've found the solution...
The problem is the table-lock of the table.

When I open the table:
use suppliers in 0

the table are opened exclusively...

If I write:
use suppliers in 0 shared, all work correctly.