On Jan 19, 2007, at 2:03 PM, Paul McNett wrote:
> Are we saying that no code changes are necessary to support schemas,
> that user-level code merely needs to say:
>
> bizobj.DataSource = "mydatabase.myschema.mytable"
>
> or even:
> bizobj.DataSource = "myschema.mytable"
>
> since the database is already set in the connection?
Nope. Take AppWiz as an example. When we query database for the
available tables, we only see those in the 'public' schema. We don't
have any way of seeing tables in any non-public schema. What we need
is a way to ask either the user to specify the schema name, as they
do with the database name, or add an intermediate step where, once
they connect to the database, we query for all available schemas, and
then present them with a list of all schema.table names for them to
choose from.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
