Subject | BLOB UDF Problem ... |
---|---|
Author | Intertex |
Post date | 2005-01-18T03:50:07Z |
Hello,
I have a problem writing simple UDF for FB.
I'm use Firebird-1.5.0.4290_embed_win32 and Delphi 7 for UDF.
I have large table "Q" (over 50 000 records) that contain BLOB field.
I want write small UDF that would read this BLOB field and make some
changes.
So, I try to use simple sample from
borland: http://bdn.borland.com/article/0,1410,25785,00.html
I have register my function exactly as in sample:
declare external function fn_BlobCat
Blob,
Blob,
Blob
Returns parameter 3
entry_point 'BlobCat'
module_name 'BlobConcat.dll';
Problem:
When I try to load all records from my program
SELECT
fn_BlobCat(...)
FROM
Q;
It's "eat" all my memory and work only on computers where 1GB of
memory installed - if computer have less than 1GB - "Out of
memory/system resources..." error appear. However, without UDF
function I can read all records from this table.
It's seems memory (BLOBs) not released after using any UDF function???
Thanks
I have a problem writing simple UDF for FB.
I'm use Firebird-1.5.0.4290_embed_win32 and Delphi 7 for UDF.
I have large table "Q" (over 50 000 records) that contain BLOB field.
I want write small UDF that would read this BLOB field and make some
changes.
So, I try to use simple sample from
borland: http://bdn.borland.com/article/0,1410,25785,00.html
I have register my function exactly as in sample:
declare external function fn_BlobCat
Blob,
Blob,
Blob
Returns parameter 3
entry_point 'BlobCat'
module_name 'BlobConcat.dll';
Problem:
When I try to load all records from my program
SELECT
fn_BlobCat(...)
FROM
Q;
It's "eat" all my memory and work only on computers where 1GB of
memory installed - if computer have less than 1GB - "Out of
memory/system resources..." error appear. However, without UDF
function I can read all records from this table.
It's seems memory (BLOBs) not released after using any UDF function???
Thanks