SQL Query for update a bool field

Business Central/NAV User Forum
1

Hi i’m trying to update a field in navision 2.60 i need update a field i got next error, my field is boolean what is reason i’m trying that this ways but i can’t any idea ?

//string query = “UPDATE mytable SET MYBOOLFIELD = ‘0’ WHERE h =‘101’ and hh =‘H10HRA’”; //error: Navision Financials ODBC Driver]Invalid operand for operator: en System.Data.Odbc.

//string query = “UPDATE mytable SET MYBOOLFIELD = 0 WHERE h =‘101’ and hh =‘H10HRA’”; //error: Administrador de controladores ODBC] El controlador no admite esta función

//string query = “UPDATE mytable SET MYBOOLFIELD = FALSE WHERE h =‘101’ and hh =‘H10HRA’”;
//error: [Navision Software a/s][Navision Financials ODBC Driver]Column not found: FALSE

//string query = “UPDATE mytable SET MYBOOLFIELD = ‘FALSE’ WHERE H =‘101’ and Hhl =‘H10HRA’”;
//error:ERROR [42S00] [Navision Software a/s][Navision Financials ODBC Driver]Invalid operand for operator:

2

Make sure that you have selected correct database in query

I tried with first 2 queries and it is working fine

UPDATE

[CRONUS EXT India Ltd_$Payment Terms]

SET

[Calc_ Pmt_ Disc_ on Cr_ Memos] =

1

WHERE

[Code] =

‘7 DAYS’