Hello,
SC9 with Microsoft SQL 2012 as backend.
The field “versione” is calculated via COALESCE syntax.
I use the COALESCE syntax in SQL and it works .
The same syntax in the form does not work.
I debugged the application and see the code is exactly as I write in the SQL .
SELECT COALESCE(1+MAX(versione),1)
FROM dbo.SAMPLES_CH
WHERE season=’{season}’ AND pattern=’{pattern}’
Is this by design , or is it a bug ?
I am looking for a solution to let the select work correctly ?
Thanks, Federico