OraFAQ Forum: Forms » Which is the trigger to commit after WHEN-VALIDATE-ITEM

Home » Developer & Programmer » Forms » Which is the trigger to commit after WHEN-VALIDATE-ITEM

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

Which is the trigger to commit after WHEN-VALIDATE-ITEM [message #87827]

Tue, 15 February 2005 07:51

Swathi
Messages: 5
Registered: March 2001

Junior Member

Version : Oracle Forms 6i

Hi all,
I have a similar but a bit more complicated problem
actually what i am to do is matrix type form

I have a table_1's columns on x-axis and table_2's columns on y-axis both as multi-record blocks and i have created a grid type non-database block.

I have written some procedures to handle the population of data

It works fine(queries,updates,inserts) as long as I am not trying to assing the value of the non-db block into one of the column of table_2's column in the when-validate-item of the non-database block's block-level trigger which has multiple records oriented towards x-axis.

Since I am handling this when-validate-time the form throws up "DO U WISH TO COMMIT THE CHANGES YOU HAVE MADE" as the block and form status are changing, what would be the next possible trigger where i can issue commit preferably before when-validate-record or wise post-block

Thanks in advance
Swathi .P

Report message to a moderator

Previous Topic:	How to commit NON-DATABASE Blocks in forms
Next Topic:	How to highlight currently active row

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:36:04 CDT 2024