Re: Return Results of sp_helptext via ADO
- From: "james.igoe@xxxxxxxxx" <james.igoe@xxxxxxxxx>
- Date: 10 Jan 2006 08:10:11 -0800
Solved:
needed to execute fllowing against server, as opposed to sp_helptext
directly:
'basic sql for getting stored procedure text
strSQLStoredProcBase = "select syscomments.text From sysobjects,
syscomments " & _
"where sysobjects.id = syscomments.id and sysobjects.type =
'P' " & _
"and sysobjects.name = '"
then loop through recordset, appending row to prvious:
'evaluates error, if no recordset, writes error message
'else, write stored proc
If adorsStoredProcText.EOF Or adorsStoredProcText.EOF Then
daorsStoredProcs(1) = "Stored procedure not found or
resulted in error"
Else
'sets stored proc text to string
'loops to concatenate stored proc text as string
While Not adorsStoredProcText.EOF
strStoredProcText = strStoredProcText &
adorsStoredProcText(0)
adorsStoredProcText.MoveNext
Wend
.
- References:
- Return Results of sp_helptext via ADO
- From: james . igoe
- Return Results of sp_helptext via ADO
- Prev by Date: Re: Only want to insert a record
- Next by Date: Re: Only want to insert a record
- Previous by thread: Return Results of sp_helptext via ADO
- Next by thread: Re: metadata in dataset
- Index(es):
Relevant Pages
|
