Hi Gurus,

Have a very strange problem here.

We have a Forms 4.5 tool reading from an Oracle 8i database.
This problem concerns one table.

The tool has a query which simply fetches all the records in the table and shows them one by one for a search button.

Till recently, every record in the table was fetched by the query. There are no joins to any other table at all in the query and we have a dummy where clause... where 1 = 1;

But off late, only the records created after a certain date, about a week ago are being fetched into the tool.

A simple SQL query retrieves all the records in the table, but this is not happening in the tool with the same query.

I know this is very vague but has anyone faced such a problem before?

Do you have anything at all to say about this?