Re: Reading the definition of a view
From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 05/05/04
- Next message: Viatcheslav V. Vassiliev: "Re: SPPI Context"
- Previous message: JMSC: "SPPI Context"
- In reply to: Brian Cryer: "Reading the definition of a view"
- Next in thread: Brian Cryer: "Re: Reading the definition of a view"
- Reply: Brian Cryer: "Re: Reading the definition of a view"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 5 May 2004 15:08:51 +0400
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: Viatcheslav V. Vassiliev: "Re: SPPI Context"
- Previous message: JMSC: "SPPI Context"
- In reply to: Brian Cryer: "Reading the definition of a view"
- Next in thread: Brian Cryer: "Re: Reading the definition of a view"
- Reply: Brian Cryer: "Re: Reading the definition of a view"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
