Subject | RE: [ib-support] Re: problem with blob field |
---|---|
Author | Thomas Steinmaurer |
Post date | 2002-06-19T20:11:36Z |
> I use the FreeUDFLib LibraryIf you have declared the UDF within your database by using
> (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.
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