Re: Delete conflict resolution

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 07 Jan 1999 15:57:34 +0800
Message-ID: <369468EE.5970@bhp.com.au>

speng_at_ncs.com.sg wrote:
>
> Does anyone knows how a write a user defined routine for delete conflict?
>
> I have a delete conflict problem here.
>
> My_tables
> ==========
> NRIC NOT NULL VARCHAR2(9)
> NAME NOT NULL VARCHAR2(30)
> SEX NOT NULL VARCHAR2(1)
> RACE NOT NULL VARCHAR2(1)
> LAST_UPDATE NOT NULL DATE
>
> If i have delete a row at local site and an update is done at the remote site.
> My problem here is it does not delete the record at the remote site due to the
> columns are update at the remote and the data is not found.
>
> Anyone has a sample user defined routine pls.
>
> Help!
>
> --
> Sok Peng
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

I've always found delete conflict resolution a nightmare (if not impossible)..

Rather than delete, why not have your app just update the row to a "delete" flag or have a "date_when_deleted" column. Then all you need update conflict routines which are easier to code (and also Oracle supply some samples)...

HTH --

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Thu Jan 07 1999 - 01:57:34 CST