Standard version 4.40.0.18 , MyUpdateSQL component Access violation.

kalmen · Post by **kalmen** » Mon 18 Sep 2006 13:32

Hi,

Just upgraded the component to
MySQL Data Access Components Standard version 4.40.0.18

now all my myUpdateSQL component , during deisgn time ,
right click->MyUpdateSQL Editor...->SQL Generator-->Generate SQL-->
Access Violation.

pls rectified , thanks.

swierzbicki · Post by **swierzbicki** » Mon 18 Sep 2006 13:55

You should post some additional infos, like for example your SQL Statements. Without such infos nobody will be able to help you

Antaeus · Post by **Antaeus** » Tue 19 Sep 2006 16:05

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

jostos · Post by **jostos** » Fri 22 Sep 2006 23:38

I also have this problem with ALL My Queries, and therefore, the generator is worthless and cannot be used at all. All Queries have to be hand-coded.

When should the update be expected?

Changing the subject a bit, I would also like to use the Query builder, but all SQL code is generated with the database prefix, which is not compatible with my application, where the actual database used may change (same application on multiple databases with diferent names). There should be an option to allow the generator not to include it.

Your tools for helping the developer does not help at all unless:
a) They work correctly (without giving errors)
b) The developer can configure them to meet his needs or style

Regards
Jay

Antaeus · Post by **Antaeus** » Mon 25 Sep 2006 11:28

> When should the update be expected?
The new build of MyDAC will be available during this week.

> There should be an option to allow the generator not to include it.
Unfortunately there is no such option in MySQLBuilder. We do not plan to make any changes in MySQLBuilder in the near future. You can use a text editor to remove database name from the query.