Image datatype and triggers (HELP!!!!)

[mooki]

Hi,
I have this table containing Image datatype and a DB trigger for Delete is set for that table.

As far as i read, the "deleted" table cannot be used.

IS There any way of copying the records that where deleted
into different table Within the trigger ????

I will appreciate any help....

 

[Cagliostro]

If so, why you do not put a deleted flag in your table?
You simply may ignore or not flagged records. John Fill
ivfmd@mail.md

 

[mooki]

I Cannot do that. Im dealing with this situation when a snapshot replication is using "delete" before inserting information.

I need to make sure (that when replication runs twice for example) that i will copy all deleted records aside.

Isn't there any other way copying "DELETED" information before it was really deleted ???

 

[Cagliostro]

At first set deleted flag, after it copy data with deleted flag in an other table. At the last step, delete flagged records. Also you may do it without faggind.
insert into xxx
select ...from yyy where condition1
delete from yyy where condition1
--go one John Fill
ivfmd@mail.md

 

[mooki]

Thanx for your respond.
The thing is that I'm using the snapshot replication and using it's "delete before insert" mechanism. I'ts deleting the records by the filter, and i can't change it.

thanx anyway.

 

[Cagliostro]

In this case is good to have a table mirror. John Fill
ivfmd@mail.md