Board index » delphi » Help needed: Filtering based on calculated fields

Gabriel Cherem

Delphi Developer
Sun, 07 May 2000 03:00:00 GMT

Help needed: Filtering based on calculated fields

Seems to be impossible to filter a table based on calculated fields because
OnFilterRecord occurs BEFORE OnCalcFields.  When OnFilterRecord is called,
all calculated fields has null values.

Is there some workaround?
--

- Gabriel Cherem <gabr...@projuris.com>

 
Richard Jenkin

Delphi Developer
Sun, 07 May 2000 03:00:00 GMT

Re:Help needed: Filtering based on calculated fields


Gabriel Cherem <gabr...@projuris.com> wrote in article
<01bcf485$9f843280$32eda296@gabriel>...

Quote
> Seems to be impossible to filter a table based on calculated fields
because
> OnFilterRecord occurs BEFORE OnCalcFields.  When OnFilterRecord is
called,
> all calculated fields has null values.

> Is there some workaround?
> --

> - Gabriel Cherem <gabr...@projuris.com>

Make the expression in the On FilterRecord event then same as the
expression in the OnCalcFields event.

ie pseudo
OnCalcFields

myfield = field1 - field2

..end

OnFilterRecord
Accept := (field1 - field2 > 0)

..end

Other Threads

1. Lookup field based on calculated field - possible ?

2. Filter on Lookup Field or Calculated Field

3. Need help with calculated field

4. Help with calculated field needed

5. Using Precision with calculated fields..Need Help..

6. Sorting record based calculated field?

7. How to sort records based on calculated field?

8. Calculating field based on previous and next records

9. Calculating Detail Field Based On Group Sum

10. Calculated Fields (Calculated & Internal Calculated)