App PDF Reports Problem since 9.4.005

Scriptcase 9 Bugs
#1

Since version 9.4.005, I have the following problem. In my pdfreports, 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

if i leave the lookup settings empty, then works, logical, then only the shows the ID’s and not the names

PDF-Report.PNG

#2

try using [SIZE=22px]’[/SIZE]{InvoiceDetails.ProductGroupID}[SIZE=22px]’[/SIZE] in your query with single quotation marks

#3

I’ve tried that before, but only at one Field, now i use ’ ’ on all fields and its running. Sorry my failure, i now that ’ '. But why they change something without notification? All in All its running, thanks

#4

Glad to read it is solved.

I always use ‘{field}’ when including fields in queries.

#5

Do the programmers of Scriptcase also know?
Anyway, it still does not work. The pdf is now generated without errors, but the result, looks …

with_Lookup.PNG

Lookup.PNG

#6

without a lookup

without-Lookup(ID).PNG

#7

maybe again the starting position…

Generating invoices always worked for years, apparently without ‘’. After an update, it suddenly stops working. In search of the mistake, it turns out then that suddenly these ‘’ are important, which they apparently were not before. Although, if an automatically generated script does not consider this, someone forgot something. If it has been forgotten here, then there is a high probability that it was forgotten elsewhere. The fact is, on the invoice now in my case, the products are no longer displayed. That means, at the very end, no matter how good my software is, you can not generate any more bills and the software is unusable and you do not have to pay the monthly fee.
So from the point of view of my customers

#8

Ok,

I have now rewritten the sql statement, so I do not need a lookup anymore. This means that I pick up the respective names directly to the products.

But I still do not think that’s just the way it’s changed!

#9

Problem is not solved, but workarounded!