Operation with BIT

4 posts
[expired user #9574]'s profile image [expired user #9574] posted 8 years ago in General Permalink

Hi,

I have BIT type column and when I want modify/delete new row, Heidi SQL report error "Incorrect syntax near '1'". When I want delete row, SQL query is DELETE FROM ...AND "BITCOLUMN"=b'1' AND... MSSQL 12.0, Heidi SQL 9.3.0.5044

Thanks. Jan

Please login to leave a reply, or register at first.