OraFAQ Forum: Forms » Issue while querying for all records

Home » Developer & Programmer » Forms » Issue while querying for all records - Oracle Forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue while querying for all records - Oracle Forms [message #673776]

Mon, 10 December 2018 04:00

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 !

Report message to a moderator

Re: Issue while querying for all records - Oracle Forms [message #673785 is a reply to message #673776]

Mon, 10 December 2018 05:34

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Issue while querying for all records - Oracle Forms [message #673806 is a reply to message #673785]

Mon, 10 December 2018 09:14

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You should also check if you're setting values in a pre-query trigger.

Report message to a moderator

Re: Issue while querying for all records - Oracle Forms [message #673813 is a reply to message #673806]

Tue, 11 December 2018 00:29

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 ?

Report message to a moderator

Re: Issue while querying for all records - Oracle Forms [message #673820 is a reply to message #673813]

Tue, 11 December 2018 04:08

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Issue while querying for all records - Oracle Forms [message #673821 is a reply to message #673820]

Tue, 11 December 2018 04:14

faizanbutt
Messages: 10
Registered: December 2018

Junior Member

Thnaks Alot

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 12:54:37 CST 2025