Generated code fails
Parse error: syntax error, unexpected ‘N’ (T_STRING), expecting ‘]’ in /www/htdocs/scriptcase-8.1/app/test/grid_TEST/grid_TEST_grid.class.php on line 208
To replicate:
Create grid application based on
SELECT NVL(A.REPORT_DESCR, ‘N/A’) AS REPORT_DESCR
FROM TEST A
Column aliases confuse code generator.
If sort by REPORT_DESCR is enabled generator will create extra code for column itself
$this->Cmps_ord_def[‘report_descr’] = " asc";
$this->Cmps_ord_def[‘NVL(A.REPORT_DESCR,‘N/A’)’] = “”;
To run application one will either have to disable sorting or comment out extra code:
$this->Cmps_ord_def[‘report_descr’] = " asc";
// $this->Cmps_ord_def[‘NVL(A.REPORT_DESCR,‘N/A’)’] = “”;