Page 1 of 2

AV in TVirtualQuery & TBlob fields

Posted: Thu 16 Aug 2018 19:24
by Samuel
When I try to write a BLOB field using the TVirtualQuery.LoadFromStream() function I get the error:

Project .. raised exception class $C0000005 with message 'access violation at 0x009da93a: read of address 0x00000010'.

This only occurs with TVirtualQuery (in the TVirtualTable, TUniTable or TUniQuery components the field is written without errors).

How to solve this?

I´m using:
Delphi 10.2 Update 3
Unidac 7.3.9

See the sample program at the link below:

https://1drv.ms/u/s!Al-1RWjYXpnaj_NhKVvvWuu3Zbrhjw

Re: AV in TVirtualQuery & TBlob fields

Posted: Fri 17 Aug 2018 14:52
by MaximG
Thank you for the information. We will investigate the described issue and let you know the results shortly.

Re: AV in TVirtualQuery & TBlob fields

Posted: Mon 20 Aug 2018 10:24
by Samuel
Just to your knowledge, I tested it with "Night Build" (downloaded today) and the same problem occurred.

Please, let me know when you have a new "night build" with this issue resolved because due to this error I had to suspend the development.

Thank you.

Re: AV in TVirtualQuery & TBlob fields

Posted: Tue 21 Aug 2018 09:50
by Stellar
Thank you for the information. We reproduced the issue with AV, as soon as we get a result, we will let you know.

Re: AV in TVirtualQuery & TBlob fields

Posted: Mon 03 Sep 2018 19:56
by Samuel
Can you let me know when the correction for this issue will be released?

Re: AV in TVirtualQuery & TBlob fields

Posted: Tue 04 Sep 2018 09:15
by MaximG
Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next UniDAC build. Currently, we can send you a night build of UniDAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form (https://www.devart.com/company/contactform.html)

Re: AV in TVirtualQuery & TBlob fields

Posted: Wed 05 Sep 2018 13:01
by Samuel
Thanks, but this change solved the AV only in the INSERT commands.

AV remains in the UPDATE command.

Sample project in this link:
https://1drv.ms/u/s!Al-1RWjYXpnaj_5wlZ97nnpykkiSTg

Re: AV in TVirtualQuery & TBlob fields

Posted: Wed 05 Sep 2018 13:57
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Re: AV in TVirtualQuery & TBlob fields

Posted: Tue 11 Sep 2018 12:39
by Samuel
I need to release the new version of my application to my users but to do this, I need this problem solved.

Can you let me know when the correction for this issue will be released?

Re: AV in TVirtualQuery & TBlob fields

Posted: Tue 11 Sep 2018 13:56
by MaximG
We plan to release our products build including the required changes next week. Currently, we can send you a night build with these fixes. For this, specify the IDE version you are interested in using via the e-support form (https://www.devart.com/company/contactform.html)

Re: AV in TVirtualQuery & TBlob fields

Posted: Tue 11 Sep 2018 14:00
by Samuel
Thank you very much.

Re: AV in TVirtualQuery & TBlob fields

Posted: Wed 12 Sep 2018 15:37
by Samuel
I installed the night build and I no longer receive the error message, however, when updating a blob field (UPDATE) instead of the image it writes ????.

Sample project in this link:

https://1drv.ms/u/s!Al-1RWjYXpnakIBZjUSkBKbhwC5PGA

I need a quick fix for these Virtual Table issues because this prevents me from releasing my application to my users.

Re: AV in TVirtualQuery & TBlob fields

Posted: Thu 13 Sep 2018 11:55
by MaximG
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Re: AV in TVirtualQuery & TBlob fields

Posted: Fri 14 Sep 2018 12:07
by MaximG
Bug with AV when editing a record in TVirtualQuery having BLOB columns is fixed. The fix will be included in the next build of our product, which we are planning to release next week.

Re: AV in TVirtualQuery & TBlob fields

Posted: Fri 14 Sep 2018 16:48
by Samuel
Is it possible to release an NB with this change so that I can start the final test of my application?