Subject | Blob insert using Delphi and memorystream. |
---|---|
Author | Dan Cumpian |
Post date | 2003-01-15T03:11:28Z |
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]
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]