Hi Nick.
>I am trying to create a cursor based on payroll_tbl created in SDT which contains regular and calculated fields. I need to add a calcuated field in my select statement.
Use DBCXGetProp to get the expression for the calculated field, then include it in the SQL SELECT statement. For example:
lcExpr = oMeta.DBCXGetProp('MYTABLE.MYCALCFIELD', 'User', 'Expression')
select Field1, Field2, &lcExpr as MyCalcField from MyTable
Doug