I am using DCR to handle Data Record Syncronization between a MySQL and a Domino App. The Primary key on the RDB table is a char(32) column called configID. And the form in the domino app has a field called configID which is computed to the DOCID and tied to the RDB’s configID.
Things were working okay until I tried to copy and paste a document back into the database.
It fails because it thinks im trying to insert a duplicate entry. I want to have the new docID be used as the primary key in the insert of the RDB for the new pasted document.
The problem is that the computed field doesn’t compute to the new docid until after you refresh the document, which doesn’t happen on paste.
So I tried to have an Agent kick off on paste. But it seems that the DCR Event kicks off before the agent has a chance to recompute that field.
Any Ideas?