Reputation: 2337
I am trying to export forms
metadata to SQL Server
. I am having a hard time trying to figure out if a field allows multiple values, is this possible?
Upvotes: 0
Views: 199
Reputation: 384
You can't be sure. Even if the field has option "Allow multiple values" switched off anyway I can set multivalued value into the field in background. When you export you need scan all documents and find out whether a field contains multivalued values or not.
Upvotes: 0
Reputation: 22284
Most items within Lotus Notes documents can support multiple values. The fields on a form can be set to allow / disallow multiple entries but the underlying NotesItem within the NotesDocument object can usually support multiple values.
Here is some documentation on this: http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/topic/com.ibm.designer.domino.main.doc/H_VALUES_PROPERTY.html
The rich text item doesn't support multiple values, but for text, number and date types you have to assume that there may be multiple values there.
Upvotes: 4