Have not tried to use calculated fields. But the studio cannot deal with calculated fields. The studio should be able to do that.

  • be able to work with calculated fields when connecting to a not your own table.
  • Be able to define calculated fields in your own table, so we need something like DF_FIELD_NATIVE_TYPE has a value of SQL_CALCULATED as field type.
  • Be able to restructure tables with calculated fields. Key to be able to use it.
  • Define how a calculated field should be able to be used. So the options in Field_Read_only need to be able to set it

I stayed away from calculated fields. If I need a calculated field I use onPostFind to do a SQL call when it is like a dbForm or use OnSetCalculatedValue to do SQL call in cdbCJGrid