DADE & OnCalcEvent equivalent

rbuser

Hi,

Playing around with DADE and the Query Wizard/Query Designer.
I have an SQL that I'm trying to recreate in DADE.
It uses calculated fields and on the OnCalculate event
fires off another query. Does DADE allow me to do the equivalent, perhaps
via dataview templates?
I've got a situation where I only want to join to another table on some rows
and need to make that decision in
some event code.

Cheers

Tony Peppercorn

nicocizik

Hi Tony,

Unfortunately if you want keep building your queries visually in DADE, you
will have to change your data so the calculations are already made before
DADE is used. There are a couple other options as well such as inserting
your own custom SQL statement in place of the one DADE generates and/or
creating a custom dataview. Both of these options then prevent you from
further using the visual controls of DADE.

--

rbuser

thanks Nico, I just realised I probably should have posted in the DADE
newsgroup.