FiveTech Support Forums

Hello,

I use in DBFCDX this way to filter for all fields:

cWild := ""+ "value to search A BUSCAR" +""
cFiltro := "hb_WildMatch( '"+cWild+"', DbRecordInfo( 9 ) ) .OR.
hb_WildMatch( '"+UPPER(cWild)+"', DbRecordInfo( 9 ) ) .or. hb_WildMatch(
'"+lower(cWild)+"', DbRecordInfo( 9 ) ) "

SET FILTER TO &cFiltro

It runs very well.

But ADS does not support it.

I tried with no luck:

cName := "LUCAS"
cExpr1 := 'contains( , "'+UPPER( alltrim(cName) )+'*" ) '

AdsSetAOF( cExpr1 )

Any clue please?.

Thank you very much.

UP-.

1. You could try using the like operator with ADS.
2. Contains works perfectly if you create an FTS index on the fields where the search is to happen. No need for wild cards. Contains already searches the whole field (great for memo fields).

(cAlias)->( AdsSetAof( "contains( field, 'text' )" ) )

or

cText := "Texto"

(cAlias)->( AdsSetAof( "contains ( field,' " + ALLTRIM( cText ) + " ' ) " ) )

Notice the use of the single quotation marks and there is no blank spaces between the single and double quotation marks.

This will work with or without an FTS index, but it is simply much faster with it.

Reinaldo.

Reinaldo,

Thank you very much for helping me.

Yes, I at news.advantage they told be the function Contains.

In a single field works very good.

But not for all fields.

They told me to use *
AdsSetAof( "contains( *, 'text' )" )

But does not filter anything.

How do you create a FTS index for all fields of a DBF?.

Thank you very much.

up.-