Hi all,
Info on system:
Delphi 6.0
Firebird 1.0.0.796 running on rehat linux
Using IBx components from Interbase tab in delphi
I am not having any trouble with any other reads or updates.

Getting a "EIBInterbaseError with message 'invalid Blob ID' when
trying to update database.

I am using the following stored procedure and I have
verified in the debugger that all values are being passed.

Could it be the IBx components can not handle the blob in
Firebird. I intend to move to IBo but have not look at them
enough to understand which components to use.

thanks to all in advance

UPDATE_CALLDETAIL procedure

begin
UPDATE CALLDETAIL
SET
call_detail_id = :iCallDetailID,
case_id = :iCaseID,
support_name_id = :iSupportNameID,
call_detail_open_date = :iCallDetailOpenDate,
call_detail_close_date = :iCallDetailCloseDate,
call_detail_method_ID = :iCallDetailMethodID,
call_is_open = :iCallIsOpen,
call_detail_memo = :iCallDetailMemo
WHERE
call_detail_id = :iCallDetailID;
end




George R Smith
On the side of the software box, in the 'System Requirements'
section, it said 'Requires Windows 95 or better'.
So I installed Linux!