On Tuesday 09 January 2007 06:36, johnf wrote: > On Tuesday 09 January 2007 06:26, Ed Leafe wrote: > > On Jan 9, 2007, at 9:19 AM, johnf wrote: > > > Also I'm not to sure normal users have access to the > > > "information_schema". I > > > only know that access is assumed OK on public "sysobjects tables". > > > > Even if they have complete unfettered access to information_schema, > > what good would it do for this query? > > > > select sum(orderitems.amount) as totalsales, ... > > > > Where will information_schema have anything about the 'totalsales' > > column in your cursor? > > > > Use the dbapi, Luke! > > > > -- Ed Leafe > > -- http://leafe.com > > -- http://dabodev.com > > > > > > > > _______________________________________________ > > Post Messages to: [email protected] > > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev > > Did a little research on the web. I'm GUESSSSSSING. Carl are you using > information_schema table to comply with SQL 92???? There is a good article > at http://www.dbazine.com/db2/db2-disarticles/pelzer4. So Carl may be > doing the right thing. I'm using sysobjects tables and not the > information_schema table. However, many of the database engine do NOT > provide a " > information_schema table" (Oracle is one) > > As far as the code - I'll have to see what he is doing and why. But if the > " information_schema table" provides what we need then I think it make > sense to use it. Of course I'm not to sure I would have committed without > discussion.
Damm, I spoke to soon. "information_schema table" is only available on V7 and above. We had a similar problem with Postgres where I provided code for both an old version and the new versions. My "sysobjects tables" code works with all the versions. What do you guys want to do????? -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
