Database 'Bit' field type problem !!
-
Hi.. All I've a database table's 'bit' field type problem. The problem is : When I fire any update query to the table, my 'Active' (bit type) field automatically updated to value 1. But I have not taken this field in my update query. But this update query update the value of 'bit' field with 1. Please, Give me any solution as soon as possible. Thanks in Advance..
Regards, Abhi
-
Hi.. All I've a database table's 'bit' field type problem. The problem is : When I fire any update query to the table, my 'Active' (bit type) field automatically updated to value 1. But I have not taken this field in my update query. But this update query update the value of 'bit' field with 1. Please, Give me any solution as soon as possible. Thanks in Advance..
Regards, Abhi
Hi, Please tell me what is the purpose of using that field and whats initial value of that field. Nagendra
-
Hi, Please tell me what is the purpose of using that field and whats initial value of that field. Nagendra
I haven't given any initial value of that field in design type. Foe Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks.
Regards, Abhi