Prev: Special TIMESTAMP - 0912291327
Next: Acc2000.mdb new objects by Acc2007 -> not shown back in Acc2000
From: Roman Trojan on 7 Jan 2010 11:32

I have connection to Access database and a name of a view
Dim Conn As New System.Data.OleDb.OleDbConnection
Conn.ConnectionString = "..."
Dim ViewName As String = "..."

I would like to programmatically find out the inner content of
the SQL query (Access)
Dim SqlContent As String = ?

The purpose is not to read data from this view, but to analyze
the SQL only!

Hope to get help
Roman

*** Sent via Developersdex http://www.developersdex.com ***
From: Tom van Stiphout on 7 Jan 2010 21:35
On 07 Jan 2010 16:32:04 GMT, Roman Trojan <roman.trojan(a)msgis.com>
wrote:

System.Data.OleDb.OLEDBConnection?
Are you in VBA or in VB.NET?

Would sp_helptext help?

-Tom.
Microsoft Access MVP




>
>I have connection to Access database and a name of a view
>Dim Conn As New System.Data.OleDb.OleDbConnection
>Conn.ConnectionString = "..."
>Dim ViewName As String = "..."
>
>I would like to programmatically find out the inner content of
>the SQL query (Access)
>Dim SqlContent As String = ?
>
>The purpose is not to read data from this view, but to analyze
>the SQL only!
>
>Hope to get help
>Roman
>
>*** Sent via Developersdex http://www.developersdex.com ***
From: Roman Trojan on 8 Jan 2010 04:20
Thank you Tom for this clue!
I try to get information about SQL directive adequate to
sp_helptext (Transact-SQL) on SQL Server but exterior to
database (SQL Server, Access, Oracle, ...) in an application
(e.g. VB.NET).
System.Data.OleDb.OleDbConnection gives me accessibility to
database; I know the name of a view and do not know how to get
the SQL string which the view uses for receiving data.
What for? --> a little complicated issue
Roman

*** Sent via Developersdex http://www.developersdex.com ***
From: Roman Trojan on 8 Jan 2010 04:24
Thank you Tom for this clue!
I try to get information about SQL directive adequate to
sp_helptext (Transact-SQL) on SQL Server but exterior to
database (SQL Server, Access, Oracle, ...) in an application
(e.g. VB.NET).
System.Data.OleDb.OleDbConnection gives me accessibility to
database; I know the name of a view and do not know how to get
the SQL string which the view uses for receiving data.
What for? --> a little complicated issue
Roman

*** Sent via Developersdex http://www.developersdex.com ***
 | 
Pages: 1
Prev: Special TIMESTAMP - 0912291327
Next: Acc2000.mdb new objects by Acc2007 -> not shown back in Acc2000