Creating reports and dashboards | Stimulsoft community forum

hello

I just downloaded the trial. I have a (brand new) local bitnami wordpress stack I want to trial it with.

I can connect to the database but I can't retrieve any data. When I press retrieve columns I get this error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

any suggestions?

thanks

Hello.

Please clarify which version do you use, Flash or JS?
What SQL query do you use?
Are you sure that there is no a ny error in your query?
Please, send us this query.

Thank you.

Im using the Windows trial of designer for PHP

no query involved - I cant get that far. This error occurs when I try to access the database after I connect.. The connection message says it connected ok but when I try to retrieve any information this error message comes up

thanks for your help

Hello,

We are found the issue. Will be fixed in the next build.
On current build if you uses "limit" in the query, try to use the uppercase symbols:
SELECT * FROM Table1 LIMIT 1

Thank you.