Home » Developer & Programmer » Forms » Issue while querying for all records - Oracle Forms
Issue while querying for all records - Oracle Forms [message #673776] Mon, 10 December 2018 04:00 Go to next message
faizanbutt
Messages: 10
Registered: December 2018
Junior Member
Hi All,
I am facing an issue while querying for all the records. When I serach for a specific record, it is displayed in the fields and then if I want to query by pressing ctrl + F11 only that searched record is displayed. Here I want to query all the records again.

Please explain how to achieve it, Thanks !
Re: Issue while querying for all records - Oracle Forms [message #673785 is a reply to message #673776] Mon, 10 December 2018 05:34 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Presumably you've get default_where set.
You'll need to set it to null (using set_block_property).
Or better yet - don't set default_where in the first place.
Re: Issue while querying for all records - Oracle Forms [message #673806 is a reply to message #673785] Mon, 10 December 2018 09:14 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You should also check if you're setting values in a pre-query trigger.
Re: Issue while querying for all records - Oracle Forms [message #673813 is a reply to message #673806] Tue, 11 December 2018 00:29 Go to previous messageGo to next message
faizanbutt
Messages: 10
Registered: December 2018
Junior Member
Thanks for your reply
I have master and detail block.
In master I am using :
Pre-Insert
Pre-Update
On-Populate-Details
Pre-Delete
In detail I am using:
Pre-Insert
Post Query
Pre_update

Can anyone of these cause this issue ?
Re: Issue while querying for all records - Oracle Forms [message #673820 is a reply to message #673813] Tue, 11 December 2018 04:08 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
If any of them are setting the block properties onetime_where or default_where then yes. Otherwise no.
(well on-populate-details can, but only if you've messed around with it, which you shouldn't have).

If you can't find the culprit just looking in those triggers then you'll need to do some debugging.
Display the onetime_where and default_where properties of the block from pre-query.
Stick a button on the form that displays the block property last_query, press after running the query to see exactly what select the form sent to the DB.
Re: Issue while querying for all records - Oracle Forms [message #673821 is a reply to message #673820] Tue, 11 December 2018 04:14 Go to previous message
faizanbutt
Messages: 10
Registered: December 2018
Junior Member
Thnaks Alot
Previous Topic: oracle form block fetch no record when using stored procedure
Next Topic: How to call Web Service (HTTPS) from oracle Form 11g ?
Goto Forum:
  


Current Time: Thu Mar 28 15:29:30 CDT 2024