[DUG] Images and MS SQL Server

[Neven MacEwan]

Dave

Hasn't Tblobfield got the same streaming functions IIRC
>
> 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 at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe