Subject LOAD EXTERNAL FILE FOR FIREBIRD BLOB
Author ibrahim Bulut
hi
we are using firebird and delphi 5 ent.
we have a problem.

There is an external file which name is ('C:\MyTextFiles\Report.Dfm').

in delphi, we can load this file into a memo
Memo1.Loadfromfile('C:\MyTextFiles\Report.Dfm').

Can we do it with firebirdsql.
Like
Select Loadfile('C:\MyTextFiles\Report.Dfm') from rdb$database;

Database will find the file, and load it to a text blob file.



in ibconsole,
when i was browsing the RDB$RELATIONS table,
i saw a domain
CREATE DOMAIN RDB$EXTERNAL_DESCRIPTION AS BLOB SUB_TYPE
EXTERNAL_FILE_DESCRIPTION SEGMENT SIZE 80;
can we load external file with this blob type

Best regards


Ibrahim Bulut
Software Developer
Republic of Turkey