Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Andreas Frieß via fpc-pascal
Am 15.12.2022 um 11:15 schrieb Michael Van Canneyt via fpc-pascal: On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: On MSSQL i use a stroed procedure to count a value in a table and use the following statement in Lazarus 1.     procedureTForm1.BuExecuteClick(Sender:TObject); 2

[fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Andreas Frieß via fpc-pascal
On MSSQL i use a stroed procedure to count a value in a table and use the following statement in Lazarus 1. procedureTForm1.BuExecuteClick(Sender:TObject); 2. var 3.   SQL:string; 4. begin 5.   Memo1.Clear; 6.   SQL:=''; 7.   SQL:='EXECUTE [dbo].[GetNextZaehler] :TagN

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-19 Thread Andreas Frieß via fpc-pascal
Am 19.03.2021 um 13:34 schrieb Michael Van Canneyt via fpc-pascal: On Fri, 19 Mar 2021, Andreas Frieß via fpc-pascal wrote: If it is not a bug, so a featurerequest must be possible, because other reports can handle this without a problem. You can definitely submit a feature request. For

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-19 Thread Andreas Frieß via fpc-pascal
Am 19.03.2021 um 11:07 schrieb Michael Van Canneyt via fpc-pascal: On Fri, 19 Mar 2021, Michael Van Canneyt via fpc-pascal wrote: On Fri, 19 Mar 2021, Andreas Frieß via fpc-pascal wrote: Make a Report Preview -> only the contend of the first dataset is shown. I will file a bug

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-19 Thread Andreas Frieß via fpc-pascal
Am 18.03.2021 um 16:06 schrieb Andreas Frieß via fpc-pascal: Am 18.03.2021 um 14:24 schrieb Michael Van Canneyt via fpc-pascal: In that case, you must put lReportOLData2 on a separate design page. So: * Add a design page (page 1) to the report. * Do what you need with lReportOLData1 on this

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-19 Thread Andreas Frieß via fpc-pascal
If i load the design created by the demo in the FPReportDesigner i see the expected layout. DBBand01 should show the the data of the first Objectlist,  DBBand02 the data from the second Objectlist. Actual changed demo included. Am 18.03.2021 um 14:13 schrieb Andreas Frieß via fpc-pascal: The

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-18 Thread Andreas Frieß via fpc-pascal
Am 18.03.2021 um 14:24 schrieb Michael Van Canneyt via fpc-pascal: On Thu, 18 Mar 2021, Andreas Frieß via fpc-pascal wrote: The expected layout is in the demo. 'Expected layout' for me is a PDF, screenshot image of some finished document, showing what you want to see printed.

Re: [fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-18 Thread Andreas Frieß via fpc-pascal
The expected layout is in the demo. I have data inside of ObjectsList=OL (here in the demo two) and i want to report one OL by one. This should be done continuos and each OL have their own layout. There is no master-detail. After one OL is finished the next should be processed and appended, if th

[fpc-pascal] fpreport: can not use two ObjectLists as datasource in one report

2021-03-18 Thread Andreas Frieß via fpc-pascal
I have a sample attached to show the problem. I want in the report (created a runtime) to use more than one report datasource. I create a databand and connect this with a TFPReportObjectListData object. Each TFPReportObjectListData object works. But i want to have the data of the first, then the

Re: [fpc-pascal] fcl-report demos not working on windows10/64 with win64 compiled - Font Arial not found

2019-12-29 Thread Andreas Frieß
ished that, we can check why the fallback is not found, and perhaps the error message. Michael. On Fri, 27 Dec 2019, Andreas Frieß wrote: Hello Michael, if the font is not found, why is there not the correct indication of the missing font ? The errormessage is in this case completly wrong. If a f

[fpc-pascal] fcl-report demos - expressions - have problem with [RecNo]

2019-12-27 Thread Andreas Frieß
There is more not working in the report demos. The expressionparser have problems with a simple [RecNo] D:\data\lazdev\trunk64\fpcsrc\packages\fcl-report\demos>fcldemo -d expressions Exception at 000100096E0D: EExprParser: Expected ( bracket at position 12, but got -. Heap du

[fpc-pascal] Fwd: Re: fcl-report demos not working on windows10/64 with win64 compiled - Font Arial not found

2019-12-27 Thread Andreas Frieß
os do not use Arial on purpose. Probably it is used as a fallback somewhere. So the question is: why is the demo falling back to Arial ? It means the actually used font (Liberation Sans, line 74 of rptjson) is not found. Michael. On Fri, 27 Dec 2019, Andreas Frieß wrote: The reason (with Read

Re: [fpc-pascal] fcl-report demos not working on windows10/64 with win64 compiled - Font Arial not found

2019-12-27 Thread Andreas Frieß
0 unfreed memory blocks : 0 True heap size : 262144 (320 used in System startup) True free heap : 261824 Michael Van Canneyt wrote: > > > On Fri, 27 Dec 2019, Andreas Frieß wrote: > > > I have now built the fcl-fpreport demos on win64 on a Windows10/64 > >

[fpc-pascal] fcl-report demos not working on windows10/64 with win64 compiled - Font Arial not found

2019-12-27 Thread Andreas Frieß
I have now built the fcl-fpreport demos on win64 on a Windows10/64 machine. But the demo is not running (comandline with -d jsondata -f pdf), because the font Arial is not found. It looks like the demos didnt use the gTTFontCache.ReadStandardFonts and so the standard font is not found. If i chang

Re: [fpc-pascal] fcl-fpreport not built complete, missing fpreport.dom

2019-12-26 Thread Andreas Frieß
code see https://forum.lazarus.freepascal.org/index.php/topic,47627.msg344017.htm l#msg344017 and https://forum.lazarus.freepascal.org/index.php/topic,47889.msg344069.html#msg344069 Andreas Michael Van Canneyt wrote: > > > On Thu, 26 Dec 2019, Andreas Frieß wrote: > > > I ha

[fpc-pascal] fcl-fpreport not built complete, missing fpreport.dom

2019-12-26 Thread Andreas Frieß
I have get fpc from actual svn trunk for x64 on windows and x64 on linux (debian) and i have seen, some parts of fcl-fpreport are not built and i found no ppu's for it. maybe the makefiles for fpreport have to be refreshed. I am missing fpreportdom.pp compiled, there is no fpreportdom.ppu. In the

[fpc-pascal] Backport of Bugfix 0031517 possible

2018-03-22 Thread Andreas Frieß
Hello, it looks the fix Bug 0031517 is more and more visible, if you compile an actual stable Lazarus with the actual stable fpc. You see with a Lazarus with more packages, the Error - No memory left - rises. See e.g. the thread http://forum.lazarus.freepascal.org/index.php/topic,40351.0.htm

Re: [fpc-pascal] fpreport rangeerrors with TFPReportColor

2018-02-24 Thread Andreas Frieß
Am 22.02.2018 um 08:05 schrieb Michael Van Canneyt: On Thu, 22 Feb 2018, Andreas Frieß wrote: Another possible Problem with the definition TFPColor (fpc)  record with word <> TColor (lazarus) -$7FFF-1..$7FFF <> TFPReportColor (fpreport) UInt32 So you cannot use in Lazar

Re: [fpc-pascal] fpreport rangeerrors with TFPReportColor

2018-02-21 Thread Andreas Frieß
Another possible Problem with the definition TFPColor (fpc)  record with word <> TColor (lazarus) -$7FFF-1..$7FFF <> TFPReportColor (fpreport) UInt32 So you cannot use in Lazarus the 'well known' TColors. With TColor it is also Delphi compatible. If the defines are Lazarus compatibl

Re: [fpc-pascal] fpreport rangeerrors with TFPReportColor

2018-02-21 Thread Andreas Frieß
Andreas Frieß wrote: > when i compile in Lazarus the Reportdesigner with activated > RangeCheck it gives a lot of runtimeerror with rangeerrors. > For explanation what i mean in my previous post, UInt32 is not an integer or JSON compatible size (and actual rangecheck unsafe).

[fpc-pascal] fpreport rangeerrors with TFPReportColor

2018-02-21 Thread Andreas Frieß
when i compile in Lazarus the Reportdesigner with activated RangeCheck it gives a lot of runtimeerror with rangeerrors. The definition is TFPReportColor  = type UInt32; Loading and saving in JSON is done by function ReadInteger(AName: String; ADefault: Integer): Integer; override; function Wri

Re: [fpc-pascal] googleapiconv raises ERESTAPI error

2016-11-08 Thread Andreas Frieß
, 6 Nov 2016, Andreas Frieß wrote: Hello, i will try to use the googleapiconverter from the gooleapi examples directory. I got some excepions, so i reduced the problem to a generic one. I use the trunc of FPC and compile the googleapiconv without a problem (inside lazarus). If i run it direct from

[fpc-pascal] googleapiconv raises ERESTAPI error

2016-11-06 Thread Andreas Frieß
Hello, i will try to use the googleapiconverter from the gooleapi examples directory. I got some excepions, so i reduced the problem to a generic one. I use the trunc of FPC and compile the googleapiconv without a problem (inside lazarus). If i run it direct from commandline with -A -k ig ot t

[fpc-pascal] html and chm help (lcl, fcl) translation in other languages ?

2009-01-05 Thread Andreas Frieß
hard to find things. Andreas Frieß schrieb: when i search for the lazarus help system with html and the comming chm, i didn't find information about the creating this, for other languages. It is not clear for me, how to handle this. The study of the structure of the svn and the sea

[fpc-pascal] html and chm help (lcl, fcl) translation in other languages ?

2008-12-25 Thread Andreas Frieß
when i search for the lazarus help system with html and the comming chm, i didn't find information about the creating this, for other languages. It is not clear for me, how to handle this. The study of the structure of the svn and the search inside of the wiki and the docs didn't make it clear