MySQL syntax error in runtime but not in design time

Thread View: borland.public.cppbuilder.database.dbexpress

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Pere Mateu Thu, 27 Dec 2007 16:30

#179

Author: Pere Mateu
Date: Thu, 27 Dec 2007 16:30

22 lines
1649 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads