Hi ,
I have a pdf report that starts with a search and among the selectable fields I have the Invoice ID.
The filter as default is set to “Equal to” and then the list of invoices on the right.
I select some invoices and then click on search.
Strangely it doesn’t print any invoices … no records found etc with blank page.
If I took the query that comes up in Debug Mode it puts me this kind of where at the end …
and (Upper (invoices.InvoiceNumber) in (Upper (‘416’), Upper (‘415’), Upper (‘414’))) order by invoices.InvoiceID DESC
For the more technical of me it is correct ??? If I remove this it selects everything correctly.
The selected invoice IDs are 416, 415, 414
Seems a bit strange to me as sintax
If I cut that last part of query everything work on db
Thank you
PS All query from debug
Query completa:
SELECT invoices.InvoiceID as invoices_invoiceid, invoices.OfficeID as invoices_officeid, invoices.CustomerID as invoices_customerid, customers.CompanyName as customers_companyname, customers.Address as customers_address, customers.PostalCode as customers_postalcode, customers.City as customers_city, customers.State as customers_state, customers.Country as customers_country, customers.VatCode as customers_vatcode, customers.FiscalCode as customers_fiscalcode, invoices.EmployeeID as invoices_employeeid, invoices.InvoiceDate as invoices_invoicedate, invoices.InvoiceNumber as invoices_invoicenumber, invoices.currencyID as invoices_currencyid, invoices.RequiredDate as invoices_requireddate, invoices.OrderRef as invoices_orderref, invoices.RefGoodsDoc as invoices_refgoodsdoc, invoices.PaymentTermsID as invoices_paymenttermsid, invoices.BankDetails as invoices_bankdetails, invoices.service_typeID as invoices_service_typeid, invoices.ShippedDate as invoices_shippeddate, invoices.ShipVia as invoices_shipvia, invoices.CourierName as invoices_couriername, invoices.Freight as invoices_freight, invoices.ShipName as invoices_shipname, invoices.ShipAddress as invoices_shipaddress, invoices.ShipCity as invoices_shipcity, invoices.ShipRegion as invoices_shipregion, invoices.ShipPostalCode as invoices_shippostalcode, invoices.ShipCountry as invoices_shipcountry, offices.bankcode04 as offices_bankcode04, customers.Phone as customers_phone, customers.Fax as customers_fax, customers.Email as customers_email from invoices, customers, offices where invoices.CustomerID = customers.CustomerID and invoices.OfficeID = offices.officeID and ( Upper(invoices.InvoiceNumber) in (Upper(‘416’),Upper(‘415’),Upper(‘414’)) ) order by invoices.InvoiceID DESC