Yeah the fields allows nulls but Im using a stored procedure that updates the table
the line is
devX.cmdUpdateTable ...,..,..,cdate(txtdate.text),..,.., (42 fields in total)
Im checking txtDate to see if its got nothing in it.
I wanna say if its not then give it a null value. The paramter is of type datetime. Doing a manual UPDATE..SET..= null works fine so I know there a way of somehow gettng a NULL into this bloody prameter
Can you help
Thanks
Nev G