Had an issue today with an application that finds document using a FT search in LotusScript. The problem appeared to be quite obvious. The query was:
FIELD <fieldname> CONTAINS (<query>) e.g. FIELD CompanyName CONTAINS (Acme)
After looking into the problem the source of the issue turned out to be that the query string itself contained parenthesis’ which made the query be malformed due to the parenthesis’.
FIELD CompanyName CONTAINS (Acme (US))
The solution was to enclose the query string in quotes:
FIELD CompanyName CONTAINS ("Acme (US)")