Subject RE: [IBO] Replicating blobs with triggers
Author Alan McDonald
> Hi all,
>
> here is my replication sql:
>
> -- "Data" is a custom blob field, declared as "Data BLOB SUB_TYPE -5"
>
> CREATE TRIGGER "trig" FOR "table" ACTIVE BEFORE INSERT POSITION 0 AS
> BEGIN
> INSERT INTO "shadowtable"
> ("Name","Data")
> VALUES
> ('NEW."Name",New."Data");
> END;'
>
> My problem is that the data inserted in the shadow table remains NULL.
> What am I missing?
>
> Thanks.

try doing it AFTER INSERT
Alan