Subject | Passing a BLOB to a Stored Procedure in FIBPlus |
---|---|
Author | Myles Wakeham |
Post date | 2005-11-18T15:08:14Z |
I have a Picture (Delphi Tpicture object) that I am trying to save in
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:
1. What BLOB sub type should I use when storing Delphi Tpicture objects to
the database
2. What is the convention for saving & loading through a Stored Procedure
to Delphi? I'm using FIBPlus to communicate with Firebird. Note that this
is through a stored procedure, and not through any Data Aware components.
All help greatly appreciated.
Myles
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org
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:
1. What BLOB sub type should I use when storing Delphi Tpicture objects to
the database
2. What is the convention for saving & loading through a Stored Procedure
to Delphi? I'm using FIBPlus to communicate with Firebird. Note that this
is through a stored procedure, and not through any Data Aware components.
All help greatly appreciated.
Myles
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org