WHERE clause gives error in HSQL Database manager

1
Hi, When i add the WHERE clause to SQL query like =>  SELECT * FROM "PUBLIC"."dpvlite_prototype$e_attrvalue" WHERE attributecode='X_DEV' , it gives error user lacks privilege or object not found Is there any configuration missing or incorrect syntax. ? I am using the in-built HSQL database.      
asked
2 answers
0

Hi Sandeep,

 

Refer this one https://forum.mendix.com/link/questions/8844

answered
0

Try the same sql commant in the HSQL-database editor itself. If you do get a result, the problem is very likely the privilege.

answered