Subject Re: [IBO] FTS: ibo42.n
Author Helen Borrie (TeamIBO)
At 04:00 PM 04-02-02 -0500, you wrote:
>Hi Jason,
>Just getting around to testing your FTS components and I'm having a problem.
>Having followed your example in the FTS help file I have indexed the
>Directions field (BLOB SUB_TYPE 1 SEGMENT SIZE 80) in my org table. My
>initial results were quite promising as all data searched extremely fast.
>It's when I modify the Directions field that things seem to go south. The
>help files indicates that I should see the changes on the 'Sync Events Log'
>tab. I check the Listen for Events, open IB_SQL modify the field and wait
>for a message. Nothing shows. I then Press a combo of Resync Index or Clean
>and Resync Index and then conduct a search of the data added since the
>Creation of the FTS index. Sometimes the data shows, but mostly it doesn't.
>If I drop metadata and rebuild the index from scratch everything shows. Any
>idea's as to what I might be doing wrong?

Is there any chance that the modifications to the database tables are not being committed in some instances? It could happen in IB_SQL if you forget to hit the Commit button, or if a database error is not handled - in which case, any updates to the FTS tables would be part of the same unresolved transaction(s).

Can you get any clues from the monitor about what is happening client-side when these problems occur?

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at