Ordwildseek and ADS

[Wolfgang Ciriack]

Is there an replacement for Ordwildseek, when using the ADS Server ?

[rdonnay]

Ads supports fast text search indexes. This may be what you want. Are you using ads now?

[Wolfgang Ciriack]

I have now converted my app to DBF/FTP/CDX and try to ged rid of some problems with the ADS.
My first test at a customer looks good - speed in network is better then without ADS.
But as always there are some hints like the crypt() function (already resolved) and ordwildseek().
Do you have an example for fast text search with ADS ?

[rdonnay]

I don't have a sample. Remind me in about 1 week after I get back home from vacation.

[rdonnay]

I looked into this.

I have absolutely no experience with ADS fast text search indexes. I know they exist but I don't know anyone who uses them. I had planned to experiment with them but now I have too much work on my plate. I know no more about this than you do. What I have read in the documentation is that "full text search" indexes are designed to be used only in SQL queries because to use them you need to use scalar functions in your SQL SELECT statements.

[Wolfgang Ciriack]

Hi Roger,
i found a fast and nice solution with the help of the german forum.

Code: Select all

         cfilter:="{|| contains(tele1,'*"+cSuch+"*')}"
         bfilter:=&cfilter
         kota->(dbSetFilter(bfilter))
         kota->(dbgotop())
         if cSuch $ kota->tele1
....

[rdonnay]

Great. Thanks for posting it.

[Tim K]

I'm using the dbsetfilter( with the contains( ) function above and it works well on most searches. However, I'm getting "internal data corruption" errors for certain words, consistently. Search on "WOOD", no problem, "COOPER" it errors out. Any ideas?

[rdonnay]

Where did you get the Contains() function?

[Tim K]

Wolfgang had it in his post.

> cfilter:="{|| contains(tele1,'*"+cSuch+"*')}"
> bfilter:=&cfilter
> kota->(dbSetFilter(bfilter))
> kota->(dbgotop())
> if cSuch $ kota->tele1

It's an ADS function.