Custom View - Column not found

PHPMaker General Discussion (PHPMaker)
1

I use Phpmaker 2022 v2022.12.2I’ve created a simple custom view to generate a list of cities, by retrieving the information through a couple of cross-sectional selections.
I called this custom view "view_city"Everything works fine until you click on the magnifying glass icon to see the record…This is the error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘tmp_LOOKUPTABLE.name’ in 'where clause’Error originated in module Connection.php line 849 on executeQueryActivating the debug, I suppose that error is due to the fact that the compiler does not convert “tmp_LOOKUPTABLE” in "CV_view_city"in fact if I insert this instruction before the executeQuery statement:

$query=str_replace(“TMP_LOOKUPTABLE”,“CV_view_city”,$query); //patch
return $this->executeQuery($query, $params, $types)->fetchAllAssociative();all works fine…Am I wrong?Thanxx to all!
Federico

2

As mentioned in its documentation, try to avoid using Custom View as possible.

If your database supports Database View, then you should use Database View. Try to create it in your database side, and then re-synchronize your PHPMaker project with the changes in your database.

3

Thanx for reply; but sorry, i cannot use view…