Devart Forums

For some reason a table in my database named 'status' gives a problem since the new 4.3 version.

On opening i get an errormessage stating: table xyz.STATUS doesn't exist.

If i roll back to previous release, the problem disappears.

Ruben

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

Also supply us following information

- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor

I'm have same problem with my applications, after install the new version
4.30, it's don't happen with :

MySQL server version: 4.1.14-standard-log
MySQL client version: Direct
MyDAC 4.00.2.8

My current environment (where the problem occurs):

Delphi 5
Latest MyDac components
Mysql 4.0.24

table in any database with name 'status' will do
table component on a form with property tablename set to 'status'
then open on run-time.....

error occurs!

Also tried direct-modus, no success.

Thanks for information, but we still cannot reproduce this prolem. We would be very grateful for simple program written in Delphi that connects to server, creates table, fills it (if necessary) and opens it with error. Please send it to mydac*crlab*com.

After upgrading the mysql server to 4.0.21 the problem disappeared.

So i guess there is a bug in the 4.30 in combination with the mysql 4.0.13 version i used, (the older components work correctly!).

Tx for the responses.

We tested MyDAC 4.30 with following MySQL Server versions: 4.0.11, 4.0.12, 4.0.21, 4.1.11, 5.0.17. We created table STATUS, filled it using TMyScript, opened it using TMyQuery. Everything works fine. Please send us (mydac*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

Anonymous wrote:For some reason a table in my database named 'status' gives a problem since the new 4.3 version.

On opening i get an errormessage stating: table xyz.STATUS doesn't exist.

If i roll back to previous release, the problem disappears.

Ruben

Rubens, where OS running you mySQL server? in Linux? in Windows?

mySQL in Lunix is Case-sensitive. table name STATUS of status.

Ikar wrote:We tested MyDAC 4.30 with following MySQL Server versions: 4.0.11, 4.0.12, 4.0.21, 4.1.11, 5.0.17. We created table STATUS, filled it using TMyScript, opened it using TMyQuery. Everything works fine. Please send us (mydac*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

I have the same problem with the table name"status".
Mysql server version: 5.0.22-standard
Mydac 4.40.0.20 for Borland C++Builder 6

Error message is:# 42502Table xxxxxx.STATUS does not exist.
Real name of table is "status".
Problem persists only under Linux (case sensitive), under Windows MySQL server it works.

Do you have any solutions?

This is issue of MyDAC. Try to quote the `status` table name manually to avoid converting it to the upper case.