Re: Reading the definition of a view
From: Brian Cryer (brianc_at_127.0.0.1.activesol.co.uk)
Date: 05/05/04
- Next message: Oliver Giesen: "Re: OLE error 80040200 when assigning events of a TCustomADODataset pointingto a multi-select stored proc"
- Previous message: Viatcheslav V. Vassiliev: "Re: SPPI Context"
- In reply to: Viatcheslav V. Vassiliev: "Re: Reading the definition of a view"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 5 May 2004 12:59:28 +0100
Excellent. Thanks. (Now why didn't I spot that before!)
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:4098cb42$1@newsgroups.borland.com...
> OpenSchema with siViews, field is VIEW_DEFINITION + siProcedures, field is
> PROCEDURE_DEFINITION.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Brian Cryer" <brianc@127.0.0.1.activesol.co.uk> сообщил/сообщила в
новостях
> следующее: news:4098c8b0$1@newsgroups.borland.com...
> > I'm working on a project to help document our Access databases, front
end
> is
> > Delphi. I haven't been able to find a way of extracting the definition
of
> > views (or queries as Access prefers to call them) other than by
> > interrogating the MSysQueries table directly. The disadvantage of this
is
> > that I need to grant read permissions on this system table manually
> first -
> > which isn't really viable as a general purpose tool.
> >
> > I'm using TADOConnection.OpenSchema to get a list of tables and views,
and
> > also the fields that a view exposes, but I don't think this gives an
> option
> > to return how the view is constructed.
> >
> > Does anyone know of an alternative approach to obtaining how a view is
> > constructed other than going to MSysQueries directly?
> >
> > Thanks,
> >
> > Brian.
> >
> >
>
>
- Next message: Oliver Giesen: "Re: OLE error 80040200 when assigning events of a TCustomADODataset pointingto a multi-select stored proc"
- Previous message: Viatcheslav V. Vassiliev: "Re: SPPI Context"
- In reply to: Viatcheslav V. Vassiliev: "Re: Reading the definition of a view"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
