ReFilter() does not accept empty string?

[dutch]

Dear All,

I use FWMARIADB and use SetFilter() as below

oRs := oCn:RowSet('customer')
oRs:SetFilter('status= ?', {"M"'} ) // it work for which has status="M"

oRs:ReFilter({" "}) // it doesn't work which has status=" "

How does I Refilter with empty string?

Thanks in advance,

[Armando]

Dutch:

With MySQL I use

Code: Select all  Expand view

    oRs:Filter := adFilterNone
 

Best regards

[nageswaragunupudi]

oRs:ReFilter({" "}) // it doesn't work which has status=" "

How does I Refilter with empty string?

Refilter does not work with empty string.
Very likely the value that is stored is trimmed and is "" or NULL but not " ".

Only way is
oRs:SetFilter( "PADR( status, 1 ) = ' '" )

My advice is not to rely on empty values. Instead you store a different value to indicate a 3rd value.
Like "M" for married, "S" for single, "U" for unknown.

[dutch]

Dear Mr.Rao,

Thank you so much for your help and advice. I've got it now.

oRs:ReFilter({" "}) // it doesn't work which has status=" "

How does I Refilter with empty string?

Refilter does not work with empty string.
Very likely the value that is stored is trimmed and is "" or NULL but not " ".

Only way is
oRs:SetFilter( "PADR( status, 1 ) = ' '" )

My advice is not to rely on empty values. Instead you store a different value to indicate a 3rd value.
Like "M" for married, "S" for single, "U" for unknown.

[nageswaragunupudi]

Refiltering with an empty string will work in FWH 18.04, if the field is CHAR field (not VARCHAR)

[dutch]

Dear Mr.Rao,

Like +1

Refiltering with an empty string will work in FWH 18.04, if the field is CHAR field (not VARCHAR)