Please see this A5 web page to help you follow the discussion: https://www.burtnco.com/search.a5w
I have indexes for every field in the catalog.dbf table so any of the search parameters of the Search page produces a very fast results page. There are 15 indexes. The majority of the web site though are static web pages (no searching involved). These have price look-ups for every item, the code being <%a5 ? lookupc("f",catalog->id,"cprice","catalog","id") %>. These all work great. It actually looks as though the prices were written out for each line, but in this case, every line is dynamic, changing when we change prices in-house. Works great!
However, to create a "quick search" routine (see top of every screen), when I add a text search index of field "sfield" to the list of indexes, all of the static pages throw a "can't open index" for the index "id," making the pages unloadable. When I remove this text search index and rebuild the list, everything returns to normal.
My work-around is to create a "mirror" table, containing all the records the original has but none of the indexes, only that full-text search on "sfield." This works great also. BUT... this "mirror" table is cumbersome in that it needs to be updated (appended to, index rebuilt) every other day in order that it remain current with the original table.
Isn't there a way that I can add a full-text search on a field in the Catalog and still have "lightening query" work with the other 15 indexes? It would negate the need for an alternate table to be my "quick search" table and thus reduce my workload in keeping everything current.
I have indexes for every field in the catalog.dbf table so any of the search parameters of the Search page produces a very fast results page. There are 15 indexes. The majority of the web site though are static web pages (no searching involved). These have price look-ups for every item, the code being <%a5 ? lookupc("f",catalog->id,"cprice","catalog","id") %>. These all work great. It actually looks as though the prices were written out for each line, but in this case, every line is dynamic, changing when we change prices in-house. Works great!
However, to create a "quick search" routine (see top of every screen), when I add a text search index of field "sfield" to the list of indexes, all of the static pages throw a "can't open index" for the index "id," making the pages unloadable. When I remove this text search index and rebuild the list, everything returns to normal.
My work-around is to create a "mirror" table, containing all the records the original has but none of the indexes, only that full-text search on "sfield." This works great also. BUT... this "mirror" table is cumbersome in that it needs to be updated (appended to, index rebuilt) every other day in order that it remain current with the original table.
Isn't there a way that I can add a full-text search on a field in the Catalog and still have "lightening query" work with the other 15 indexes? It would negate the need for an alternate table to be my "quick search" table and thus reduce my workload in keeping everything current.