XE7 Error Access Violation when insert image to BLOB field by Firedac . #androidapps #sqlite3 #xe7 #Tmemorystream

-
XE7 Error Access Violation when insert image to BLOB field by Firedac .  #androidapps   #sqlite3 #xe7 #Tmemorystream  
It worked on XE6.
sample script.
      LStream := TMemoryStream.Create;
      Image1.Bitmap.SaveToStream(LStream);
      SQLUpdate.ParamByName('Image').LoadFromStream(LStream, ftBlob);

Anyone can suggust?
Thanks.

Comments

  1. Sam Shaw (蕭沖)September 9, 2014 at 6:16 AM

    Is it related to what's new in XE7 section: Firedac changes?
    http://docwiki.embarcadero.com/RADStudio/XE7/en/What's_New_in_Delphi_and_C%2B%2BBuilder_XE7

    ReplyDelete
  2. Lars FosdalSeptember 9, 2014 at 11:37 AM

    Sam Shaw - Very possible!
    FireDAC streaming support for blob parameters and support for MSSQL file streams
    New TFDParam properties : AsStream, AsStreams, IsDataSet, IsDatasets, IsObject, IsObjects, IsStream, IsStreams, IsUnicode, and StreamMode
    New TFDParam methods: GetDataReader and SetStream
    New TFDParams methods: Close and Unprepare.
    New TFDAdapterDataSet methods: CloseStreams.

    http://docwiki.embarcadero.com/RADStudio/XE7/en/What%27s_New_in_Delphi_and_C%2B%2BBuilder_XE7#FireDAC_Changes

    ReplyDelete
  3. Chapchai “9Tui” PongrungsapSeptember 9, 2014 at 2:08 PM

    Thanks.
    I change to SQLUpdate.ParamByName('Image').AsStream := LStream ;

    It's work. :)

    ReplyDelete

Post a Comment