No. My client cannot use SQL Server 2012 or newer. They only have license for SQL Server 2008, and they cannot upgrade it to v2012.My client really wanted to use PHPMaker 2023. I have been evaluating PHPMaker v2023 so that it can use database SQL Server 2008, and it seems it is working. It can connect to database properly.So, here are the next steps that I have already done.
Since from the documentation I read, DBAL v3 does not support SQL Server 2008 database anymore, so I downgraded the dbal version in composer.json template file, from:
“doctrine/dbal”: “^3.4.4”,to:
“doctrine/dbal”: “^2.12.1”,I re-generated all the script files, I saw from the generated log while system was generating the script files, dbal used version 2.13.9 (since it is the latest minor version for v2), and I think that’s fine. All the script files are generated properly without any error.Then I tested the generated web application via browser, both for localhost server and production server, and both are working properly, too. I can see data displayed properly in List, View, Edit pages properly. I tested the functionality of Add, Edit, and Delete, and they are working properly, too.The problem is only when I was trying to search data in Lookup Table as I explained in my first post above. I know, I read from this article that there are new functions in SQL Server 12, which is one of them is CONCAT function. And of course, this CONCAT function does not support for SQL Server 2008 database.Do you have any solution for this condition?