SO Line custom field removal  Topic is solved

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

SO Line custom field removal

Postby indikad » Mon Jul 11, 2016 5:49 pm

I have a line custom field on Jiwa 7 157 - that is of type Combo

It has about 5 selectable fields and been there for a while meaning users have used the selectable values to save data over time.
Now they wish to remove some and also change the names of some.
What could be the implications if I do.... ?
indikad
Frequent Contributor
Frequent Contributor
 
Posts: 182
Joined: Thu Jun 18, 2009 1:14 pm
Topics Solved: 2

Re: SO Line custom field removal  Topic is solved

Postby Mike.Sheen » Sun Jul 31, 2016 12:52 pm

Hi Indika,

The values stored for a selected item is an index into the combobox items.

If you start off with 3 items in your combo with the underlying values "1", "2", "3" and the display values "a", "b", "c" - then any custom fields renamed will automatically display the new display value without problem, as the underlying value is still the same.

Removing an item such that the underlying value is no longer present will cause the displayed value to be blank when shown, but the underlying value will still be as it was. So, if using the above example data I removed combo item with value "2" and display value "b" - then reading a record which was referring to "2" will display as blank, but the data in the table will still be "2".

Mike
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 0 guests