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,expected. 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