Maximum Number of Virtual Fields
Posted: Sat Mar 25, 2017 2:56 am
Is there a maximum or a recommended maximum number of virtual fields for a file?
I have a file that is full of dates stored as Signed(8,0).
For each of those dates, I add a virtual field as DATE and the use a code fragment to either format the appropriate value on the read and write.
That works great and I would like add an additional virtual field as a ALPHA(10) (essentially a "display date") that is only used on history or report pages.
The value is formatted appropriately on reads depending on if there is a date for the field or not.
I find that using a "display field" like this is easier to use than having to manage two labels (caption and value).
If I do that, I will have 24 virtual fields on a single file.
Is that to many?
I have a file that is full of dates stored as Signed(8,0).
For each of those dates, I add a virtual field as DATE and the use a code fragment to either format the appropriate value on the read and write.
That works great and I would like add an additional virtual field as a ALPHA(10) (essentially a "display date") that is only used on history or report pages.
The value is formatted appropriately on reads depending on if there is a date for the field or not.
I find that using a "display field" like this is easier to use than having to manage two labels (caption and value).
If I do that, I will have 24 virtual fields on a single file.
Is that to many?