I am new to HSQL and BASE. I am trying to update a column in my table with the following commands using the Direct SQL mode.
I receive the following error " Unexpected token: “ in statement [UPDATE ]"
Here is my code:
UPDATE “HookDescriptor"
SET “HookDescriptor".“DescrTest” = “Temp”
WHERE “HookDescriptor”.“Use_ID” > 2
DescrTest type is Text, Use_ID type is Integer
What am I missing?
Hello,
You can only run SELECT statements in the Query section for HSQLDB. Run other statements in menu selection Tools->SQL.
Also, quick look - “Temp” s/b ‘Temp’
Edit:
Check your quote marks:
“HookDescriptor"
should be:
"HookDescriptor"
multiple instances. Please verify all.
Thank you Ratslinger! I missed the quote mark difference. That was the trick. I was doing this in menu selection Tools->SQL.
As with all answers, as you have been helped, please help others to know the question has been answered by clicking on the 
in upper left area of answer which satisfied the question.