distal-attribute
distal-attribute
distal-attribute
distal-attribute

Incorrect syntax with bit

jan.zahora posted 9 months ago in General

Hi,

I use MSSQL 10 (or MSSQL 12). Error occurred with Incorrect syntax near '0'. when I try update BIT type cell from database grid.

Log StringList: UPDATE TOP(1) "DatabaseName"."dbo"."TableName" SET " BitColumn"='1' WHERE "BitColumn"=b'0';

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