Can not edit bit-columns

t3rk4l's profile image t3rk4l posted 2 years ago in Running SQL scripts Permalink

After updating to version 12.2.0.6581 I can not change data in columns of type bit. In the SQL-log the following statement is added

UPDATE test_db.shoporderitem SET SubscriptionCanceled=b0 WHERE ShopOrderItemId=27532;

And I get a message box with error: "SQL Error (1054): Unknown column 'b0' in field list" When my colleague changes the field in version 11.0.0.59.19 it works and the following statement is generated:

UPDATE test_db.shoporderitem SET SubscriptionCanceled=b'0' WHERE ShopOrderItemId=27532;

As you can see the value is different. Please look into this, thanks :)

Kind regards Terkel

1 attachment(s):
  • error1054
ansgar's profile image ansgar posted 2 years ago Permalink

Next build should fix that.

See also issue #1709.

Note that the recent versions have bugs in the build updater, so you might need to manually download the new build from the download page.

jcamacho's profile image jcamacho posted 1 year ago Permalink

Hello!

I am using version 12.3.0.6654 with SQLServer and I have the same problem.

When all the BIT fields are null there is no problem, but if any of them has value the error appears.

In this case, the statement that executes is: UPDATE TOP(1) "DATABASE". "dbo". "TABLE" SET "FIELD"='1' WHERE "ID"=5608 AND "BIT_FIELD" IS NULL;

But if BIT_FIELD is 1, the statement that executes is: UPDATE TOP(1) "DATABASE". "dbo". "TABLE" SET "FIELD"='1' WHERE "ID"=5608 AND "BIT_FIELD"=b'1';

and it does not work, I have to modify it to: UPDATE TOP(1) "DATABASE". "dbo". "TABLE" SET "FIELD"='1' WHERE "ID"=5608 AND "BIT_FIELD"='1';

Changing b'1' to '1'.

Thanks! :)

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