Need to update blank field in a table

guganvarman_21

If the field is empty for today then I need to find the same field with yesterday date and increment the yesterday value and update the empty fileds today.

RockWithNAV

Seems like something you wan to be Auto Incremented??
You can handle this via code but see if Auto-increment Property works you.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

RockWithNAV

Seems like something you wan to be Auto Incremented??
You can handle this via code but see if Auto-increment Property works you.

guganvarman_21

Can you please give me a code for incrementing yesterday value..@RockWithNAV

RockWithNAV

@guganvarman_21 - Its a property in the TABLE for Integer Data Types

Check this out

https://docs.microsoft.com/en-us/dynamics-nav/autoincrement-property

guganvarman_21

In my table let's say for ex. i have 23 records in the table where date field = today.In that 23 lines I'm going to update only one column B.The way i update is i see first i see what is the value for column B yesterday and i increment it and update the same incremented value in all of my today's records.Can you please share some coding techniques to achieve this.