DBNull.Value.ToString why it does not work?

that won't work indeed...

if you used a Command object with Parameters, then you can assign the DBNull.Value as such to the parameter, then it will work.

please show your code.

Dim fx as string
If x= 1 then
 fk = DBNull.Value.ToString
else
 fk = 5
end if
 
strSQL = "Insert into mytable(...,fk,...) values("... + fk + ")"

Select allOpen in new window

you "could" make your code like this:

Dim fx as string
If x= 1 then
 fk = "NULL"
else
 fk = 5
end if
 
strSQL = "Insert into mytable(...,fk,...) values("... + fk + ")"

Select allOpen in new window

however, I repeat, using the db Command + Parameter objects would be better...

Isn't it possible to do that in the way I put?