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?
have you actually checked what query is being sent to the database?
Its strange isnt it.
The query is coded on the When Button Pressed Event of the Search Button.
But it retrieves a fraction of the data in the result set.
It has to be the same select query.
Do you have a limit on how many records can be returned? Look for something like "parameter.maxrec=100" - maybe someone put a limit on how many records can be displayed. Since your problem recently appeared, that would be consistent with a limit being placed on what is returned. Doesn't mean that's the reason why, but is a good candidate for why it's happening now.
Baffling. No its not any parm.
Actually we have records being created in our production and every record after a certain date appears.
The records prior to that date just do not show up in the result set....
also check the following thing in forms end .
in records or blocks check the maximum number of records . and there is where clause in forms just check if it has any date set .
may this property may be overwritting what u write in when button pressed trigger .
There is neither a join nor a condition in the SELECT.
Just a where 1=1;
There is no date clause here.
u can test this thing .
to check where the problem is lying ( database or frontend )
just create a new form with wizard . without changing any property . and without setting 1=1 in where clause .
then chech if it is fetching all records or not . if it is not retrieving all records and if it is fetching only after a certain date then we need to look un database end
else database end is fien check in teh forms end by copying these properties in ur actual form .