Cool, thank you, couldn't for the life of me find the savetofile just needed to cast the field as TBlobField...
TBlobField(ADOQuery.FieldByName('DCImage')).SaveToFile... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: Friday, 15 June 2007 2:25 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Friday afternoon question Dave Same way isn't is TblobField.Savetostream? > I am storing data in a SQL Server 2000 image field. > > I have no problem writing the image to the table, but have a complete > block for getting the image out again... > > I am using D2005 and TADOQuery. > > Any help please. Total mind blank. > > Regards, > 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 > > > _______________________________________________ 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 _______________________________________________ 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