Ayuda con FILTER y MARIADB

[nageswaragunupudi]

Please note that FILTERS are totally different from WHERE clause.

WHERE clause is used to read limited set of records/rows from the table on the server.

FILTER is used to filter records/rows already read into the memory of the client PC (our PC)
Filter clause does not know the field names in the main table. Filters operate on the field name ALIAS used in the query.
Filters behave the same way like ADO.

We request you to kindly read the documentation again to avoid such misunderstandings and loss of time.

In your above example:

Code: Select all  Expand view  RUN

oQry:SetFilter( "A6 LIKE '%" + ALLTRIM( vGets[ 1 ] ) + "%'" )
oQry:GoTop()
XBROWSER oQry
 

DO NOT USE REQUERY()

OR, much better to use DBF syntax. We can also use parameterized filters.
Example:

Code: Select all  Expand view  RUN

oQry:SetFilter( "? $ UPPER(A6)", { Upper( AllTrim( vGets[ 1 ] ) ) } )
oQry:GoTop()
XBROWSER oQry
// later
oQry:Refilter( { "ABC" } )
oQry:GoTop()
XBROWSER oQry
 

[goosfancito]

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

[nageswaragunupudi]

You are the programmer. You know if you previously used oRs:SetFilter() and what parameters you used for this filter, if any.

Anyway
oQry:Filter --> present filter expression
oQry:aFiltParams --> array of parameters used, if any

[Armando]

Goos:

Tal vez te puede ayudar a re abrir la tabla con la cláusula WHERE

Saludos

[goosfancito]

Goos:

Tal vez te puede ayudar a re abrir la tabla con la cláusula WHERE

Saludos

Hola.
Ya Willi me dio una mano y me di cuenta el error que cometía (REQUERY) despues de aplicar el FILTER no tuve que modificar nada mas de mi codigo, solo comentar el REQUERY()

Gracias a todos!