199 questions
[SQLServer JDBC Driver][SQLServer]An expression of non-boolean type specified in a context where a condition is expected, near
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 25%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Eldo Mills
0
Reputation points
Hi,
I'm getting the following error:
[SQLServer JDBC Driver][SQLServer]An expression of non-boolean type specified in a context where a condition is expected, near 'Jul'
Here is the code:
select
'Actual' SCENARIO,
#PROGRESS_TO_HFM.P_YEAR YEAR,
#PROGRESS_TO_HFM.P_YEAR PERIOD,
'<Scenario View>' VIEWS,
C1_HFMENTITY ENTITY,
'<Entity Currency>' VALUE,
C2_ACC ACCOUNT,
'[ICP None]' ICP,
'[None]' CUSTOM1,
'[None]' CUSTOM2,
'[None]' CUSTOM3,
C3_C4 CUSTOM4,
Case when #PROGRESS_TO_HFM.P_PERIOD = 'Jul' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1 else C10_A1 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Aug' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2 else C10_A1+C6_A2 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Sep' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3 else C10_A1+C6_A2+C8_A3 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Oct' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4 else C10_A1+C6_A2+C8_A3+C14_A4 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Nov' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Dec' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Jan' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Feb' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Mar' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Apr' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 +C4_A10 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 +C4_A10 end
when #PROGRESS_TO_HFM.P_PERIOD = 'May' then
case when left(C2_ACC,1) = '1' then C11_OPENBAL+C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 +C4_A10 +C15_A11 else C10_A1+C6_A2+C8_A3+C14_A4+C5_A5+C12_A6+C7_A7+C9_A8+C13_A9 +C4_A10 +C15_A11 end
when #PROGRESS_TO_HFM.P_PERIOD = 'Jun' then
C11_OPENBAL
else 'Month Error'
end DATAVALUE
from ODIS.dbo.C$_0HFMData, ODIS.dbo.C$_1HFMData
where
(1=1)
And (C17_SOURCE=C16_ENTITY)
And (C1_HFMENTITY <> 'Ignore')
Help would be appreciated.
Eldo
SQL Server SQL Server Transact-SQL
{count} votes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2025-06-20T10:42:16.4933333+00:00 The code you posted runs without syntax error when I try it, so it seems that you made a mistake when you try extracted failing statement.
I do note, though, that there are other issues in your code. You have plenty of these #PROGRESS_TO_HFM.P_PERIOD, but no table by the name #PROGRESS_TO_HFM appears in the FROM clause.
I would suggest that you first try to build the query manually in SSMS, before you try to generate it programmatically from your Java program.
-
Eldo Mills 0 Reputation points
2025-06-24T12:44:15.83+00:00 Thanks Erland
Sign in to comment
Sign in to answer