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);

See also:
Inserting file data into a database

back to top of page
<< Recreating indices 2 | IBEBlock | Inserting file data into a database >>