Yes, good idea. Oracle have this option. And this is I try to say when I
wrote about after commit trigger.

Dufloth.


Martijn Tonies wrote:

> Perhaps this would be a nice candidate for DEFERRED constraint
> checking :)
>
> > >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.
> >
> > Or you could have an additional field which indicates the state of the
> > journal, either "working" or "complete". A trigger can watch for the
> > transition of this state from "working" to "complete" and when it is
> marked
> > complete, that is when the integrity checks are applied. Only at that
> point
> > do the debits and credits have to balance.
> >
> > You could also have a view of those tables which only returns "complete"
> > journals so that parts of your application do not have to see the
> working
> > journals at all.
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
> See you at the First European Firebird Conference in May in Fulda, Germany
> http://www.firebird-conference.com
>
>
> *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/1051530991+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]