Re: Enforcing NOT NULL restriction on UPDATE

At 9:30 AM -0400 9/20/03, Steven Hilton wrote: I am experiencing odd behavior, and I'm hoping someone can tell me if I'm doing something wrong or explain why it is behaving this way, and how to get around it... When I update a row in a table with a field's data set to NULL, but the table has a NOT

Enforcing NOT NULL restriction on UPDATE

I am experiencing odd behavior, and I'm hoping someone can tell me if I'm doing something wrong or explain why it is behaving this way, and how to get around it... When I update a row in a table with a field's data set to NULL, but the table has a NOT NULL restriction on the field, the update stil