Stored Procedures

[EscapeUK]

I have a stored procedure that lets me pass in a null value.

However in my VB code the value is an integer and will not let me put a null value in it.

For example

How do I pass a null value into the stored procedure if the user does not enter a number in a text box.

Please keep answers simple as I am new to this.

 

[bobhilt]

(Your title is very generic, so you may get limited responses, but I'll give it a try.)

Pass the word NULL in your parameter string for the stored procedure, e.g., "exec MyProc 'Hello','World',27,NULL"
To find out if you need to do this, then check the value of the text box:

If len(trim$(txtFoo.text)) = 0 Then
    sFoo = "Null"
 Else
    sFoo = txtFoo.text
 End If

[alternatively:

sFoo = iif(len(trim$(txtFoo)) = 0,"Null",txtFoo.text)

]

sSQL = "Exec MyProc " & .....
sSQL = sSQL & ", " & sFoo