Recent

Author Topic: RXDBGrid + RXMemoryData  (Read 7724 times)

kit

  • New Member
  • *
  • Posts: 39
RXDBGrid + RXMemoryData
« on: March 19, 2016, 09:58:18 am »
How I can filter record by Dialog Form

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #1 on: March 19, 2016, 10:27:20 am »
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

  • New Member
  • *
  • Posts: 39
Re: RXDBGrid + RXMemoryData
« Reply #2 on: March 19, 2016, 03:23:26 pm »
What free component I can use for work with Filter dialog from RxDBGrid

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #3 on: March 19, 2016, 07:10:31 pm »
ZEOS, SQLDB

kit

  • New Member
  • *
  • Posts: 39
Re: RXDBGrid + RXMemoryData
« Reply #4 on: August 12, 2016, 07:02:30 am »
In future i'm plan write code for this functional.
When you can do this?

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #5 on: August 12, 2016, 09:37:51 am »
done in revison 5081. please test.

kit

  • New Member
  • *
  • Posts: 39
Re: RXDBGrid + RXMemoryData
« Reply #6 on: September 07, 2016, 08:34:29 am »
it's workin but not ok.
When I try to set condition "IS NULL".
Error: Index based on unknown field "IS"
« Last Edit: September 07, 2016, 10:06:42 am by kit »

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #7 on: September 07, 2016, 01:06:37 pm »
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

  • New Member
  • *
  • Posts: 39
Re: RXDBGrid + RXMemoryData
« Reply #8 on: September 08, 2016, 08:15:27 am »
Maybe you can add "ISNULL" to ColumnFilter ValueList and done it?

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #9 on: September 08, 2016, 10:52:05 am »
Please test revision 5134

kit

  • New Member
  • *
  • Posts: 39
Re: RXDBGrid + RXMemoryData
« Reply #10 on: September 09, 2016, 08:46:54 am »
It's don't work because you must add "break"

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

alexs75

  • Full Member
  • ***
  • Posts: 112
Re: RXDBGrid + RXMemoryData
« Reply #11 on: September 09, 2016, 11:01:20 am »
done in rev 5137
tnx.

 

TinyPortal © 2005-2018