I have a field on the form. I have also submit button on the form which save the value of the field in the view as well as call agent(Agent insert data to external database-Oracle).
Q1. How can I insert the document as a new version if I make changes to the previous document. ie. If I make changes in the document then it should be saved in the notes view as a seperate new document. Previous one should also remain in the view?
Q2. As first I am saving document in notes database and also inserting the same into oracle and if while inserting into oracle problem comes and it does not insert. But that document is already saved in the notesdatabase. What check should I put so that document should be inserted in both notesdatabase and oracle, if one fails then it can not save to the other one.
I am fetching a document in a particular view on the basis of one field. But the problem is I could not able to fetch the current document saved. It is because of view is not refreshing. Please suggest me what to do?
Just try to use notesview’s refresh method to update the view before inserting into external dbs.Moreover it is failing to insert into oracle might be because of constraints like unique/primary key.Try to use getextendederrormessage property of resultset to troubleshoot.
When you click on the submit button on the form, it will trigger the WebQuerySave event. Write a lotus script agent and use the Create Document method to create a new notes document. Assign the value of the field values on the UI to the new document to be created. Do not save the currently opened document but rather create a new document in the WebQuerySave agent and save it.