I am experimenting using xml to insert and update a table via ASP. I have a table with four fields; an identity field, two integer fields, and a bit field with a default value of 0. The xml code has values for the two integer fields. After insert the new integer values are there, the identity field has been set but the bit field has been left at 'null', that is the default value has not been set.

Does anybody know why?