SetNamedVariable method (NotesDominoQuery - LotusScript)

Assigns a value to a named substitution variable in a DQL query.

Defined in

NotesDominoQuery

Syntax

NotesDominoQuery.Setnamedvariable( variablename$, value )

Parameters

VariableName$

String. The name of a substitution variable specified in a DQL query, after the question mark. So "date_of_birth? is seen as ?date_of_birth in DQL syntax.

Value

Variant. Can be String, number or DateTime object.

Return value

None

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$)

For more information on substitution variables, see the section Domino Query Language.

Language cross-reference

setNamedVariable method (DominoQuery - Java)