|
Written by Bruno Grange
|
|
Wednesday, 03 September 2008 02:02 |
|
It's common to receive this error message when performing an @DBLookup: "The specified database look-up generated more than 65,000 bytes of results, which is too large for Lotus Notes to handle in this context."
To overcome this, we can make use of "prompt method" -- with a multi-value selection option.
- Create one button.
- Create two fields -- category and doc_Readers, with the "computed" and "allow multiple values" options selected.
- Under category field, select/enter the keyword option -- keyword document will be available.
- When clicking the button in the second field, values will be populated based on the option selected in the first field.
Here is the code:
Sub Click(Source As Button) Dim doc As notesdocument Dim db As NotesDatabase Dim temp As String Dim newdoc As notesdocument Dim newview As notesview
Set session = New NotesSession Set db = session.CurrentDatabase Set ws = New NotesUIWorkspace Set uidoc = ws.CurrentDocument temp=uidoc.fieldgettext("Category") Set doc = uidoc.document Set newview = db.getview("Enter View Name") Set newdoc = newview.getdocumentbykey(temp, True)
If uidoc.IsNewDoc Then returnvalue = ws.Prompt(PROMPT_OKCANCELLISTMULT, "Search Customer Codes", "Please select", "" , newdoc.Doc_Readers) doc.Doc_Readers = returnvalue Else returnvalue = ws.Prompt(PROMPT_OKCANCELLISTMULT, "Search Customer Codes", "Please select", "" , newdoc.Doc_Readers) Set item = doc.getfirstitem("Doc_Readers") Call item.appendtotextlist(returnvalue) Call uidoc.Refresh End If End Sub
Related Articles: |