Master detail SQL error - Incorrect syntax near '='

PHPMaker General Discussion (PHPMaker)
1

Hi, please, I loaded and generated my old project from phpmaker 2018 to the 2024 version. Every table is working fine.But one table has a master/detail relation.

But when I click the icon to see the detail I got this error:C:\xampp\htdocs\checklist\phpmaker\vendor\doctrine\dbal\src\Driver\API\SQLSrv\ExceptionConverter.php(33): An exception occurred while executing a query: SQLSTATE [42000, 102]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ‘=’. SQLSTATE [42000, 8180]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.how can I fix this. or what could be the issue.?
thank you
Gustavo

2

You may enable Debug and check the log file for detailed error message with the complete SQL.

3

We need your sql code you executed on this page.Propably you have wrong condiion ex. where ID == 1 and its should be a where ID=1 or where ID=‘1’