[SOLVED] Read Picture from Postgresql Database Unknown Picture Format [blob]

[heejit]

Code: Pascal  [Select][+][-]

1.  
2. Working :
3.  astream : TStream
4.  astream := m_qry.CreateBlobStream(m_qry.FieldByName('file_data'), bmRead);
5.  self.imgWidget.Picture.LoadFromStream(astream);
6.  
7. Not Working : Unknown Picture Format
8.   astream : TMemoryStream
9.  TBlobField(self.m_qry.FieldByName('file_data')).SaveToStream(astream);
10.  self.imgWidget.Picture.LoadFromStream(astream);
11.  

In documentation also it suggested to use TBlobField  :
https://www.freepascal.org/docs-html/fcl/db/tdataset.createblobstream.html

Then why there is format Error?

Development Env:
Lazarus   : 2.0
Feepascal : 3.0.4
SVN Rev   : 60350M
OS        : Linux 64bit Ubuntu 16.04

[heejit]

Solved
We need to move the position of stream to beginning

astream.Position:=0;