I am able to view the notes data from an asp .net application via an ODBC connection to the Lotus database. I want to be able to update this data. The views that I see do not have any unique identifiers (indexes) so I’m not sure how to go about adding an update/insert command. I have tried various sql statements. Please advise. Thx.
Subject: NotesSQL write data to Lotus
The tech note referenced by Ken correctly points out one of the many limitations of the free NotesSQL data driver. If your project merits a commercial enterprise-class data driver, Proposion N2N supports many ways to UPDATE a document including:
-
UPDATE by direct key lookup into sorted view/folder column
-
UPDATE by NOTEID
-
UPDATE by UNID
-
UPDATE by Full Text Search expression
-
UPDATE parents or response docs of a named document
-
UPDATE by dynamic Selection @Formula
Of course there are many other features as well. See http://www.proposion.com for details.
Subject: NotesSQL write data to Lotus
Check this out:
http://www-1.ibm.com/support/docview.wss?rs=899&uid=swg21101327