Devart Forums

Hi
I try make test table with name ONLY from digits:

(info from DBMonitor)
"SQL Execute: CREATE TABLE `123` (`ID` int(11) NOT NULL auto_increment,...
Complete
SQL Execute: SELECT * FROM `123`
Complete
"

But, when I try insert data to this table - error

"SQL Execute: INSERT INTO 123
(NAME)
VALUES
(?)
:NAME(FixedChar[5],IN)='Peter'
Error
"
After many tests I understood, that the name of the table should not consist only digits.


This restriction MySQL or components?

You should set the QuoteNames option of you MyQuery/MyTable to True.

Antaeus wrote:You should set the QuoteNames option of you MyQuery/MyTable to True.

Thanks, now all is normal.