I can't use a sentence using MySQL functions to calculate some column in a DBQuery.
PHsPeed V1.3.0 B7 - x64, PHP 7.4.5
Steps to reproduce:
Just add a DBQuery and set the SQL property to
select concat('This is','a sample') as mycolumn
Then generate code and try to run the form. The field name ignores the alias, and is set to "concat('This is". I tried a variety of functions, like "if" or "curdate", with same results.
Of course I could create a VIEW with the aliased column, but is not always feasible
Reproduced and acknowledged! Progress can be followed on
The issue is fixed and you have received a link with the corrected IDE. Please verify. If ok we will deploy in the next release.