integer initialization messing up params

[Dan Christie]

I am using the standard microsoft data access help class
which contains a helper function for attaching parameters
to a command object. The function contains the following:

If p.Direction = ParameterDirection.InputOutput And
p.Value Is Nothing Then
p.Value = Nothing
End If

This works well for all of my data types except for
integers which initialize at zero. I'd like to keep the
value at null in the database if I don't supply a value. I
could test for zero on an integer data type and set the
value to nothing, but I may have some cases where zero is
the value the client sets. How are people doing this? I am
setting the parameter values using properties in the same
object.

Thanks,

Dan

 

[Miha Markic]

Hi Dan,

You will have either use a flag or some struct/class instead of integer.
Check this out
http://sourceforge.net/projects/nullabletypes/

 

[Guest]

Thanks, I solved it at least for now by using a flag.