At 05:45 PM 20/08/2003 -0700, you wrote:

>I have a variable defined as TIB_ColumnBlob and assign the variable the
>blob field. But I get a compile time error when I try:
>
> lOptionValues.LoadFromStream(lMS);
>
>How can I load the value from a stream?

A TIB_ColumnBlob can't exist self-contained - it has to be associated with
a blob column from the database. If you have a query with a blob column in
it, then IBO has already created a TIB_ColumnBlob for it. All you have to
do is call the TIB_Column's LoadFromStream method, e.g.

with myDataset do
begin
FieldByName('MyBlobColumn').LoadFromStream(IMS);
end;

Assign should also work directly:
FieldByName('MyBlobColumn').Assign(IMS);

Helen