Table Error when running application, but not in preview mode

I am using transaction groups to write to MySQL database, and then displaying the logged information onto a table. In the data binding property, I am putting:

SELECT Product_Code, Disp_Qty, t_stamp
FROM table

there are no errors, and can see the information logging to the table when in preview mode. But when I run the application, there is an error, but no error message.

Any thoughts on what could be causing this error?

You’re using a legacy database query without enabling legacy access for the client. Convert your query to a named query, bind it to the table, and it will work. You can also grant legacy access in project properties → Permissions, but it is a security risk and an anti-pattern (bad design).


Thank you very much for your reply. Works great now.