Derive value when record is read

Specify whether the virtual column should be derived from the table after reading the real column.

This option means that the virtual column is created when you read the information from the table. The information will now be derived and available for display. For example, a date is stored as format YYYY/MM/DD so the table can be properly sorted by date, but the information is displayed to the user as DD/MM/YY.

Default=NO (unchecked).


Tips & Techniques

Also See

Populate real column when writing to table