FIELDTEXT mystery

Ohmes, Matt Matt.Ohmes@COGNOS.com
Tue, 21 Sep 1999 08:57:52 -0400


Yep, classic Fieldtext problem.  The DISPLAY FIELD_2 is screwing you up.
The DISPLAY verb takes the contents of FIELD_2 from the record buffer,
PLACES IT IN FIELDTEXT! and displays it on the screen. This, of course,
replaces whatever value was already in FIELDTEXT (E, O, or C in this case).

Either save the value that's in FIELDTEXT into a temporay before you call
the DISPLAY, then restore it, or drop the DISPLAY statement completely.
FIELD_2 will probably get displayed in it's own time anyway.

Good luck,
Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)


-----Original Message-----
From: Nick Tippler [mailto:NT204@cus.cam.ac.uk]
Sent: Tuesday, September 21, 1999 3:40 PM
To: powerh-l@lists.swau.edu
Subject: FIELDTEXT mystery


Afternoon All

I have a procedure which tests the value of FIELDTEXT for one field, and
changes the contents of a second field, based on the given value.
However, somewhere after EDIT and before OUTPUT, the FIELDTEXT for the
first field assumes the ASCII(value) of the second field:

PROCEDURE EDIT     FIELD_1
BEGIN
    IF         FIELDTEXT = "E"
          THEN LET FIELD_2 = 2
       ELSE IF FIELDTEXT = "O"
          THEN LET FIELD_2 = 1
       ELSE IF FIELDTEXT = "C"
          THEN LET FIELD_2 = 6
   DISPLAY FIELD_2
END

Any idea how I can stop this?

Regards
 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+
+ Nick Tippler                                  nt204@cam.ac.uk
+ Registrar, Faculty of Education,          tel +44 1223 507145
+            University of Cambridge,       fax +44 1223 507140
+            Homerton College,
+            Cambridge CB2 2PH
+
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.