index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Some stored procedures are missing ::    show all messagesPost a New Message | Post a Reply
Dec 30 2006, 4:27 PM
 Re: Some stored procedures are missingPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

We use the generic “dbo” account to query SQL Server for the stored procedures as shown below:

SELECT [NAME] FROM dbo.SYSOBJECTS WHERE XTYPE='P' AND STATUS>0 ORDER BY 1

If the above statement does not return all your stored procedures, you can change it by using the DatabaseProceduresQuery property of the report wizard which will be available in the next minor release due tomorrow (Friday 3rd August 3, 2006). AS follows:

objWiz.DatabaseProceduresQuery = “SELECT NAME FROM SYSOBJECTS WHERE XTYPE='P' AND STATUS>0 ORDER BY 1”

Alternatively, you can programatically set the stored procedures you want displayed by use of the UseProcedures property. For example:

<%
objWiz.UseProcedures = "Procedure1,@Param1='Value1',@Param2='Value2'|Proc2,@P1=10,@P2='V2'"
objWiz.Init(Connection String)
%>

This property automatically sets the stored procedures to be used with their parameters and as such, users cannot edit the parameter values


-------------------------
Ghost
Pages: (1)   [1]

search this forum: