Skip to Content
0
Former Member
Dec 24, 2010 at 05:21 AM

Parse failed: Exception: DBD, [Microsoft][ODBC SQL Server Driver] Syntax Er

211 Views

I received the following error when I gave the following statement in select:

case when {fn_year(FINANCE_PERIOD.FP_START)} @prompt('Enter Year','N',,mono,free)

then 1 else 0

end

Parse failed: Exception: DBD, [Microsoft][ODBC SQL Server Driver] Syntax Error or access violationState: 42000

I looked at differnt forums but could not fnd the error.