This is the case to have an before commit trigger, don't?

Dufloth.


Jason Chapman (JAC2) wrote:

> Helen,
>
> I can't really see how you can do this for N-way accounting transactions.
> e.g. a banking sheet may have 200 credits and 1 balancing debit on it.
>
> Personally I have in the past used temporary posting tables with an SP to
> post into the main table, the SP can then validate prior to posting in the
> actual nominal ledger. There is only 1 temporary table, it can hold many
> TX's and you tell it which TX you want to post into the ledger. It checks
> and posts or barf's.
>
> HIH
>
> JAC.
>
>
> "Helen Borrie" >
> > Use triggers to enforce the rules.
> > The trick is to not to post *anything* until you have performed the
> > validations - by doing the whole operation in one stored procedure.
> This
> > way, everything is done on the server and the *rules* that control the
> > order in which the updates/inserts occur are server based and driven by
> the
> > context of the SP.
> >
> > Make use of After Insert and After Update triggers to enforce your
> rules -
> > which is possible if things are done in the correct order.
> >
> > Use the powerful custom exception-handling capabilities to deal with
> > exceptions which you want your procedure to "eat", rather than throwing
> > back to the client; or with validation errors that the SP detects in the
> > input, that you WANT to throw back at the client rather than proceed.
> >
> > heLen
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> *Yahoo! Groups Sponsor*
> <http://rd.yahoo.com/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705115386:HM/A=1556779/R=0/*http://shop.store.yahoo.com/cgi-bin/clink?ftd2+shopping:dmad/M=229633.3212141.4526654.2595810/D=egroupweb/S=1705115386:HM/A=1556779/R=1/1051522252+http://us.rmi.yahoo.com/rmi/http://www.ftd.com/rmi-framed-url/http://www.ftd.com/yahoo36>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*ICQ#: 128291190*
*Current ICQ status:*

*(* *Work Tel#:* 54 522-3313
*+* *More ways to contact me * <http://wwp.icq.com/128291190>
*__________________________________________________________________*


[Non-text portions of this message have been removed]