In LotusScript, does anyone know the maximum length of a Query String that the FTSearch( Qry$, 0 ) can handle?

Question

Using LN 8.5.3 FP3, I am programmatically constructing a Query to pass to the FTSearch(Qry$, 0 ) function in LotusScript. Can anyone tell me what the maximum length the string can be before the Query cannot be executed?

The code is being run by a scheduled agent on a Notes 8.5.3 FP3 Server and htto url size is not applicable to the situation.

Anticipating your feedback and experiences..

Leon

Answer 1

as far as I see limit for 1 field/value is up to 128 characters, however as Michael noticed (in comments below) there could be many fields, very possibly with total size up to 16Kb.

you easy can do test yourself:

Dim session As New NotesSession
Dim db As NotesDatabase
Dim col As NotesDocumentCollection
Dim Query As String
Dim i As integer

Set db = session.Currentdatabase

For i = 1 To 32000
    Print i
    Query = Query & "1"
    Set col = db.Ftsearch({"} & Query & {"}, 0)
Next