rDBGrid with TMS Aurelius

[gshelt...@gmail.com]

Hi Tomas,

I would like to use your grid with TMS Aurelius ORM. Some problems though. Aurelius's TDataset does not use the filter property, instead it uses the OnFilter event. Before I go poking around in your code I thought I would ask you.

Is there a way to intercept the default filtering, get the filter fields and then write an OnFilter event?

The same for the sorting. I guess I would need to inherit a new sorter?

What about making the Grid dialogs work with Aurelius?

BTW even the grid from TMS does not support this, as far as I know.

Right now the functionality of your grid and dialogs win out on using Aurelius!

Thanks,

Gary

[Tomas Rosinsky]

HI Gary,

it is quite complex question :)

The easiest part is sorting -  a new sorter is needed for any new dataset types as sorting is not defined in the basic Dataset, but is is quite easy, just few lines of the code.

Filtering is another story and it depends which type if filter do you mean.

Currently rDBGrid as well as rDBFilter dialog just compose filter conditions (simple or complex one) and set Dataset Filter property, then filtering is provided by dataset.

rDBGrid itself provides text filter (composes "SomeField LIKE SomeValue" condition) and funnel filter (composes "SomeField = XX OR SomeField=YY" condition) which can be combined with another filter conditions provided by user. 

rDBGrid could be easily extended by a new properties providing fields and filtered values which could be used quite easilly in the OnFilter event then. 

rDBFilter dialog is general and provides only filter string (which can be very complex), so it can be hardly use for OnFilter event (if you do not want to parse text conditions....).

Anyway all other DBDialogs should work even with Aureilus without any limitation.

I hope it helps

Tomas