Subject Re: How to calulate field value in a Grid?
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Fri, 30 Jul 2021 18:38:56 +0530
Newsgroups dbase.getting-started

Good Evening Milind,

> I have a calulated field in a grid.
> Scenerio :
> Field \'Aging\' which is calulated based on Date() - 'Estimated_Date'
> How to calulated Aging in a Grid Form when it opens and when 'Estimated_Date' is changed

First issue how is Aging calculated. Is it a calculated field or a field
from table.

If a calculated field then it will be changed automatically.
If from table then check the next point.

(If it is a calculated field then the rowset will probably be readonly)


How is Estimated_date changed.

If it is in grid then I have no idea. Never did such programming for
editing in Grid.

If  you are changing in entryfield then use the onLostFocus event of the
entryfield to change the value.

Regards
Akshat