Mr Rao :SetFilter no funciona

[Willi Quintana]

Mr Rao.
esto no funciona:
oData:SetFilter("codbar1 LIKE '%RF-10392%'") // NO Funciona
oData:SetFilter("codbar1 LIKE '%RF10392%'") // Si Funciona

Gracias por su atencion

[sysctrl2]

La tabla debe de tener un indice ordenado por el campo FIRST

Code: Select all  Expand view

  //setfilter
 cFirst := "Santos"
oRs:SetFilter( "FIRST = ?", { rtrim(cFirst) } )

//locate
  bSeek    := oRs:ExprAsBlock( "first = ?", { TRIM( cFirst ) } )
  if oRs:Locate( bSeek )
    ? "locate",oRs:STATE
  endif
 //seek
  if oRs:seek( cFirst,.t. )
    // ? oRs:id, oRs:FieldGet( "first" ), oRs:FieldGet("last"), oRs:age,oRs:state
  else
    ? "no existe"
  endif

 

Saludos !
Cesar SysCtrl Software

[Willi Quintana]

Estimado sysctrl2

cVar := "RS-00887" //------------ el dato contioene un guion
oData:SetFilter("codbar1 LIKE '%" + cVar + "%'") //-----------------------> NO funciona, no filtra

cVar := "RS000887" //------------ el dato contioene un guion
oData:SetFilter("codbar1 LIKE '%" + cVar + "%'") //-----------------------> SI funciona, la variable no contiene guion

el campo codbar1 tiene indice
el problema es que por alguna razon el filtro no evalua cuando el patron de filtro tiene un guion

[nageswaragunupudi]

La tabla debe de tener un indice ordenado por el campo FIRST

It is not at all necessary to have index for filters to work.

[nageswaragunupudi]

Mr Rao.
esto no funciona:
oData:SetFilter("codbar1 LIKE '%RF-10392%'") // NO Funciona
oData:SetFilter("codbar1 LIKE '%RF10392%'") // Si Funciona

Gracias por su atencion

This is a bug in our library. We regret for this. Also thank you for bringing this to our notice.
Works well if the Like Expression contains only numbers and alphabets but not chars like -, +, etc.

We are fixing this bug and testing now.

If the expression does not contain wild-card characters, you may use like this

Code: Select all  Expand view

oData:SetFilter("'RF-10392' $ UPPER(codbar1)")

Can you please let us know the FWH version you are using, Harbour or xHarbour and bcc or msvc.

[Willi Quintana]

Mr Eao, gracias por atenderme...

FW 23.07,
BCC 7.10
Harbour 3.2.0dev (r1904111533)

Saludos

[sysctrl2]

MR. Rao, con tablas de miles de registros con índices es mas rápido
saludos.

[nageswaragunupudi]

MR. Rao, con tablas de miles de registros con índices es mas rápido
saludos.

Here we are not talking about DBF tables. What you said is true for DBF fiters.

We are talking about filters in mysql tables using fwh maria library. The data is in memory and filter is applied on data which is already in the memory. Filters, sorting, seeking are all done in memory and do not read from the server.
So there is no dependance at all on the indexes on the server.

[nageswaragunupudi]

We fixed the bug and this will work from the next release.

You said you are using FWH2307 with Harbour and BCC.
Please contact me on this email
nageswaragunupudi [at] gmail [dot] com.

I will send you the revised FiveH.lib for FWH2307 with this fix.

[Willi Quintana]

Muy agradecido Mr Rao
funciona perfectamente

[nageswaragunupudi]

Just sent revised FiveH.lib (for FWH2307) for Harbour and BCC
Sent through "wetransfer.com"
You must have received a mail from them with link to download.
Please keep a safecopy of your present lib and use this new lib
Please let me know if the filters are working as expected.
Please acknowledge

[nageswaragunupudi]

This is my test:

Code: Select all  Expand view

#include "fivewin.ch"

function Main()

   local oCn
   local oRs, cFilter

   oCn := maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022" )
   oRs   := oCn:RowSet( "select * from states" )

   cFilter  := "NAME Like '%nta-cat%'"  // case not sensitive
   oRs:SetFilter( cFilter )
   ? oRs:Filter
   oRs:GoTop()

   xbrowser oRs title FWVERSION

   oRs:Close()
   oCn:Close()

return nil

Result