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
|
|
|