So, we had a discussion yesterday and felt that we were in desperate need of additional characters in our RMS ‘Description’ field. However, for our own reasons, we want to retain the ability to use RMS to edit these values (the owner of my company uses RMS exclusively, hence the need to retain editability). I am aware that there is an attribute in PAM already to workaround the ‘Description’ character limit, however, it is not the solution we need.
We decided that the ‘Notes’ field in RMS would be our savior, and I ventured into PAM to remove all current values from the ‘Notes’ field. I was met with an error (preventing me from modifying these values): “Error detecting field type (16) for field: Notes”.
Which leads me to my question: How can I make PAM let me modify the ‘Notes’ values of RMS/our database? Am I going to have to write an SQL command, or is there a way to clean out Notes w/o one?