Hi,
I try to perform a search in a view using wildcards:
Set db = s.CurrentDatabase
Set view = db.GetView("vwL02")
result = view.FTSearch(query)
If result > 0 Then
Set doc = view.GetFirstDocument
While Not doc Is Nothing
Print doc.code(0)
Set doc = view.GetNextDocument(doc)
Wend
End If
This works well if the query is a full string, or something like TEST*, it gives a list a documents starting with TEST as supposed. However, if the query is shorter, say just T*, it gives a lot of documents that do not correspond to the query. There are even documents that have no T in them at all. There is no difference between having a full-text index or not.
Any ideas?
Best regards,
Marco