index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Using Stored Procedures with parameters ::    show all messagesPost a New Message | Post a Reply
Feb 5 2008, 2:21 PM
 Re: Using Stored Procedures with parametersPost a Reply
 ghost

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

from: Washington, DC

List your stored procedures and their parameters exclusively as shown in the sample code below:
objWiz.UseProcedures = "Procedure1,@Param1='MyValue1',@Param2='MyValue2'|Procedure2,@P1='V1'"

e.g.
bjWiz.UseProcedures = "GetStudents,@LastName='Johnson',@Age=12|GetClasses,SessionDate='" & FormatDatetime(Now,2) & "'"


Note that, if you specify the parameter value as above, the user will not be requested to enter the parameter value. On the other hand, if you wanted the user to enter a parameter value, put a question sign (?) in front of the parameter as shown below:

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




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

search this forum: