Member Avatar for need_Direction

Is there any one can explain to me what is the difference between when_validate_item trigger and post_change trigger? In what kind of situation I need to use those triggers? I really feel very confused about it...It makes me stuck in my database assignment...

btw, thanks for ur help... :)

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by tappusingh
Member Avatar for tappusingh

Hi,
You should use WVI at item level if you wanted to check some validation on i/p value. if value has got some trouble or any other kind of validation which is relatd to other values then you can raise exception RAISE Form_Trigger_Failure.. etc..
Generally its not a good prctice to use I think Post_change trigger is going to be Obsolete by oracle.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.