From: Alexander Hovig (a_hovig_at_uclink.berkeley.edu)
Date: Thu Jun 26 2003 - 11:59:13 PDT
Greetings:
I was recently tasked with developing a web application that had the
requirement of inserting and/or updating data in a Lotus Domino form
(database).
My application had many other requirements, and the best IDE for the job
was Visual Basic. Some research also proved that an ODBC interface
provided by IBM, NotesSQL 3.02, would be the best (if not only) solution
for getting the data into the Domino database. It should be noted that
my application and the Domino system are not part of the same network.
It should also be noted that it is not within the scope of this project
to install and/or support any Lotus or Domino server-side components on
our end. The solution I used only required the installation of a Lotus
client and the aforementioned API.
To cut to the chase, the end results proved highly successful; I was
able to post and update data to a Lotus Domino form (database) on the
remote system; however, there was one type of form field in the Domino
side that proved problematic. These forms often have a drop-down widget,
which contains a set of selectable list entries that are either
hard-coded or derived.
These drop-down list widgets have a property that, when set, prevents
new list items from being added. When my application attempts to insert
an entry into this field (column) - remember I am not going through the
form but via the API - the NotesSQL driver throws an API error: value
does not exist in keyword list for field. Even if the value I am trying
to insert is an exact match to one of the existing entries in the list,
the error will still be thrown. In fact, if I extract one of the list
items from the form (database) via the API and then try to insert that
exact string, the error will still be thrown.
The only workaround I have found is to disable the property on the form
itself; then, even though a new item is not being added to the drop-down
list, the insert to the form (database) is successful. I have found no
pertinent information regarding this problem on any of IBM's support
sites, nor have I found anything via an internet search. It is apparent
that the given field property is exercising some sort of restraint on
the underlying column, and it seems the API does not deal with this
properly.
In anyone has specific experience with this API or has solved a similar
problem, I would appreciate your feedback.
Kind regards,
Alex
Alexander Hovig
Programmer Analyst III
PPCS Information Systems Group
University of California at Berkeley
Email: <mailto:a_hovig_at_uclink.berkeley.edu> a_hovig_at_uclink.berkeley.edu
Email: 5108407358_at_alphapage.airtouch.com
Voice: 510.643.5201
Pager: 510.840.7358
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
This archive was generated by hypermail 2.1.5 : Thu Jun 26 2003 - 12:03:58 PDT