Function to get field's last value

Business Central/NAV Developers Forum
1

Dear:-

Please do help ,how can i get the value of one feilds last value ,give me the c/side query/functon for that.

2

Hi,

Please provide more details about your requirement. In case you want to know the value last stored in a field (or to check if the value in field is changed), then

xRec.Field is what you are looking for.

3

If you want to check or find the last values in integer or decimal fields you can define them as key and use the FINDLAST function.

Take the field in a variable. It will be helpful otherwise xRec.Field is the best one.

4

If you want to find last value then FINDLAST/ find(’+’) is best way.

if Customer.findlast then repeat

Name:=Customer.description;

until Customer.Next=0;

5

or You can simply take a variable,because variable always hold last value of the field.so i think it is more simpler.

6

If you use FINDLAST there is no need to call NEXT like that; there shouldn’t be any next. But using NEXT(-1) could be relevant… [;)]

7

Thank u all