Subject RE: [ib-support] Re: problem with blob field
Author Thomas Steinmaurer
> I use the FreeUDFLib Library
> (www.cvalde.com/utilities/freeudflib.zip)
>
> the query string to insert is :
>
> insert into table (nameField) values (F_STRBLOB('This is the text
> that don't accept 256 chars...'))
>
> This query works whith this text, but no longer 256 chars.

If you have declared the UDF within your database by using
the DDL statement out of 'ext_funcs.sql', then this will be
something like that:

declare external function f_StrBlob
cstring(254),
blob
returns parameter 2
entry_point 'StrBlob' module_name 'FreeUDFLib.dll';


1) Drop the function with:

DROP EXTERNAL FUNCTION F_STRBLOB;

2) Redeclare it with a higher value for the first cstring parameter.
For example:

declare external function f_StrBlob
cstring(500),
blob
returns parameter 2
entry_point 'StrBlob' module_name 'FreeUDFLib.dll';



HTH,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com