I am evaluating the program and have a quick question about the SQL query feature. I'm not sure if I am just not able to perform this function in the trial version or if I am doing it wrong. Nevertheless, I am trying a simple update statement and getting an error. Can you please look at the statement below and tell me what is wrong?
SQL
update POSITEM set desc = 'Test' where desc = 'Gas'
ERROR
Command is missing required clause.