Hi Federico - I am not an HQL wizard myself, but I'll give it a shot anyway.
I think the problem is the line: from AppFrameWork.PersistentObject.TBLProductionOrderMaterialRegistry M , M.TBLProductionOrderRegistry P where However, since you did not provide any information about the mapping its a little difficult. ;-) A few suggestions: 1) Check your mappings and make sure spelling, and character casing in query, mapping and properties are identical. Your query is using a combination of upper-case and camel-case, but are your properties really in upper-case? If not, change the query so that the casing is exactly matching the casing of the properties. 2) Try to explicitly specify the join between M and M.TBLProductionOrderRegistry. 3) Browse the release notes from the NHibernate release 2.0 and 2.1 and see whether or not there is a note about changes to the HQL syntax. Hope this helps. Thomas On 15 Feb., 08:51, Federico <[email protected]> wrote: > 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.
