Arnon,

>SET DATABASE TO dbcname
>you can also
>USE dbcName!tableName directly

What I'm doing is opening all DATABASEs with their respected tables when my application starts. I've tried the SET DATABASE TO dbcname command and then attempted to SELECT tablename but it doesn't work. I have two DATABASES that have tables with the same name, it when I issue the SELECT tablename, it SELECTS the other table.

Maybe I need to open each table in the database like this: USE dbcName!tablename ALIAS dbcName + '_' + tablename

Anyway, thanks for the help.