OLD and NEW are no use, I want to see other records not the one the
trigger is currently dealing with!

--- In firebird-support@yahoogroups.com, Tim Ledgerwood <tim@s...>
wrote:

> At 15:41 04/06/2004, you wrote:
>
> >Is it possible to dirty-read uncommitted data in Firebird?? (I

don't

> >think it is, but someone might prove me wrong!)
> >
> >Why do I want to do this mad thing??? Well, it's sometimes useful

in

> >triggers etc, and it might help work around some inconsistencies
> >caused by the way unique indexes work - ie they can 'see' other
> >clashing uncommitted values, even though thouse changes arn't

visible

> >any other way.
> >
> >Thanks,
> >
> >John
>
>
> Why don't you use the NEW and OLD variables?
>
> Regards
>
> Tim
>
>
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.245 / Virus Database: 263.0.0 - Release Date:

02/06/2004