SQL error (SQL query error)

i just practice with ignition and have a problem with SQL
it run in designer perfect when it launch project something wrong
anyone can help me fix that error and explain it to me please, thanks everyone so much

The problem is client permissions, in the designer see menu Project -> Properties -> Client -> Permissions.
To allow SQL to run in the client you must enable ‘Legacy Database Access’ and optionally add the required client roles.

This restriction does not apply to Named Queries and gateway scoped Query Tags.

To fix, enable the client permission or preferable use tags/named queries for database reads and named queries for updates.

4 Likes

thank you so much
my project is working now