Re: forms6i triggers need help

[Quoted] "darius123" <darius123_at_rogers.com> wrote in message news:mix1b.269262$rsJ.205025_at_news04.bloor.is.net.cable.rogers.com...
> A- In a form Builder you attempt to compile a trigger. You receive a
> compilation error that gives no clear indication of the problem. What are
> two likely causes? Choose two
>
>
>
> 1.. Dividing by zero
> 2.. Missing semicolon
> 3.. Mismatched quotes
> 4.. Mistyped variable name
> 5.. Trigger defined on wrong item
> 6.. Trigger defined at wrong item
> My answer is : 3 and 6. that is different from mock exam that is : 3 and
5
>

[Quoted] You define a trigger *on* an item, defining it *at* an item doesn't occur.
>
>
> B- When a user updates the Salary item, you want to ensure that next value
> is higher than the existing value before it is inherited into the base
> table. Which trigger would you use?
>
>
>
> 1.. Pre-Commit
> 2.. On-Commit
> 3.. Post-Update
> 4.. Pre-Update
> 5.. Post-Form-Commit
> My answer is 1. Mock exam is 4.
>
>

B The Mock exam is correct. Validation should occur before update. Validation at pre-commit implies you have already updated the record, and need to roll your changes back, so you are wasting resources.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address