|Subject||Re: [firebird-support] Passing a BLOB to a Stored Procedure in FIBPlus|
> I have a Picture (Delphi Tpicture object) that I am trying to save inAre you using this construct to SAVE the BLOB?
> Firebird 1.5. I use stored procedures for all calls to the database. I
> have created a stored procedure that is called as follows:
> SELECT * from PHOTO_SAVE_PRC(:PHOTO_ID, :PHOTO_IMAGE_BLOB);
> I'm not exactly sure of two things:to
> 1. What BLOB sub type should I use when storing Delphi Tpicture objects
> the databaseUsually subtype 0 being "binary".
> 2. What is the convention for saving & loading through a Stored Procedurethis
> to Delphi? I'm using FIBPlus to communicate with Firebird. Note that
> is through a stored procedure, and not through any Data Aware components.I would suggest a stored procedure component.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!