Data conversion masks (OpenInsight 32-bit Specific)
At 21 JUL 2003 11:43:18PM Patrick McCann wrote:
Hi,
I am coming from the UniVerse environment and am wondering if something similar to the 'MCT' or 'MCU' conversion codes are available in OI 4.12. The 'MCT' converion will take a string such as "THIS IS A TEST" and convert it to "This Is A Test" and the "MCU" conversion will force a string to all uppercase.
What I would like to do is to allow data entry to input in uppercase and then have the form handle the conversion to lowercase (Mask characters Text (MCT).
Thanks for any help or suggestions.
Pat
At 22 JUL 2003 12:06AM Richard Hunt wrote:
I actually have customers still using "UniVerse". The "MCT" does have something similar, kinda, it is the "NAMECAP" function. The "MCU" has nothing.
You could create your own "UDC" (user defined conversion). Its simple to do. Just convert lower case to upper case. Once you have created the UDC the statement would be as follows…
UniVerse… RESULT=OCONV(STRING,'MCU')
OpenInsight… RESULT=OCONV(STRING,'MCU')
The brackets state that it is a UDC.
The user help for "ICONV" and "OCONV" is not quite right. Be careful… OCONV does not set the STATUS() variable. and ICONV does nothing on NULL strings.
Also multiple cursors (multiple active select lists) do not work well in OpenInsight.
At 22 JUL 2003 01:55AM Patrick McCann wrote:
Richard,
Thank you for the information. I was able to create the "UDC" using the Namecap function and get it to work. Do you know if it is possible, and how I would accomplish adding it to the list of available conversion and validations in the Validation/Conversion/Display" window.
Thanks for the help.
Pat
At 22 JUL 2003 02:37AM Donald Bakke wrote:
Pat,
That list cannot be modified as it is hard-coded. You just have to manually enter the name of your user-defined conversion (UDC) by surrounding it with brackets, e.g.:
MY_UDC
BTW, we already have a similar conversion to what you are describing. I think you might already have a copy…it's called FIRST_CAPS.
dbakke@srpcs.com
At 22 JUL 2003 05:39AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Don is correct - those strings are hardcoded into TABLEAPI.DLL. If you're prepared to put the definitions into the dictionary however you can modify SYSVALIDATIONS and SYSCONVERSIONS in SYSREPOSPOPUPS.
World Leaders in all things RevSoft
