assign null values to a variable 1

[logi2000]

is it possible to assign a null value to a integer, string or datetime variable ?

so when i send the data to the database it stores a null, and not any default number assign to the variable when it is declared.

 

[Custom24]

The way I would do this is to use the parameters collection of the command object.

cmd.parameters(0).value = dbnull.value

if you can't/don't use parameters (eg dynamically generated SQL), then you'll have to figure out some way of using the SQL keyword NULL instead of the value of the variable

eg

strNumber = iif(txtBox1.text = "", "null", txtBox1.text)

strSQL = "update MyTable set MyField = " & strNumber & " where ID = " & intID.tostring

Hope this helps

Mark