Hi all,
thank you Helen for the quick answer.

Am Montag, 2. August 2004 00:47 schrieb Helen Borrie:

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

335544569

>
> Where did the database come from?

Firebird 1.0

> Could it be an ODS 9 database?

10.1

Thank you for help.

Walter.