Since version 9.4.005, I have the following problem. In my pdfreports (PDF Report Applications), I found that if I have the fields defined as “subselect” and have the lookup settings “automatic”, there is the following error
“” Error
Error while accessing the database
Unknown column ‘Array’ in ‘where clause’
SELECT ProductGroupName FROM ProductGroups WHERE ProductGroupID = Array ORDER BY ProductGroupName “”
this is the content of the lookup settings of a subselected field in the lookup settings “automatic”
SELECT ProductGroupName
FROM ProductGroups
WHERE ProductGroupID = {InvoiceDetails.ProductGroupID}
ORDER BY ProductGroupName
These PDF reports have been running for a long time and have never really caused any problems. Unfortunately, these pdfreports generate “invoices”, meaning my customers can not write invoices at the moment.
If I leave the lookup settings blank, then it works, but of course only the IDs of the products and not their names will be displayed, but the pdfreport will work.
I attached an example of that, when i leave the lookup settings blank.
