Hi all,
in a SP I have some Timestamp variables. In the statement:
IF ((TDAT IS NOT NULL) AND ((TMELDD IS NULL) OR (TMELDD < TAENDDAT))) THEN
the SP raise an exception (SQL error -104).
TDAT = date
TMELDD = timestamp
TAENDDAT = timestamp
Firebird 1.5 SS (tried in linux and windows)
Why does this line not work?
In another line I have similar error:
IF (TMELDD IS NULL) THEN
TMELDD has in this situation a value.
Does timestamp have troubles with the state null?
Thanks for help.
Walter.