Update fields in sap b1 query generator (update command)

[makhamadzoidov]

Hello

I used UPDATE query in query generator for sap business one to change items (oitm) validFor and frozenFor fields. Update query worked good but then I couldn't add item for oitm (items). How to fix it? 

I have written 
UPDATE OITM T0

SET T0."ValidFor" = 'Y', T0."frozenFor" = 'N'

[inga_babco2]

Hello Makhamad,

An UPDATE command is not allowed. But your problem has nothing to do with the UPDATE command. The error message says that there is a syntax error in a formatted search. The query for the formatted search is probably called "Товары/услуги - ЕИ продаж по умолчанию".

Best regards

Inga

[makhamadzoidov]

No, Everything was great before I wrote update query. Right now I can't add documents (for example item, warehouse, itemgroups, invoice, order, etc). I have a problem with SAP hana database. I think I have changed structure of database OITM table.