I have the following problem with rising input creation. If I try to add the following query as a rising input, I receive an error:
SELECT *FROM DIARYWHERE DIARY_DATE > ?AND TABLE_ID = 3ORDER BY DIARY_DATE ASC
But the following query works:
SELECT *FROM DIARYWHERE DIARY_DATE > ?ORDER BY DIARY_DATE ASC
"Step 4" fails when I click "next" on the "New input" screen, however the query runs fine.
According to the documentationit is permitted to use complex WHERE clauses:
"Use other advanced SQL features in the WHERE clause—for example a CASE statement."
Do you have any idea what went wrong here?
It turned out that it was a bug in DB connect (DBX-5327) that was fixed in 3.4.2
View solution in original post
Under the heading of "dumb things to try that just might work" try swapping the order of the where clause.
WHERE TABLE_ID = 3
AND DIARY_DATE > ?
ORDER BY DIARY_DATE ASC
Thanks for the suggestion. I tried to exchange the conditions but it did not help. The result was the same.