[DUG] Images and MS SQL Server

[Dave O'Brien]

I have worked out how to save an image into an Image field, but I'm
having brain fade on how to retrieve the image... Using TADOQuery,
D2005.

 

Save:

 

    ...

    datamod.ADOU.SQL.Add(':Image)') ;

    ms := TMemoryStream.Create ;

    try

      Image.Picture.Bitmap.SaveToStream(ms);

      ms.seek(0,0) ;

      datamod.ADOU.Parameters.ParamByName('Image').LoadFromStream(ms,
ftGraphic);

    finally

      ms.Free ;

    end ;

    datamod.ADOU.ExecSQL ;

 

Anyone (I suppose everyone has) got a way to get the image back?

 

Cheers,

Dave.


_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe