Error in new version

Jelly · Post by **Jelly** » Wed 28 Jun 2006 20:07

Since I've installed the latest version of MyDAC (I had to, because of the incompatibilty with the IBDAC componens), I get an error when doing a MyQuery.Refresh...

The SQL Refresh statement looks like this:

Code: Select all

SELECT rm_versions.Project, rm_versions.Major, rm_versions.Minor, rm_versions.Release, rm_versions.Build, rm_versions.ReleaseDate, rm_versions.Downloadable, rm_versions.Setupname, rm_versions.StartDate, rm_versions.STATUS, rm_versions.SetupSize FROM rm_versions
WHERE rm_versions.ID = :Old_ID

The Status column is mispelled in UPPERCASE. But even if I change it to the correct case (Status), I get exactly the same error....

In older MyDAC versions, this error didn't occur, since I haven't changed anything with this component on my form, nor anywhere else in my code. The MySQL Server also ist exactly the same version.

Any suggestions ?[/img]

Zagawa · Post by **Zagawa** » Thu 29 Jun 2006 07:12

I have this kind of error sometimes too.

The way for me to fix it >

The FieldName properties of the fields in your query Component must be in the same case in your database.

If in a table in your database you have a field like : 'StAtUs'
Then the fieldname in Query component must be : 'StAtUs'

Antaeus · Post by **Antaeus** » Thu 29 Jun 2006 09:24

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Jelly · Post by **Jelly** » Thu 29 Jun 2006 22:44

Antaeus wrote:Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

This is great, and shows that the occuring problem doesn't lie on my shoulders

So thanks for the fix...