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