Database query

[Former Member]

I am trying to execute update query ("UPDATE HEADER SET CHECK='"+HeaderTotal+"',CHECKNO='"+CheckNo.trim()+"' WHERE ORDER_NO='"+OrdNum+"'")) and i am getting this message com.ianywhere.ultralitejni12.implementation.JniException: UltraLiteJ Error[-131]: Syntax error near 'CHECK' %2

Am i doing something wrong? Is there any mistake in query?

[johnsmirnios]

CHECK is a reserved word / keyword. Use "check" or [check].

[Former Member]

In UltraLite, "check" is good, but [check] is not recognized.

[VolkerBarth]

FWIW, it's well documented here...