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.