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?
Click Here to Expand Forum to Full Width