What database? Example of Update SQL ? Is it a stored proc? A dump of the table def?
Justin > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 2:09 PM > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] update query > > > 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] > > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
