Subject | Help with query |
---|---|
Author | Dan Cumpian |
Post date | 2003-01-16T01:45:49Z |
Hello,
I figured out how to save a BLOB to an Interbase database, but I am
running into a problem due to the contents of the Blob.
I am using the following code to insert the blob:
MessageBody.SaveToStream(MsgStream);
DMMySQL.QryStoreBody1.ParamByName('PartID').Value:=JobParams;
(DMMySQL.QryStoreBody1.Params[1] as
TParam).LoadFromStream(MsgStream,ftBlob);
The problem is that the blob is an encoded NNTP message. I am getting an
error "invalid token '" when I try to do the insert. I tried doubling
the "'" characters, and this does work for some text, but it fails on
others. How can I get Interbase to accept the entire blob without having
to "doctor" it first?
Thanks for any help,
Dan Cumpian
I figured out how to save a BLOB to an Interbase database, but I am
running into a problem due to the contents of the Blob.
I am using the following code to insert the blob:
MessageBody.SaveToStream(MsgStream);
DMMySQL.QryStoreBody1.ParamByName('PartID').Value:=JobParams;
(DMMySQL.QryStoreBody1.Params[1] as
TParam).LoadFromStream(MsgStream,ftBlob);
The problem is that the blob is an encoded NNTP message. I am getting an
error "invalid token '" when I try to do the insert. I tried doubling
the "'" characters, and this does work for some text, but it fails on
others. How can I get Interbase to accept the entire blob without having
to "doctor" it first?
Thanks for any help,
Dan Cumpian