STATUS reserved word since 4.30?

Guest · Post by **Guest** » Tue 31 Jan 2006 08:56

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

Ikar · Post by **Ikar** » Tue 07 Feb 2006 12:34

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

Wilton · Post by **Wilton** » Thu 09 Feb 2006 12:06

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

maerit · Post by **maerit** » Fri 10 Feb 2006 10:09

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.

Ikar · Post by **Ikar** » Fri 10 Feb 2006 14:10

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.

maerit · Post by **maerit** » Tue 14 Feb 2006 10:42

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.

Ikar · Post by **Ikar** » Wed 15 Feb 2006 13:03

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.

eduardosic · Post by **eduardosic** » Thu 16 Feb 2006 01:37

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.

vtur · Post by **vtur** » Mon 20 Nov 2006 12:52

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?

Antaeus · Post by **Antaeus** » Thu 23 Nov 2006 16:23

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

Devart Forums

STATUS reserved word since 4.30?

STATUS reserved word since 4.30?

Reserved Word - STATUS

Solved

Re: STATUS reserved word since 4.30?

table name problem "status"