How to change option field value in AL?

(0) Share

Report

Posted on by jdrco

485

In my Sales Header table I have a custom option field "Custom Field" with members: 'yes' and 'no'. It defaults to 'yes'. I am trying to change this option field value to 'no' based on some logic I have. This is how I am going about it:

salesHeaderRec."Custom Field" := salesHeaderRec."Custom Field"::"no";

But it is not changing the option field value :(
I've also tested and made sure that I have the correct filters applied to my record so that I am changing the row I want, so that problem is not there.

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Brad_P 1,551 on at

Like (1)

Report
Copy link

Link copied!

It is tough to give an exact answer without additional information, but first question is Are you modifying the record after changing the value?

salesHeaderRec.Modify();

Was this reply helpful? Yes No
jdrco 485 on at

Like (0)

Report
Copy link

Link copied!

Hi Brad_P , I have tried that but I get this error:

The Sales Header does not exist. Identification fields and values: Document Type='Quote',No.=''

Was this reply helpful? Yes No
Verified answer

Brad_P 1,551 on at

Like (1)

Report
Copy link

Link copied!

You need to have a Sales Header record that exists before you modify it. Set the document type and document no as appropriate.

salesHeaderRec.Get(<document type>,<document no.>);

salesHeaderRec."Custom Field" := salesHeaderRec."Custom Field"::no; (if this an enum you can explicitly use the type)

salesHeaderRec.Modify();

Was this reply helpful? Yes No
jdrco 485 on at

Like (0)

Report
Copy link

Link copied!

Right now it is an Option type, should I use an enum instead?

Was this reply helpful? Yes No
Brad_P 1,551 on at

Like (0)

Report
Copy link

Link copied!

They will both work, and there are reasons to use either. One of advantages of the enum is that the values are defined once, if you need to extend or update the values you can easily.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to change option field value in AL?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to change option field value in AL?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates