| 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
|