Hello, I upgraded NHibernate from 1.2 to 2.1 I got an error in one query that works well in 1.2
[NHibernate.Hql.Ast.ANTLR.QuerySyntaxException] = "M.TBLProductionOrderRegistry is not mapped [select M.FLDMaterialChange, SUM(M.FLDMaterialClearPrice) from AppFrameWork.PersistentObject.TBLProductionOrderMaterialRegistry M , M.TBLProductionOrderRegistry P where M.FLDClientCode = P.FLDCLIENTCODE and M.FLDCompanyCode = P.FLDCOMPANYCODE and M.FLDProductionOrder = P.FLDPRODUCTIONORDER and M.FLDProductionData = P.FLDPRODUCTIONDATA and M.FLDProductionType = P.FLDPRODUCTIONTYPE and P.FLDCLIENTCODE = ? and P.FLDCOMPANYCODE = ? and P.FLDPRODUCTIONTYPE = ? and P.FLDWareHouseNumber = ? and P.FLDDocumentType = ? and P.FLDReferenceNumberUC is not null and P.FLDDocumentReopened <> 'A' and P.FLDDocumentDate is not null and P.FLDDocumentDate < ? and P.FLDDailyCloseDate is null and M.FLDPerformance = '1' and M.FLDDeliveredAmount <> 0 group by M.FLDMaterialChange order by M.FLDMaterialChange ]" Can you help me thanks!!! -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
