Probably a simple one this, but I didn't expect it. I'm testing some SQL code below, trying out the CASE statement as per FM advanced training guide.
ExecuteSQL ( "
SELECT Sum (CASE RowID WHEN 1 THEN \"Amount\" END) ,
Sum (CASE RowID WHEN 2 THEN \"Amount\" END) ,
Sum (CASE RowID WHEN 3 THEN \"Amount\" END)
WHERE RowID = ?";
"" ; "" ;
My results on a list report sorted by a sub summary part set on RowID for my own clarity shows a two commas at the right side of the first row's result, one either side of the second row's result and two before the third row's result. I suspect it's something to do with the commas on the Sum statements, but removing them breaks the query. Screenshot attached.
Any help gratefully appreciated.