ok check this out. I have a field in the table
Admin bit default(0) The value of this field is currently set to 1 I have just changed it to a NOT NULL value with a default, previous is a NULL, still did the same thing. I run an update query, this query DOES NOT update this column. There are no other update queries. Nothing touches this column at all. Yet every time I run an update query, this field gets set to 0 all by itself. there are no triggers or anything of this sort to cause it, it is just a plain old table. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
