Omnis Mysql defined list

[Stephen Baugh]

Hi Everyone

Is there a way to add columns to a .$definefromsqlclass list definition, so that a calculation is processed as the list is built?

This might be a pick lookup or math function etc

I want to add for example, the following calculations to this definition, after of course adding the new columns separately if required.

Do $cinst.iWindowList.$definefromsqlclass($cinst.iRowTableName) Returns lvStatus

Calculate Month as ovControl.$doDivide(C_SUPP_BAL_MTH,REG_EXCHANGE_RATE)
Calculate Current as ovControl.$doDivide(C_SUPP_BAL_CUR,REG_EXCHANGE_RATE)
Calculate 30days as ovControl.$doDivide(C_SUPP_BAL_30,REG_EXCHANGE_RATE)
Calculate 60days as ovControl.$doDivide(C_SUPP_BAL_60,REG_EXCHANGE_RATE)
Calculate 90days as ovControl.$doDivide(C_SUPP_BAL_90,REG_EXCHANGE_RATE)

Both C_SUPP_BAL_MTH and REG_EXCHANGE_RATE are defined in the list definition.

I hope this makes sense, and as always thanks for the help.

Cheers
Stephen