Ed Leafe wrote: > 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.
I understand about the intermediary step needed for our tools to see what schemas are available, but assuming that was already done or that the user set up the app manually, would the following lines work?: bizobj.DataSource = "mydatabase.myschema.mytable" bizobj.DataSource = "myschema.mytable" -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
