Set init value from Install Codeunit in AL

tomasevicstefan · 2019-03-20

Does anyone know how to set init values to custom fields on standard table (existing records) throw install codeunit?

wynner0 · 2019-03-21

tomasevicstefan wrote: »

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

Exactly. Or you can loop through all of them.

IF Item.FINDSET(TRUE,FALSE) THEN
   REPEAT
      IF Item."Some field" > x then
         Item."Your New Field" := y;
      else
         Item."Your New Field" := z;
   until Item.Next() = 0

Juhl · 2019-03-20

Like normal! ??

wynner0 · 2019-03-20

I think you are looking for these triggers:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extension-install-code

Just modify all the records in the table by looping through or with MODIFYALL.

tomasevicstefan · 2019-03-21

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

wynner0 · 2019-03-21

tomasevicstefan wrote: »

@wynner0 Yes, I thought on that codeunit and these triggers, but I didn't want to hardcode init values.

Maybe something like this:

if field.value = 0 then field.init()

for existing records

Exactly. Or you can loop through all of them.

IF Item.FINDSET(TRUE,FALSE) THEN
   REPEAT
      IF Item."Some field" > x then
         Item."Your New Field" := y;
      else
         Item."Your New Field" := z;
   until Item.Next() = 0

Set init value from Install Codeunit in AL

Best Answer

Answers

Categories