TOracleDataset

[ThomasPfister]

hello,
I've a little problem:
I develop a addon, mean it isn't my oracle-schema, I only use the tables with select, non sp or others available...
the table looks like:
amount year
100 2000
110 2001
60 2002
60 2003

the amount before 2002 are DM-currency, 2002 and after 2002 are EUR-currency on one field :-((
which is the best way to show the amount-values only in EUR with the TOracleDataset.

thanks for any hint!!!

thomas

 

[Marco Kalter]

You could create a calculated field and perform a calculation in the OnCalcFields event handler. You can also solve this in SQL:

select amount / decode(sign(year - 2002), -1, 2.1, 1) as eur_amount,
       year
  from mytable

This assumes that 1 EUR = 2.1 DM.

------------------
Marco Kalter
Allround Automations