expression evaluation error in SQL select with case-statemnt
Posted: Mon 18 Jan 2010 09:49
Hi.
I'm getting a "Dynamic SQL Error expression evaluation not supported." when running the following SQL statement.
While this was running fine using the old BDE I can only run a workaround changing the statement to:
... and then increment the result by code.
Any idea on this issue?
Michael
Using IBDAC 3.1, FB2.1
I'm getting a "Dynamic SQL Error expression evaluation not supported." when running the following SQL statement.
Code: Select all
select case when max(nummer) is null then 10000 else max(nummer)+1 end from kundenCode: Select all
select case when max(nummer) is null then 9999 else max(nummer) end from kundenAny idea on this issue?
Michael
Using IBDAC 3.1, FB2.1