In May 2009 I implemented Full Text Search into my application.

My application only used ibobjects for instantiating the Full Text Search metadata and initial population of this data. It was my assumption that the metadata would do all the work for ensuring the full text searches were up to date.

For example:

Application calls INSERT INTO MYDATATABLE;

I expected then the triggers implemented with Full Text Search would then take care of the rest.

HOWEVER.

I was wrong it seems.

It seems that the below is the truth:

I call

INSERT INTO MYDATATABLE;

triggers then do a POST_EVENT function which assumes that there is an IBOBJECTS connection listening to the database and then the IBOBJECTS syncs using the application components.

This was not my understanding and undermines everything I did.

Why couldn't the triggers have done everything?

Is there something I can call that can in a fast way process all Full Text Search Queued instructions?

So I can call it just before I call the Full Text Search function every time?

Kind Regards,

Robert.