AspWebSolution Forums » Products » ASP Report Wizard v2 » Not all SQL Server Stored Procedures display

index | search | no replies | posting guidelines | help

» »

:: Not all SQL Server Stored Procedures display :: (3)

May 10 2006, 11:31 AM

Not all SQL Server Stored Procedures display

jcravens

since: May 10, 2006
from: Houston, TX I am a newbie testing the free version first and have come across this. Not sure what is up but I am connecting to a sql server backend and when I display all the stored procedures, only 2/3 of them seem to display for me to chose. New ones added do not show up. When I hide them all and then useprocedure with the name it shows up alone (which is correct) but does not display any data. This query does have parameters but I am wanting the user to be able to enter in the parameters and not hardcoding it. Make sense?

Thanks

May 10 2006, 4:25 PM

Re: Not all SQL Server Stored Procedures display

Post a Reply

ghost

from: Washington, DC try this and let me know if it helps:

objWiz.UseProcedures = "Procedure1,@Param1='?ParameterName1',@Param2='?ParameterName2'|Proc2,@P1=?MyOtherParamerterName'"

-------------------------
Ghost

May 11 2006, 6:16 AM

Re: Not all SQL Server Stored Procedures display

Post a Reply

jcravens

since: May 10, 2006
from: Houston, TX This does not explain the missing stored procedures in the list. I am not filtering any sp's out at all. They just don't show up.

Also kind of taking you literal but if I copy the code in, would I not have to put the specific sp name in the string and if so then would the parameters have to be entered and the values. This sounds like a 'duh' to me. I just want specific sp's to be listed that will have the user clicks on the sp, they have to enter in the parameters (in the pop up) and then run the sp's Can the module do that?

Pages: (1) [1]