Ordwildseek and ADS
-
- Posts: 481
- Joined: Wed Jan 27, 2010 10:25 pm
- Location: Berlin Germany
Ordwildseek and ADS
Is there an replacement for Ordwildseek, when using the ADS Server ?
_______________________
Best Regards
Wolfgang
Best Regards
Wolfgang
Re: Ordwildseek and ADS
Ads supports fast text search indexes. This may be what you want. Are you using ads now?
The eXpress train is coming - and it has more cars.
-
- Posts: 481
- Joined: Wed Jan 27, 2010 10:25 pm
- Location: Berlin Germany
Re: Ordwildseek and ADS
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 ?
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 ?
_______________________
Best Regards
Wolfgang
Best Regards
Wolfgang
Re: Ordwildseek and ADS
I don't have a sample. Remind me in about 1 week after I get back home from vacation.
The eXpress train is coming - and it has more cars.
Re: Ordwildseek and ADS
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.
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.
The eXpress train is coming - and it has more cars.
-
- Posts: 481
- Joined: Wed Jan 27, 2010 10:25 pm
- Location: Berlin Germany
Re: Ordwildseek and ADS
Hi Roger,
i found a fast and nice solution with the help of the german forum.
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
....
_______________________
Best Regards
Wolfgang
Best Regards
Wolfgang
Re: Ordwildseek and ADS
Great. Thanks for posting it.
The eXpress train is coming - and it has more cars.
Re: Ordwildseek and ADS
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?
Re: Ordwildseek and ADS
Where did you get the Contains() function?
The eXpress train is coming - and it has more cars.
Re: Ordwildseek and ADS
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.
> cfilter:="{|| contains(tele1,'*"+cSuch+"*')}"
> bfilter:=&cfilter
> kota->(dbSetFilter(bfilter))
> kota->(dbgotop())
> if cSuch $ kota->tele1
It's an ADS function.