Subject | Replicating blobs with triggers |
---|---|
Author | muk_pr |
Post date | 2006-12-05T18:48:30Z |
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.
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.