FTSearch - Query is not unterstandable

HCL Domino Domino Forum
1

Hello,

i try to search a document in a view with FTSearch. The following code

Set vw = db.GetView(“Artikelkonditionen”)

search = |FIELD Artikelnummer = "| & Mid$(doc.MATNR(0),13,5)

j = vw.FTSearch(search,0)

gives an error: Notes Query: The Query is not understandable!

With another field the query works. The field “Artikelnummer” exists in the form.

What’s wrong?

2

Subject: FTSearch - Query is not unterstandable

Looks like you may need to close the quote…

search = |FIELD Artikelnummer = “| & Mid$(doc.MATNR(0),13,5) & |”|

3

Subject: RE: FTSearch - Query is not unterstandable

It doesn’t work, too!

Dirk

4

Subject: RE: FTSearch - Query is not unterstandable

Now, it’s works:

search = |FIELD Artikelnummer = | & Mid$(doc.MATNR(0),13,5)

Of course, Artikelnummer is a Text-Field. But without qoutationmarks it works.

5

Subject: RE: FTSearch - Query is not unterstandable

Now, I get the same error in another piece of code:

forall kd in Kundennummer search = |FIELD Kundennummer = “| & kd & |”|

j = vw.FTSearch(search,0)

…

end forall

This works in one database, but in another not. Both databases are indexed and use the same template!!!

I think this is a bug of the index process?!?