At 11:41 PM 1/08/2004 +0200, you wrote:

>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?

No, not at all. But SQL error -104 is a very broad "parent" for dozens of
language validity errors. Can you catch the gdscode? - that's the 9-digit
error code.

Where did the database come from? Could it be an ODS 9 database? i.e.
ex-IB 5.x. You can use gstat -h to find out the ODS version.

/heLen