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? |
CHECK is a reserved word / keyword. Use "check" or [check]. |