Jay,

FreeUdfLib sources files for windows have this function in unit BlobFncs
declared as
function StrBlob(sz: PChar; Blob: PBlob): PBlob; cdecl; export;

There are also the next functions in ext_funcs.sql file:

declare external function f_BlobMaxSegmentLength
blob
returns integer by value
entry_point 'BlobMaxSegmentLength' module_name 'FreeUDFLib.dll';

declare external function f_BlobSegmentCount
blob
returns integer by value
entry_point 'BlobSegmentCount' module_name 'FreeUDFLib.dll';

declare external function f_BlobSize
blob
returns integer by value
entry_point 'BlobSize' module_name 'FreeUDFLib.dll';

declare external function f_BlobAsPChar
blob
returns cstring(1024) /* free_it */ /* or 32000 or whatever... */
entry_point 'BlobAsPChar' module_name 'FreeUDFLib.dll';

declare external function f_BlobLeft
blob, integer
returns cstring(1024) /* free_it */
entry_point 'BlobLeft' module_name 'FreeUDFLib.dll';

declare external function f_BlobLine
blob, integer
returns cstring(1024) /* free_it */
entry_point 'BlobLine' module_name 'FreeUDFLib.dll';

declare external function f_BlobMid
blob, integer, integer
returns cstring(1024) /* free_it */
entry_point 'BlobMid' module_name 'FreeUDFLib.dll';

declare external function f_BlobRight
blob, integer
returns cstring(1024) /* free_it */
entry_point 'BlobRight' module_name 'FreeUDFLib.dll';

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

Maybe you can declare these functions in linux changing 'FreeUDFLib.dll'
with
'FreeUDFLibC' if it was compiled with this functions.


Luiz.

----- Original Message -----
From: Jay <johannes@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, February 19, 2001 1:29 PM
Subject: Re: [IBO] Blob alteration within a stored procedure


> Luiz Alves wrote:
> >
> > Jay,
> >
> > You can use f_StrBlob from freeUdfLib or programatically use a query
> > with
> > parameters in delphi. This will give you more flexibility to
> > manipulate the
> > blob content before update it.
>
> Appreciate that, but my server is a Linux box. :)
> I do have FreeUDFLibC which is the unix version of FreeUDFLib.
> However, FreeUDFLibC does not contain a 'f_StrBLob'.
> I also looked around amongst all the other UDF libraries in question,
> but did not find much.
>
> Cheers
>
>
>
>