Some strange results coming out from FTSearch:
'Lotus Script Code
strSearch$ = “FIELD Product = “”” & Trim(uidoc.FieldGetText(“Product”)) & “”“”
Set view = db.GetView(“ProductLookUpView”)
Call view.FTSearch( strSearch$, 0 )
Set dc = view.AllEntries
msgbox dc.count
Data looks like this:
AGP-1700
AGP-1700A
AGP-1700B…
and there are 28 of them beginning with “AGP-17”
and a lot more beginning with “AGP-1”
There are no spaces in the middle or on the left in the field.
When I search for “AGP-17*” I get 28 documents in dc.
But when I search for “AGP-1*” I get 0 documents in dc.
Does not look logical, at least to me.
Any ideas?
Thanks