Neven wrote: > > - BEFORE triggers > > In all triggers the state before and after is available hence the > concept of before and after triggers are irrelevant
True, but if you want to reject the operation (usually to enforce a business rule), it's much more efficient (less CPU and memory load) to abort in the before stage than in the after stage when the database engine has gone to all the trouble to do the actual update/insert work when you're going to NAK it anyway. TTFN, Paul. _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
