[Lazarus] Reading\Writing Blobs (Maybe off-topic)

[Andreas Berger]

  Interesting. So you load via a stream? Do you first write the blob to 
the stream, rewind and then pass it to the parameters?

Regards
Andreas

On 19/8/2010 4:11 AM, Birger Jansen wrote:
> I have experience with firebird, blob fields, and a little bit zeos, but not with the combination of all three together. We always use blobs with (memory)streams and parameters. A query then looks like
>
> MyQuery.SQL.Text := 'UPDATE BlobTable SET BlobField = :BlobField WHERE MyID = :MyID'
>
> And the query-parameter is set:
>
> MyQuery.Params.ParamByName('BlobField').LoadFromStream(MemSt, ftBlob);
>
> Maybe you have the same options in Zeos?
>
> Kind regards,
>    Birger