RXDBGrid + RXMemoryData
lazarus / 5-Lazarus Extra Components

----------------------------------------------------------------------
kit · 2016-03-19 08:58

How I can filter record by Dialog Form

----------------------------------------------------------------------
alexs75 · 2016-03-19 09:27

At the current moment filter not working whit filter expresion. Use
OnFilter event.
Filter dialog from RxDBGrid not work with TRxMemoryData.
In future i'm plan write code for this functional.

----------------------------------------------------------------------
kit · 2016-03-19 14:23

What free component I can use for work with Filter dialog from
RxDBGrid

----------------------------------------------------------------------
alexs75 · 2016-03-19 18:10

ZEOS, SQLDB

----------------------------------------------------------------------
kit · 2016-08-12 05:02

Quote from: alexs75 on March 19, 2016, 10:27:20 amIn future i'm plan
write code for this functional.
When you can do this?

----------------------------------------------------------------------
alexs75 · 2016-08-12 07:37

done in revison 5081. please test.

----------------------------------------------------------------------
kit · 2016-09-07 06:34

it's workin but not ok.
When I try to set condition "IS NULL".
Error: Index based on unknown field "IS"

----------------------------------------------------------------------
alexs75 · 2016-09-07 11:06

for filter im use code from TBufDataset. this code not work with NULL
values.
http://wiki.freepascal.org/Lazarus_Tdbf_Tutorial#Filter_on_null_values

----------------------------------------------------------------------
kit · 2016-09-08 06:15

Maybe you can add "ISNULL" to ColumnFilter ValueList and done it?

----------------------------------------------------------------------
alexs75 · 2016-09-08 08:52

Please test revision 5134

----------------------------------------------------------------------
kit · 2016-09-09 06:46

It's don't work because you must add "break"

      if Filter.IsNull then begin
        Accept:=Field.IsNull;
        break
      end

----------------------------------------------------------------------
alexs75 · 2016-09-09 09:01

done in rev 5137
tnx.