Formatting that to actually be readable might be a good idea. /Oskar
2009/11/9 mikeusdev <[email protected]>: > > > Hi, > > I am getting an error message when I try to execute the following > query: > > IList query = session.CreateQuery(@"select account.Number, > account.Description, sum(case when (entry.IsDebit = 1m) then case when > (entry.YearId < 6 and accountType.ResetBalanceYearly = 1) then 0m when > (entry.YearId < 6 and accountType.ResetBalanceYearly = 0) then > entry.Amount when (entry.YearId = 6) then entry.Amount end else case > when (entry.YearId < 6 and accountType.ResetBalanceYearly = 1) then 0m > when (entry.YearId < 6 and accountType.ResetBalanceYearly = 0) then > entry.Amount * -1 when (entry.YearId = 6) then entry.Amount * -1 end > end) as entry.Amount from LedgerEntry entry inner join entry.AccountId > account inner join account.AccountTypeId accountType group by > account.Number, account.Description order by account.Number") > .List(); > > > The error message is the following: > > '(' expected after HQL function in SELECT [select account.Number, > account.Description, sum(case when (entry.IsDebit = 1m) then case when > (entry.YearId < 6 and accountType.ResetBalanceYearly = 1) then 0m when > (entry.YearId < 6 and accountType.ResetBalanceYearly = 0) then > entry.Amount when (entry.YearId = 6) then entry.Amount end else case > when (entry.YearId < 6 and accountType.ResetBalanceYearly = 1) then 0m > when (entry.YearId < 6 and accountType.ResetBalanceYearly = 0) then > entry.Amount * -1 when (entry.YearId = 6) then entry.Amount * -1 end > end) as entry.Amount from Oberon.Model.BusinessModel.LedgerEntry entry > inner join entry.AccountId account inner join account.AccountTypeId > accountType group by account.Number, account.Description order by > account.Number] > > > Does anyone know what the problem is? I tried various combinations > (column aliases, for example), but I cannot see where the problem > lies. > > Thanks. > Mike > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
