Forum > Databases
How to Load lazreport from blob
(1/1)
sydenis:
ubuntu 20.04 + lazarus 2.0.12
I am trying to load report from my SQLite db:
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} --- fStream := TMemoryStream.Create; (fQuery.FieldByName('blob') as TBlobField).SaveToStream(fStream); fQuery.Close; fStream.Position := 0; fStream.SaveToFile('blob.lrf'); //for cheking fStream.Position := 0; with frReport do begin LoadFromStream(fStream); ShowReport; end;
I get an exception: Invalid binary report: Invalid report version (60).
When I take my control file 'blob.lrf' (see above) and do
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} --- with frReport do begin LoadFromFile('blob.lrf'); ShowReport; end;
all is good... (
I try to use frReport.LoadFromDB but the problem persist.
So, where is the mistake. How to load report from db blob?
see report file in attachment
korba812:
Use "LoadFromXMLStream(fStream)" instead of "LoadFromStream(fStream)". LoadFromStream is for prepared binary report.
sydenis:
Thank you very much! Works fine.
Navigation
[0] Message Index