Re: Return Results of sp_helptext via ADO



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

.



Relevant Pages

  • Re: Case statement issue
    ... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Case statement issue
    ... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
    (microsoft.public.inetserver.asp.general)
  • Case statement issue
    ... Windows enterprise 2003 OS with IIS version 6 on the server. ... I have taken the sample of paging using a stored procedure from the website ... case statement, then the error message. ... The for loop also seems to be a problem. ...
    (microsoft.public.inetserver.asp.general)
  • Re: vbscript logon script getting return data from sql sp
    ... Loop ... > One way to retrieve values from a stored procedure is with a Recordset ...
    (microsoft.public.scripting.vbscript)
  • Re: How to consume multiple result sets?
    ... Simply call NextResultin a loop until you go through all the ... "Carl San" wrote in message ... > In a stored procedure I have multiple output parameters and multiple ... > parameters and no rows were returned from stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)