ResetNamedVariables method (NotesDominoQuery - LotusScript)
Removes all previously set named variables and values from a DominoQuery instance.
Defined in
Syntax
NotesDominoQuery.Resetnamedvariables( )
Parameters
None
Return value
None
Usage
Removes all previously set named variables and values from a DominoQuery instance. If SetNamedVariable returns an error indicating that there is already a bound value for a specified name, call ResetNamedVariables to clear the variable state.
Overwriting existing bound variable values is not supported; you must call ResetNamedVariables to clear the variable state prior to setting variables by the same name.
Example
Dim Query$ as String
Dim lastname$ as String
Dim NotesDatabase db
Dim TheQuery As NotesDominoQuery
Dim doccol As NotesDocumentCollection
Set db = Session.Getdatabase("my.nsf")
Set TheQuery = db.Createdominoquery()
TheQuery.Setnamedvariable("lastname", "Stevens")
Set Query$ = "firstname" != 'Annabelle' and lastname = "lastname"
Set doccol = TheQuery.Execute(Query$)
…
TheQuery.Resetnamedvariables()
TheQuery.Setnamedvariable("salary", 55000)
TheQuery.Setnamedvariable("department", "Sales")
Set Query$ = "salary >= "salary and department = "department"
Set doccol = TheQuery.Execute(Query$)