Devart Forums

Posted: **Tue 28 Jun 2022 18:14**

Hi,

I have a Firebird 3.x database with a table MyTable and this field:

MyField     BLOB SUB_TYPE 1 SEGMENT SIZE 512

I'm using IBDAC 8.1.1 with an TIBCQuery and this SQL statement:

Code: Select all

select cast(MyField as varchar(8000))
from MyTable
where ID = 123

This gives this error:

Code: Select all

unable to allocate memory from operating system

My record with ID 123 has only 10 chars in MyField.
If I use this SQL statement in an 3rd party database management tool (IBExpert) an run it, everything is ok.
Older versions of IBDAC have executed this code without any problems.

What can we do?

Posted: **Mon 04 Jul 2022 09:04**

Hi,
We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly IBDAC build including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html

Devart Forums

TIBCQuery Error "unable to allocate memory from operating system"

TIBCQuery Error "unable to allocate memory from operating system"

Re: TIBCQuery Error "unable to allocate memory from operating system"