> I have data going into the Data table, but new_data is
> not being updated. Since there is no dirty read,

Do note, that your trigger is set to fire on UPDATE, not INSERT.

> doesn't that mean a commit must be happening in order
> for data to show up?
>
> Would it be better to StartTransaction, Insert,
> EndTransaction, Commit or something along those lines
> rather than run a single command?

It wouldn't matter. If your data gets inserted, the trigger
should fire.

You can easily check if the trigger fires by raising an
exception in the trigger;

create exception exception_test 'test';

in your trigger:

begin
exception exception_test;
end;

If it fires on the right DML operation, you will get an exception.

If you know it fires, you should check your trigger logic.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com