>My problem is new tables getting created in the wrong dbc.
So, as you've found, you
can have two dbcs open at the same time! :)
To set the 'current' dbc, use SET DATABASE TO command.
WishList item: shouldn't CREATE TABLE have an IN or OF < database > clause?! :)
HTH,
Rich.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing