Hi,
The question is - 0,1, or 2 issues here?
The situation.
Create two schema in a MySQL database:
Alpha
Beta
With at least 1 table in each schema.
Create a user account in the database with full access rights to both
schema.
Create a Base file with the MySQL native connector.
Use the Table Filter dialog to select the Beta schema and the table(s)
therein ONLY.
Close and reopen the Base file.
In the tables section now there is still an entry for both schema, Alpha
with zero tables listed and Beta with all the tables listed.
When multiple schema are displayed they are displayed in alphabetical order.
(Issue 1?)
Use the table editor or table wizard to create a new table.
When you go to save the table design there is a drop down to select the
schema to save it to.
This drop down defaults to the first schema listed - in this case Alpha.
(Issue 2? of course if Issue 1 is an issue and it where fixed I suppose
this one goes away)
Well - there you go,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
