>If I know an alias is not in use, but not sure whether the table is opened under another alias, is it alright just to "USE myTable AGAIN ALIAS myAlias IN 0". Even if table myTable may not have been used yet? I don't see any problems with it, but I don't want to run into something unexpected.
>
>TIA,
>Marcus.
You could do it. A little addition to Mike and Ed :
Keep in mind that you cannot open it exclusive if already opened shared.
use mytable shared
use mytable again in 0 alias "myAlias" exclusive
Second line doesn't error but simply open the table as shared.
Cetin