Subject RE: [ib-support] Help with query
Author Helen Borrie
At 10:03 PM 15/01/2003 -0500, you wrote:
>Helen,
>
>Thanks for the reply.
>
>The Blob field is Subtype 0. The error message is:
>
>Dynamic SQL Error. SQL Error Code = -104
>Unexpected end of command.
>Invalid token '.
>
>The MsgStream I am using is a TMemoryStream. How can I use a
>TBlobStream on
>an insert query that contains no field information?
>
>The SQL string in the query is :
>
>Insert into messages (body) values (:body)
>
>
>Any advice is much appreciated...

This isn't a Delphi list but I point you to TDataset.CreateBlobStream
function, which takes a TField (the persistent field object created for
your database blob column) and returns a blobstream, which you can then
pass in your TParam.LoadFromStream call. It's quite well-documented in the
Delphi help.

heLen