FWH MariaDb/Mysql setfilter problem.

[Adolfo]

Nages...

oDbDato:SetFilter("nombre like '%NAME LASTNAME%'") does not work.
Only oDbDato:SetFilter("nombre like '%LASTNAME%'") works, each time a space is in the filter, it does not work.

Any tip or advice

From Chile Adolfo

[dutch]

Dear Adolfo,

If you use FWMARIADB, You can use :SetFilter() as xbase syntax.

Code: Select all  Expand view

oDbDato:SetFilter(" 'LASTNAME' $ nombre ")

or
exactly

Code: Select all  Expand view

oDbDato:SetFilter("nombre=?",{"ADO"} )
oDbDato:ReFilter( {"SMITH"} )

or more details
viewtopic.php?f=3&t=32657

I hope, may help.

Nages...

oDbDato:SetFilter("nombre like '%NAME LASTNAME%'") does not work.
Only oDbDato:SetFilter("nombre like '%LASTNAME%'") works, each time a space is in the filter, it does not work.

Any tip or advice

From Chile Adolfo

[Adolfo]

Hi dutch

It wont work... I dont know if the customer is going to enter only the name or both name and lastname.
And it could be any of the fields in a xbrowse, it is created dinamically

The only problem I see, is the space in between the variable you pass to the filter ???

[nageswaragunupudi]

Please use simple DBF syntax like this:

Code: Select all  Expand view

oDbDato:SetFilter("'NAME LASTNAME' $ UPPER( nombre )")
 

Rowset filters work exactly like the DBF filters we use.

[Adolfo]

Thanks... works as exspected


From Chile Adolfo

[nageswaragunupudi]

As you said, if the constant has a space character, setting filter with like clause is not working. We did not notice it until you pointed out. It will also work from FWH 18.06 onwards.