It’s been 3 years ago since I evaluated Scriptcase and here I am, evaluating it again.
I’ve just downloaded the version 8 trial.
Created a grid, then select fields, turn it into automatic lookup.
SQL generated is :
SELECT sc_concat(firstname, middlename)
FROM “public”.userhdr
WHERE id = {createdbyid}
ORDER BY firstname, middlename
and no result shown in the column.
I’ve also tried Postgresql’s syntax SELECT firstname || lastname…, result is still empty.
But if I only select 1 column, like SELECT firstname…, the column shows correct value in the grid.
Any help please ?
Thank you in advance