I am passing parameters into a stored proc from a vb6 app to produce a crystal report. Two of the parameters can be null. Running the stored proc from QA runs fine. In the vb6 app the null parameter appear as empty strings and when I run the app it doesn't produce the desired output. How can I get this to work?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Passing NULL value from VB 6 to Stored procedure
- Thread starter be1s
- Start date
synapsevampire
Programmer
Check for null AND blank in the SP, this solves the problem across all tools going forward.
As for passing a null from VB to a stored procedure, you might be better served posting in a VB forum and specifically posting meaningful information, such as the database type and how you are passing the values when null.
-k
-k
As for passing a null from VB to a stored procedure, you might be better served posting in a VB forum and specifically posting meaningful information, such as the database type and how you are passing the values when null.
-k
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question