RoadrunnerII
Registered User.
- Local time
- Today, 13:36
- Joined
- Jun 24, 2008
- Messages
- 49
If I just execute the SP it will not give a result because it needs the parameter
Here is the error
Msg 201, Level 16, State 4, Procedure Find_Product, Line 0
Procedure or function 'Find_Product' expects parameter '@searchstring', which was not supplied.
If I plug in a value like 11 it returns plenty of records
So I believe it is working as designed
So I need to do something different on the Access Form side right?
RRII
Here is the error
Msg 201, Level 16, State 4, Procedure Find_Product, Line 0
Procedure or function 'Find_Product' expects parameter '@searchstring', which was not supplied.
If I plug in a value like 11 it returns plenty of records
So I believe it is working as designed
So I need to do something different on the Access Form side right?
RRII
Ok well that stored proc should work fine so no problems there, I would have done the stored proc in a different way but the end result would be the same.
does it still only return 1 row in SSMS?