0 pts.
 Lotus Notes R6 – Deleting Duplicate resources from Room Reservations DB
I gave a reservations database which has 2 duplicate records which I'd like to remove. Does anyone know how this can be done without deleting all of the reservations associated with the room? The duplicate records were caused by a user who was responsible for a controlled resource and therefore had Editor access. They created a local replica and subsequently replicated changes unaware that replication conflict documents would be created. These replication conficts were turned into 'real' resource enteries when they were opened with a view to their deletion andwhen closed were converted from Conflicts to 'kosher' records. I cant just 'delete' the duplicate records because the system stops me, insisting I open the documer and use the delete agent. Using the delete agent warns me that there are reservations associated with the resource and requires confirmation to delete. This is a nightmare but so far there hasn't been any problems. Anyone got any ideas? or have you a bit of script language which will allow me to delete these 'rogue' duplicates? Thanks Dave

Software/Hardware used:
ASKED: November 15, 2004  8:00 PM
UPDATED: November 16, 2004  11:48 AM

Answer Wiki:
Edit the database resources QueryDocumentDelete and rem out the section of code for the deletion of resorce documents. Delete the documents and then put the code back the way it was. I have done this a few times without any problems. madkahuna
Last Wiki Answer Submitted:  November 16, 2004  11:48 am  by  Madkahuna   0 pts.
All Answer Wiki Contributors:  Madkahuna   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _