Display of data in form using conversion (OpenInsight 32-bit Specific)
At 22 OCT 2002 08:44:23AM Leon Shaffer wrote:
Situation -
OI v4.1
On a form have the data valadation set at 8N, output conversion to be L##-####-##
After entering valid data (8N) and proceeding to the next control, the display doubles the first - , so the data displays ##–###-#
I have created a test form to verify this, and it does the same thing on the test form, so it is apparently not related to a specific form.
We use these numbers as "releases", so it is important that the data displays properly in the form.
This is for display only, and the numbers (id's) are stored as numbers only (not with the '-'), so to convert the data to have '-'
in them is not viable, and I would prefer not to have to do a lostfocus event to convert the data (insert the '-' manually), then do a re-convert at the time of the write event to remove '-'.
Any suggestions?
At 22 OCT 2002 09:00AM Don Miller - C3 Inc. wrote:
Actually, this has been a problem since AREV 2.x (and earlier, if I remember correctly). I had a similar problem in my Chart Of Accounts display (R#-##-####) on a 7-digit integer structure. I solved it via a UDC which handles ICONV/OCONV properly. Just remember, that a Get_Property("DEFPROP") will contain the visual representation on the form so either ICONV the data to work on ot or use the INVALUE property.
Don Miller
C3 Inc.
At 22 OCT 2002 09:41AM John Sullivan wrote:
Leon,
I suggest you:
Take the output conversion "L##-####-##" out of your master dictionary item and the form.
For forms validation and output, copy the Zip_Format or Phone_Format subroutine from sysprocs and modify it for your number.
For printing using the reporter create a symbolic dictionary item, and
put the conversion in the formula,
@ANS=FMT({MY_NUMBER},"L##-####-##")