Simple question about Field type option!

Business Central/NAV Developers Forum
1

Folks, This should be a simple question, but can make you mad if you are working in the pressure/short time. [xx(] How to change the data type of field in a table from option becomes text if there’s already some existing data. For example you want to change field “queue priority” from option to text or int. Please advice me briefly. Thanks in advance as always. Jemmy

2

Hi Jemmy, You have to make sure that the field is empty before you change the data type. You cannot change the data type of a field before the value in the field is reduced to 0 or ‘’ in all records. BR

3
  1. Create a new temporary Text field in the Table; 2) Run a batch to fill in the new Text field with FORMAT(OptionField); 3) Confirm the new Text field contains the data you want it to contain; 4) Run a batch to delete the values in all records of the Option field; 5) Change the data type of the Option field to Text; 6) Run a batch to fill in the newly converted Text field with the contents of the previously created temporary Text field; 7) Confirm the converted Text field contains the data you need; 8) Run a batch to delete the values in all records of the temporary Text field; 9) Delete the temporary Text field from the Table. You could group some of these actions together if you are confident enough.
4

Guys, Thanks a lot for the quick responses…!!! I’ll try to accomplish this in the next hours. Thanks again for the walkthroughs… I’ll try… will update later…

5

Hi guys, Nelson, Your guide is absolutely great! It works like supposed to now. [:D] Thanks a lot… Jemmy

6

No problem. That’s what everyone is here for: help and get helped. [;)]