Kurt,

> Thanks for the explanation, Helen.
>
> Is there a way to auto-commit the trigger?
>
> The insert (into data) is coming through an ODBC
> connection and appears to auto-commit (or I'm getting
> a really good dirty read across several hundred rows).

If the INSERT commits, the trigger commits.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com