FiveTech Software tech support forums

Maybe with Refilter ?

http://forums.fivetechsupport.com/viewtopic.php?f=3&t=40438&hilit=refilter&sid=6f66d10cde594a73729efcf9cdbb09cd

muchas gracias!

Indicas que primero se use el SETFILTER y luego el REFILTER, como es el método para saber si ya se usó el SETFILTER primero?

a esto me refiero:

if (::oQry:SETFILTER() != nil)
...

Gracias

yes
try

It is already there in many past versions. Nages, I can converte also this block ? oPrenotazioni  := TDatabase():Open( nil, oApp():cDbfPath+"RESERVA",   "DBFCDX", .t. )              oPrenotazioni:Exec( < ||              SET FILTER TO AllTrim( F...

It is already there in many past versions.

all this for the next package ?
when is go out ?

When you set filter with
oDbf:SetFilter( cFilter, aParams )
The method applier the aParams to cFilter and prepares the filter string to set the filter.
You can check the exact filter string with
? oDbf:DBFILTER()
and see if this is what you expected.

Gulp, nice !!!

cFilter := "TRIM(TIPO) == ? .AND. GIORNI == ? .AND. IDELEMENTO == ? .AND. " + ;
"SETTORE == ? .AND. ALLTRIM(IDLISTINO) == ? .AND. MESE == ?"

oDbf:SetFilter( cFilter, { cTipo, nGiorni, cidelemento, cSettore, clistino, nmese } )

Nages, I need to make a filter with different fields ie for example:          cFilter := "trim(Tipo) == '" + cTipo +;                  "' .and. alltrim(str(giorni))== '" + alltrim(str(nGiorni)) ...

nice job

... "AGE >= ? .AND. AGE <= ?", { 30, 40 } )// This sets filter AGE >= 30 .AND. AGE <= 40// LateroDbf:ReFilter( { 40, 50 } )// changes the filter as AGE >= 40 .AND. AGE <= 50  SetFilter( cFilter, bParams ) n1 := 30n2 := 40oDbf:SetFilter( ...

You can also try oRs:SetFilter( "TIPO = ?", { cTipo } )  If you use this approach, then later you can use refilter. Example: oRs:SetFilter( "state = ?", { "NY" } )// after some workoRs:Refilter( { "WA" ...

... una matriz cuando es evaluado. Uso: oDbf:SetFilter( "UPPER(FIRST) = ? .AND. HIREDATE >= ?", ; { cName, dDate } ) - Nuevo: Método Refilter( aParams ): Restablece el filtro utilizando la expresión de filtro utilizada previamente con los nuevos parámetros. - Mejora: Cuando la relación ...

... returns an array when evaluated. Usage: oDbf:SetFilter( "UPPER(FIRST) = ? .AND. HIREDATE >= ?", ; { cName, dDate } ) - New: Method Refilter( aParams ): Resets the filter using previously used filter experession with the new paramters - Enhancement: When relation is set to another ...