On Tuesday 09 January 2007 07:14, Ed Leafe wrote: > On Jan 9, 2007, at 9:36 AM, johnf wrote: > > 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) > > You completely missed my point. > > That spec concerns describing the database structure. It is perfect > if you are building tools for modifying the database. > > It does *NOT* describe on-the-fly cursors, such as my example. There > is *NOTHING* in that spec that addresses this. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
I'm sorry if I did not acknowledge your point. I agree with it. But it may be possible to use the information_schema table to provide what dabo needs. My information_schema contains more that just info to modify a database. Remember information_schema data comes from the sysobjects. And the only issue with sysobjects is they change with versions of MS SQL. But the information_schema table is suppose to remain stable. BTW I'm not commenting on Carl's code. Like I said I don't know his reason for changing the code. But it did make me re-think what I was doing with sysobjects. If I understand - the information_schema table was provided by MS to comply with SQL92. BTW there are two parts of Carl's code in my mind. 1. Passing the database name. Does Carl's code hurt anything???????? At least as far as the connection is concerned. 2. Changing where we get the fields info. This I think might screws up stuff???? -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
