On Friday 19 January 2007 11:07, 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. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com
Right. So if I can filter the schema to return only the tables along with the schemas based on the user - this will work right? -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
