pulling SQL sentence from a query to a string value

T

thread

Hi all,

i need to pull by coding the SQL sentences of the queries in order to
make decision or to make changes
is it posible by coding to extract this data?
 
J

John W. Vinson

Hi all,

i need to pull by coding the SQL sentences of the queries in order to
make decision or to make changes
is it posible by coding to extract this data?
Click to expand...

Dim strSQL As String
strSQL = CurrentDb.Querydefs("Queryname").SQL


John W. Vinson [MVP]
 
T

Tom Wickerath MDB

sp_helptext 'sprocname' will give you the DDL for a stored procedure or view
 
Top