How to use db.Search function?

[jumpjack]

Where do I find the complete syntax of the first parameter of NotesDatabase.Search function?
In other words, how can I get db.Search function to retrieve all documents containing a selected value into one field?

[...]
Parameters
formula$
String. A Notes @function formula that defines the selection crite

-- Jumpjack --

 

[jumpjack]

note:
I mean, from within a VBA application in MS access.


-- Jumpjack --

 

[jumpjack]

Ok, got the solution:

[...]
    Set session = CreateObject("Notes.Notessession") ' Connect to Lotus
    Set db = session.GETDATABASE(SERVER, DBNAME) ' Open DB
    If db.ISOPEN = False Then
      MsgBox ("Impossibile aprire db '" & DBNAME & "'")
    End If
        
    Set dateTime = session.CREATEDATETIME(DateString) ' Convert date to Notes format
    Set view = db.GETVIEW(VIEWNAME) ' Select view
    
    ' Perform the search of value FieldContents in field FieldName, for documents modified after DateTime
    Set GlobalCollection = db.SEARCH("@Contains(" & FieldName & ";" & FieldContents & ")", dateTime, 0)
    c = GlobalCollection.count ' Number of results
    Set Doc = GlobalCollection.GETFIRSTDOCUMENT
    While Not (Doc Is Nothing)
      Debug.Print Doc.GETITEMVALUE(FieldName2)(0)
      Set Doc = GlobalCollection.GETNEXTDOCUMENT(Doc)
    Wend
    MsgBox "Documents found: " & c

This code works from within a MS Access 97 database.

Here you find all keywords you can use as first parameter of .SEARCH function:

http://doc.notes.net/uafiles.nsf/docs/DESIGNER70/$File/prog1.pdf

(Lotus designer - vol. 1)

http://doc.notes.net/uafiles.nsf/docs/Designer6PR2/$File/designprogramv2a.pdf

(Lotus designer - vol. 2)

-- Jumpjack --

 

[jumpjack]

It's also possible to use standard operators within db.SEARCH :

http://www.tek-tips.com/viewthread.cfm?qid=1320636&page=1

-- Jumpjack --