asked on

Document Save Conflict

I have a main form with a Save and Close button and a Create Details button. The Details form inherits docid in the main form. The user, after filling up the main form, clicks the Create Details button. (see below the code i placed in the buttons). The Details form will open, and the user will fill it up, during saving of the details form, it will change some of the fields in the main form so the user has to click the save and click button on the main form after saving the details form. Another thing, i also added a code in the post save of the details form. When the user clicks the Save and Close button in the main form the following message appears "Another copy of this document was saved while you were editing it. Save your changes also as a save conflict document?"

This is kindda urgent guys. Hoping for your prompt reply. Thanks in advance! :)

Codes:

Save and Close button in Main Form:
@Command([EditDocument];"1") ;
@Command([ViewRefreshFields]) ;
@Command([FileSave]);
@Command([FileCloseWindow])

Create Detail Button in Main Form:
@Command([FileSave]);
@Command([Compose];"details")

Save and Close button in Details Form:
@SetDocField(maindocid;"lastupdate";cpdate);
tempo :=@GetDocField(maindocid; "ctimeo");
@If (tempo= "";@SetDocField(maindocid;"ctimeo";timeo);"");
@If(@Trim(status) = "CLOSED"; @SetDocField(maindocid;"closedtime";cpdate);"");
@Command([FileSave]);
@Command( [FileCloseWindow] )

Post Save event in Details Form:
Sub Postsave(Source As Notesuidocument)
      Dim w As New NotesUiWorkspace
      Dim s As New NotesSession
      Dim dbCurrent As NotesDatabase
      Dim viewDailyColl As NotesView
      Dim entryDailyColl As NotesViewEntry
      Dim vc As NotesViewEntryCollection
      Dim docDailyColl As NotesDocument
      Dim docTMP As NotesuiDocument
      Dim m As String

      Set dbCurrent = s.CurrentDatabase
      Set docTMP = w.currentdocument

      m = docTMP.FieldGetText( "maindocid" )

      Set viewDailyColl = dbCurrent.getView("Status")
      Set vc = viewDailyColl.GetAllEntriesByKey(m)
      If vc.count = 0 Then
            Messagebox("Please create at least 1 detail of the case")
            Exit Sub
      End If

      For i = 1 To vc.count

            Set entryDailyColl = vc.GetNthEntry(i)
            Set docDailyColl = entryDailyColl.Document
            docDailyColl.dstat = docTMP.FieldGetText( "status" )
            Call docDailyColl.Save(True,False)

      Next
End Sub

Sjef Bosman

I assume you keep the main form open in edit-mode while details are filled in. I'd suggest to make the Details button visible only in read-mode, thus preventing multiple simultaneous updates on the main form. You can also put the document in read-mode when pressing the Details button. If you want to modify values on the main-form from the details-form, you can do that safely, but the info on the main-form on screen will not be changed until a reload.

CRAK

Exactly!
Is there a way to make "dstat" computed for diaplay and let it show the value of "status" dynamically (using e.g. @DbLookup)?
(note that if a document already contains a field dstat, the computed for display result won't show; the available field will show instead!)

HemanthaKumar

Instead of executing the script in PostSave, execute it in QuerySave.. This should prevent the conflicts.

~Hemanth

qwaletee

Right now, you have the CREATE DETAILS button save the main document and create a detail doc.

Instead, have it save AND CLOSE the main document, so that it is not open at all. Some others have suggested that yuo put teh main document in read mode. That will sometimes be good enough. But if the user siwtches the main docuemnt back to edit mdoe from read mode, the same conflict action will occur, because the "old state" of teh document is cahced even in red mode, and will not be refreshed when swicthin back to edit, Because of that, the open window has the old doc information (before the details form modified it), and upon save, it will notice the conflict problem.

How to make this work? Put the following code in CREATE DETAILS:
@PostedCommand([FileSave]);
@PostedCommand([Compose]; "details")
@PostedCommand([FileOpenDatabase]; @DbName; ""; "1");
@PostedCommand([OpenDocument]; "0"; @Text(@DocumentUniqueID));
@PostedCOmmand([FileCloseWIndow]);
@PostedCOmmand([FileCloseWIndow]);

macjacinto

ASKER

sjef_bosman:

If i make the Details button visible in read-mode only, the user has to click the save and close first, then open the document again just to create a detail form? And also, how can put the main document in read mode when pressing the Details button?

crak:

Its possible to make dstat a computed for display field and get its value through dblookup..however, the main function of the post save code is to change all values of dstat in all details doc of one main document, you see, its possible that in one main doc, multiple details doc were created, and i used the docid of the main doc to keep tab of all the details of the said main doc. How will i then incorporate this function if i get the value through dblookup?

hemanth:

The message from the script appeared " Please create at least 1 detail of the case". I think this is because the document hasn't been saved yet bec as the definition of Query save in help - it "Occurs just before the current document is saved"

qwaletee:

The message "Server error: Entry not found in index" appeared

I'll provide additional points to whoever solves this problem today. Thanks!!