When a query does not understand the name of the table, this happens about 10% of the time, then the tablename must be manually added via the TableMappings property. This has always worked fine in the past BUT now When I click on TableMappings an error message pops up which says Net packets out of order: received[51],expected[1]. Although your website said this bug is fixed, it is not.
I am finishing a project and it requires a fix for this bug for me to continue.
Here is the query that requires a manual entry into TableMappings
Code: Select all
SELECT
diagnosis.RecordNr,
diagnosis.VisitDate,
diagnosis.confirmed,
diagnosis.ndcCode,
sum(diagnosis.Qty) as Qty,
diagnosis.cost,
pharmacyinventory.stockItem,
pharmacyinventory.inventoryAmount,
pharmacyinventory.reorderLevel,
pharmacyinventory.`timeStamp`,
pharmacyinventory.ExpireFlag,
pharmacyinventory.Unit,
pharmacyinventory.TradeName,
pharmacyinventory.GenericName,
pharmacyinventory.Strength,
pharmacyinventory.DoseForm,
pharmacyinventory.Route,
pharmacyinventory.Category,
pharmacyinventory.MasterCategory,
pharmacyinventory.currentInventory,
DATE_FORMAT(diagnosis.VisitDate,'%Y%m%d')as visitDateYMD,
DATE_FORMAT(diagnosis.VisitDate,'%Y%m')as YearMonth FROM
lomadeluz.diagnosis INNER JOIN
pharmacy.pharmacyinventory ON
lomadeluz.diagnosis.ndcCode = pharmacy.pharmacyinventory.ndcCode
WHERE (diagnosis.confirmed = 'Y' AND diagnosis.ndcCode != '0' AND DATE_FORMAT(visitDate,'%Y%m%d') >= :parmStartDate AND DATE_FORMAT(visitDate,'%Y%m%d') <= :parmEndDate)
group by YearMonth,ndcCode
order by YearMonth