Help with Transaction Processing using Forms 5

Hi,

I am creating my first screen in Forms 5. It is made up of 5 Data Blocks. The maser block and 3 of the detail blocks are Views. And the views are all based on the one database table that is the base table for the last detail block.

My Forms books that I got from the Forms 5 Class tell me that if I have a situation like this and want to commit changes, I need to use the ON-INSERT and ON-UPDATE triggers on the blocks that are based on views. I am testing this and I moved the test block up to the top spot on the designer list. I added an ON-UPDATE trigger. It did not seem to fire. When I hit Save on the runtime form, Forms tells me that there is nothing to save.

So I put a message in my ON-UPDATE trigger just to see if it fires at all. It does not. So I added an ON-INSERT trigger and all that has is a message. Than does not fire either.

My block that has the table as its base will update if I make changes in that block.

Any help will be appreciated.

Thanks,
Scott G. Received on Thu Jul 29 1999 - 13:29:07 CDT