Adding value to option string

poppins · 2015-01-21

Hi everyone,

I have an Option field in a table with the following OptionString: opt1,opt2,opt3
I want to add a new value between opt1 and opt2.
Is it possible?or should I add it in the end?

Thanks in advance

lvanvugt · 2015-01-21

Impossible, so add it at the end.

ftornero · 2015-01-21

It's not imposible, the only problem is that you will have the values of this field wrong.

i.e. if the new OptionString is: opt1,opt11,opt2,opt3

Then in the records with old value opt2 you'll have opt11 and in the records with old value opt3 you'll have opt2.

You can run a process to let the field with the right value after the modifcation.

Regards.

mohana_cse06 · 2015-01-22

What about the code?

If you have any code with Option values then they will also change. how do you correct in all places?

If field.Opt2 = field.Opt2 then

will change to

If field.Opt11 = field.Opt11 then

mohana_cse06 · 2015-01-22

So its always better to add at the end and also leave few blank values so that we don't have any issues if Microsoft adds new values

like opt1,opt2,opt3,,,,,,,,,opt11

ftornero · 2015-01-22

Yes, you need to take care of the code too, but my point was that it's not a good practice but not imposible, and is your call to use one or another way to do it.

Regards.

lvanvugt · 2015-01-28

ftornero wrote:

Yes, you need to take care of the code too, but my point was that it's not a good practice but not imposible, and is your call to use one or another way to do it.

You're too positive. Regarding all the consequences (i.e. work to be done) I call it impossible.

Howdy, Stranger!

Quick Links

Categories

Adding value to option string

Comments