I have been pulling my hair out (well, i'm bald but anyway) on this.

I have FTS set up and in the IB_FTS util *application* when i search i get one row for each hit regardless.

If the used column in the FTS$<<INDEX>>$WRD contains more than one entry for the table id, this can happen when using partial matches, i get one hit record back for each match - generation some duplicates.

Now i could put a "Distinct" keyword in my query and that would work, but the IB_FTS application does not! So i've been looking at where the duplicates are removed. I can not find the place!

This is very frustrating. If i look at the IB_FTS application SQL monitor output firebird does give back the duplicates. And if i copy the query from the monitor output and run it in a DB management application i'll get the duplicates too.

It was some time since i used the "native" IBO components so maybe there's an automatic keylink-duplicate removal thingy somewhere? Please, if anyone knows could you point me to the property/code?

This may sound as a picky question but i need to get the searches absolutely right for a high-load server application.

TIA,

/Dany