Okay, okay, yes it's a very old topic, but it's an even older bug!
I can confirm that the TSimpleJSONExporter uses the wrong separator!
It also uses badly formed tokens for true, false and null. The json standard defines those tokens in lower case.
Fixes:
line 225 ->
line 229 ->
line 231 ->
lines 242-244 should be removed leaving just
FCurrentRow:=FCurrentRow+', ';
lines 259-261 should be removed leaving just
FCurrentRow:=FCurrentRow+', ';
I don't have a gitlab account so it would be good if someone could make these changes.
for those that want a local change on windows, rebuilding fpc can be a real hassle, so I recommend:
1. Create a new project
2. Copy C:\lazarus\fpc\3.2.0\source\packages\fcl-db\src\export\fpsimplejsonexport.pp into your project directory
3. Add it to your project
4. Compile your project
5. Copy fpsimplejsonexport.o, fpsimplejsonexport.ppu, fpsimplejsonexport.rsj into C:\lazarus\fpc\3.2.0\units\x86_64-win64\fcl-db