Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MySQL syntax error in runtime but not in design time

1 view
Skip to first unread message

Pere Mateu

unread,
Dec 27, 2007, 11:30:01 AM12/27/07
to
Hi,

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


0 new messages