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?
09-27-2002, 01:24 PM
have you actually checked what query is being sent to the database?
09-27-2002, 02:30 PM
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.
09-27-2002, 02:35 PM
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.
09-27-2002, 02:45 PM
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....
09-27-2002, 02:47 PM
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 .
09-27-2002, 02:50 PM
There is neither a join nor a condition in the SELECT.
Just a where 1=1;
There is no date clause here.
09-27-2002, 03:21 PM
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 .