formatting my query for a full text returns:
Notes error: Query is not understandable ([Body]"String1" AND "String2")
how can I properly format a query for FTSearch... the online help is useless in this scenario....
dim searchText1 as string
dim searchText2 as string
dim condition as string (for string return with a radio button... AND OR )
dim query as string
dim test as string
searchText1 = uidoc.FieldGetText ("stringtextfield1")
searchText2 = uidoc.FieldGetText ("stringtextfield2")
condition = uidoc.FieldGetText("condition")
'searchtext1 returns "String1"
'searchtext2 returns "String2"
condition returns "AND" or a "OR" depending on RB choice.
test = |"| & searchText1 & |" | + condition + | "| & searchText2 & |"|
query = |[Body]| & test
Set searchCollection = searchDB.FTSearch ( b_query, 0 ) << error
I assume the query building problem is at "test =" , but I don't know. I've tried so many different way, I'm burnt.
Can anyone advise please?