Subject | RE: [IBO] Replicating blobs with triggers |
---|---|
Author | Alan McDonald |
Post date | 2006-12-05T20:57:03Z |
> Hi all,try doing it AFTER INSERT
>
> 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.
Alan