Re: How to get info on view columns' source (field) ?

Not quite sure what you meant by that, but I disagree ( :) ).

In Delphi, if you set the query active, then open the field editor and populate it with all the fields and click on a field the object inspector will show all sorts of field information. Or, if your query will be used for many different queries you can get the same type of information after the query is opened.

As of at least Delphi 4 the property that should tell you the table name of the field was broken (it could only tell you the table name of the fields for the first table listed in the 'from' part of the statement is what I recall), and I haven't been on a Delphi project since that release, so I don't have access to the Pro version to check if it has been fixed.

"Bjørge Sæther" <bjorge_at_hahaha_itte.no> wrote in message news:A4Ep9.2813$jS5.62616_at_news2.ulv.nextra.no...
> "Scott Mattes" <Scott_at_TheMattesFamily.ws> skrev i melding
> news:0_zp9.22047$m92.4975974_at_news1.news.adelphia.net...
> > Delphi, now there is a RAD!
>
> No RAD at all...dealing with it programmatically wasn't excactly what
Delphi
> was built for...;-)
>
> > The view ALL_VIEWS contains the source used to create the view (its the
> only
> > place that I know of for the information). 'Just' parse it out to find
the
> > table/s and field/s of the view, then look in ALL_TAB_COLUMNS for the
> > information you want.
>
> Yes, I know that I can get the source.....just didn't want to actually
> *write* an SQL parser...expecially when dealing with a variety of Oracle
SQL
> statements...
>
> I was afraid of that answer...but thank you !
>
> >
> > "Bjørge Sæther" <bjorge_at_itte.no> wrote in message
> > news:1ccf751c.0210110404.4995841a_at_posting.google.com...
> > > Hi !
> > >
> > > (Ora 8.1.6)
> > >
> > > Given this table:
> > >
> > > CREATE TABLE PERSON (
> > > ID NUMBER(38) NOT NULL PRIMARY KEY,
> > > FIRST_NAME VARCHAR2(50),
> > > LAST_NAME VARCHAR2(50)
> > > )
> > >
> > > ...and this view:
> > >
> > > CREATE VIEW PERSON_LIST AS
> > > SELECT
> > > ID,
> > > FIRST_NAME||' '||LAST_NAME NAME
> > > FROM
> > > PERSON
> > >
> > > ...I want to get this information from Oracle about the view (format
> > > is not important, it is for internal use in a Delphi application):
> > >
> > > FIELD SOURCE
> > > -------------
> > > ID PERSON.ID
> > > NAME (CALCULATED)
> > >
> > > ...??
> > >
> > > Thanks in advance !
> > >
> > > Bjørge
> >
> >
>
> --
> Bjørge Sæther
> bjorge_at_hahaha_itte.no
>
>
Received on Fri Oct 11 2002 - 14:30:18 CDT