I'm using BDS2007 with dbExpress to connect to MySQL server.
We set up the following components: SQLConnection, SQLDataSet,
DataSetProvider and ClientDataSet.
We enter a simple query like this:
SELECT * FROM `TB_envases`
And in design time everything works fine: I can see all the registers from
'TB_envases' in a DBGrid.
But when I execute the program, in runtime I get this error:
First chance exception at $7C812A5B. Exception class TDBXError with message
'You have an error in your SQL syntax near ''TB_envases'' at line 1'.
Process Project1.exe (2400)
I've tried to activate all the components manually by code, but the result
is the same.
Any ideas?
Regards,
Pere