Error in FORMS4.5 using Sysdate

[Quoted] [Quoted] I placed the following SQL Statement in a forms 4.5 module :

SELECT nr FROM My_table WHERE My_date > SYSDATE;

My_date is of Type DATE.

The table My_table has 4 rows, with one row matching the where clause. In FORMS the NO_DATA_FOUND exception is raised, the matching row is not returned by the statement. Using exactly the same statement in SQL plus (logically) returns the matching row.

I've tried several other queries with Date-functionality and always get wrong results.
Can anyone solve this problem ???
Thanks Received on Sun Feb 16 1997 - 00:00:00 CET