bi-directional CHARMAP (OpenInsight 16-Bit Specific)
At 14 JUN 2002 01:08:00PM Mike O'Neal wrote:
Hello all:
I have CHARMAP working where it is *displaying* system delimiters in an entry window if necessary, but *storing* those values as something else in the record (per SENL newsletter 2:2…)
Problem is that when running RLIST or S/LIST, we get the characters that are *stored*, as opposed to the characters that we want *displayed*. Any suggestions?
TIA,
Mike O.
At 14 JUN 2002 01:22PM Richard Hunt wrote:
Mike,
I think I understand what you are saying. When I want to *store* values one way and *display* values another way, I use the conversion (iconv oconv) method.
Once the dictionary of the file is updated with the new conversion code, I know that RLIST will *display* the *stored* values correctly, and I would believe that SLIST would too.
Kinda like the way dates are stored. A *stored* date value of 12340 *displays* as 05/01/02.
Just create a stored proceedure to handle this. Check out the errr… ummm… ahhh ZIP_FORMAT, that is a good example.
At 14 JUN 2002 04:24PM Mike O'Neal wrote:
Thanks for the response Richard, problem is that this situation is not specific to a single dictionary; these 'collision characters' could be entered anywhere. For example, someone might enter the letter in their data, which is system delimiter char(252) in OI. We use CHARMAP (see below) to store is as char(228) - but again, it outputs as char(228) in reports, which we don't want.
Mike
* CharMap=Get_Property("SYSTEM", "CHARMAP") Charmap252, 1=char(228) Charmap483, 1=char(252) Void=Set_Property("SYSTEM", "CHARMAP", CharMap) *
At 15 JUN 2002 02:34PM Richard Hunt wrote:
Mike,
Then maybe you should "convert" the input. Within every "lostfocus" event (poschanged in an edittable) you could do a convert statement.
CONVERT BAD_CHARACTERS TO GOOD_CHARACTERS IN REPLY
You could even use it as a "promoted" event.
Otherwise, I have no other ideas for you.
At 16 JUN 2002 09:40AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Mike
S/List is meant to use CHARMAP, so we'll check it here. If it isn't us it's an OIPI regression.
World Leaders in all things RevSoft
At 16 JUN 2002 02:33PM Oystein Reigem wrote:
Sprezzatura, Mike,
My bet is it's S/List's fault. I haven't tried with S/List, but I dug out and ran an OI window and function I once made for testing CHARMAP in OIPI. The delimiter characters came out fine: ú
At 16 JUN 2002 08:07PM Mike O'Neal wrote:
Sprezz and Oystein, thanks for your responses. We do not print using oipi directly, it all goes through s/list. Is there a way I can determine if it is an OIPI-specific problem?
Mike O
At 17 JUN 2002 02:03AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Initial testing here indicates that SList still respects CHARMAP. Is there any way that S/List might be called before you load CHARMAP?
[i]Celebrate CeBIT with Sprezz Local![/i]
At 17 JUN 2002 04:52AM Oystein Reigem wrote:
Mike,
You said S/ENL 2.2. I think there was a mistake in the programming posted in 2.2. Check 2.3. Or search the discussion lists for e.g
CHARMAP and Sprezzatura and Oystein and error
- Oystein -
At 18 JUN 2002 09:49AM Mike O'Neal wrote:
Hi Sprezz -
We call CHARMAP as part of our login process, so should be seeing it. Maybe an re-install of OIPI would help…?
Mike O.