Subject Blob insert using Delphi and memorystream.
Author Dan Cumpian
Hello,



I have the following query which was written for MySQL (in Delphi).
Unfortunately, this doesn't work the Interbase. The second parameter if
ftBlob, MessageBody is a TStringLIst, and MsgStream is a TMemoryStream.



MessageBody.SaveToStream(MsgStream);


DMFirebird.QryStoreBody2.ParamByName('PartID').Value:=JobParams;

(DMFirebird.QryStoreBody2.Params[1] as
TParam).LoadFromStream(MsgStream,ftBlob);

DMFirebird.QryStoreBody2.ExecSql;



What do I need to change to make this insert compatible with Interbase?





Thanks,

Dan Cumpian





[Non-text portions of this message have been removed]