No exception on failure to prepare using version 10.1.2

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

No exception on failure to prepare using version 10.1.2

Post by upscene » Mon 09 Dec 2019 10:27

Hi,

The latest version of MyDAC doesn't raise a proper exception when .Prepared = True fails.

Using MySQL 5.7, I did the following:
- Put a TMyConnection on a form, make sure it can connect to a database
- Put a TMyQuery on a form, enter SQL like 'select * from unexisting_table'
- Put a TButton on the form, in OnClick: MyQuery1.Prepared := True

This raises an exception with an empty error message.

If you use MyQuery1.Open; instead, it raises the proper error message.

btw, this is a basic functionality failure, may I suggest high priority on fixing and releasing this?

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 2880
Joined: Wed 30 Jul 2014 07:16

Re: No exception on failure to prepare using version 10.1.2

Post by ViktorV » Mon 09 Dec 2019 15:38

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.
We can send you the nightly build of MyDAC that includes the fix. If you'd like to receive the nightly build, please send us your license key and the IDE version number.
For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

Re: No exception on failure to prepare using version 10.1.2

Post by upscene » Wed 08 Jan 2020 08:30

As explained via e-mail, nightly builds can't be used.

Any idea when the new release is coming - this is a basic functionality failure.

With regards,

Martijn

ViktorV
Devart Team
Posts: 2880
Joined: Wed 30 Jul 2014 07:16

Re: No exception on failure to prepare using version 10.1.2

Post by ViktorV » Wed 08 Jan 2020 14:43

We're planning to release a new build of MyDAC in the first quarter of this year.

upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

Re: No exception on failure to prepare using version 10.1.2

Post by upscene » Mon 20 Jan 2020 08:36

'first quarter', that can be anything between now and 3 months.

This is a basic functionality failure.

Combine this with the PostgreSQL components that can't access the latest PostgreSQL version and people can be in a bind: using this version results in a serious MySQL issue, using the previous version and you can't access Postgres.

Please run the tests and release soon.

With regards,

Martijn

ViktorV
Devart Team
Posts: 2880
Joined: Wed 30 Jul 2014 07:16

Re: No exception on failure to prepare using version 10.1.2

Post by ViktorV » Mon 20 Jan 2020 15:55

We're planning to release a DAC build in February, but we told you earlier we were going to release it in the first quarter just in case the release date would be moved to March due to some unexpected reasons.

JeanSmith
Posts: 1
Joined: Sat 22 Feb 2020 16:39
Location: https://meditest.in/
Contact:

Re: No exception on failure to prepare using version 10.1.2

Post by JeanSmith » Sat 22 Feb 2020 16:44

Thanks, this is exactly what I was looking for
I had the same problem

ViktorV
Devart Team
Posts: 2880
Joined: Wed 30 Jul 2014 07:16

Re: No exception on failure to prepare using version 10.1.2

Post by ViktorV » Wed 26 Feb 2020 11:35

We're planning to release a new build of MyDAC at the beginning of Match.

upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

Re: No exception on failure to prepare using version 10.1.2

Post by upscene » Wed 26 Feb 2020 11:55

This is taking too long. :-(

Post Reply