If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
inputparameters property with complex stored proc
Hello,
I have a stored proc with several inputparameters. I created an Access project file with Access2003 I would like to use the output recordset of the stored proc in a subform. I wrote code to collect the parameter values from a form. In code I specify the recordsource property of the subform as the stored proc name and the inputparameters property to the parameters. As help describes I use the following syntax for the inputparameters property: @param1 char='aa', @param2 int=2... Help says that if I want to use DEFAULT value for a parameter (which is defined in the stored proc), I can simply ommit that parameter from the forms' inputparameters property. It is works until the stored proc is "simple", but sometimes Access passess NULL-s to SQL server for the missing parameters. (I checked this with profiler.) I realized if Access is not allow the create an "Autoform" based on a stored proc, than the inputparameters property is not working properly for that stored proc. Is it by design? ) Thank you for your help, Gábor |
Thread Tools | |
Display Modes | |
|
|