Inserting files into a database

IBEBlock can be used to insert files extremely simply and quickly into your database:

 execute ibeblock
 as
 begin
   MyVar = ibec_LoadFromFile(C:\f.jpg);
   insert into ... values (..., :MyVar);
   commit;
 end

Another possible way is to use different SET BLOBFILE statements before each INSERT/UPDATE statement:

SET BLOBFILE 'C:\f.jpg';
INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);
SET BLOBFILE 'C:\f2.jpg';
INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);
SET BLOBFILE 'C:\f3.jpg';
INSERT INTO ... VALUES (..., :h00000000_FFFFFFFF);