Hi
I have an update statement and when fields in my form are left blank I want NULL inserted into the databse rather than "".
I can't find a way to do it.
If I can't find another way my plan is to set the fields in the data base to <NULL> using c# then use a second SQL query after the update to update the row and actually make these cells proper SQL null columns.
It seems a really messy way to do it.
Is there some way of setting to Null directly?
thanks
C
I have an update statement and when fields in my form are left blank I want NULL inserted into the databse rather than "".
I can't find a way to do it.
If I can't find another way my plan is to set the fields in the data base to <NULL> using c# then use a second SQL query after the update to update the row and actually make these cells proper SQL null columns.
It seems a really messy way to do it.
Is there some way of setting to Null directly?
thanks
C