I'm using FB1.5, and looking for a UDF that would allow me to load an
external file into a blob, or write an external file from a blob. I
have found a couple of UDF's on the IBPhoenix site that relate to
external files, but don't have the functionality outlined above.

For instance:

create table Report (
report_id integer not null,
contents blob);

insert into Report
(report_id, contents)
values
(1, ReadFile('c:\temp\Report.xls');

select
report_id, WriteFile(contents, 'c:\temp\Report2.xls')
from
report


I could do without the WriteFile at the moment, but need a quick way
to insert some old files into the database without writing a UI to do
it.

tia,

Bob M..