Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Facing issues with Post-Query Trigger

Bhushan53Jul 14 2013 — edited Jul 15 2013

Hi,

i am using Forms [32 Bit] Version 10.1.2.0.2 (Production).

Here, I have a data block based on a table. I am displaying 10 records on the form. Please see the stpes I am taking -

1. Execute Query. (Returns me 17 Records)

2. Setting value of one field in POst-Query Trigger.

3. Save it.

When I requery, the previously set value was saved only for 10 records which were visible. Remaining 7 records don't get updated. Now, I reset the value from backend and again repeated my steps as -

1. Execute Query. (Returns me 17 Records)

2. Setting value of one field in POst-Query Trigger.

3. Scrolling through records till Last_record manually.

4. Save it

This time, I on re-querying I am able to see the updated value for all 17 records. Please help me in attaing this result without scrolling through the records.

Regards

Bhushan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2013
Added on Jul 14 2013
7 comments
1,251 views