Kbase P17772: The DISPLAY DBPARAM(1) statement showing 8 characters only!
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2003 |
|
Status: Unverified
SYMPTOM(s):
The DISPLAY DBPARAM(1) statement is not displaying the whole expected string.
The DISPLAY DBPARAM(1) statement is showing only the first 8 characters of the connection parameters' string.
CAUSE:
The Default Display Format in Progress 4GL is ·X(8)·. This means that the 4GL DISPLAY statement will display 8 characters unless its FORMAT option specifies a different display format.
FIX:
The Default Display Format in Progress 4GL is ·X(8)·. This means that the 4GL DISPLAY statement will display 8 characters unless otherwise specified via its FORMAT option.
For example, running the following snippet:
DEFINE VARIABLE c AS CHARACTER NO-UNDO INITIAL "12345678901234567890".
DISPLAY c.
Would display the 8 character long result:
12345678
While running the following snippet:
DEFINE VARIABLE c AS CHARACTER NO-UNDO INITIAL "12345678901234567890".
DISPLAY c FORMAT "X(20)".
Would display the 20 character long result:
12345678901234567890
Similarly, the running the following snippet:
CONNECT
-db sports
-S sports
-H myserver
-N TCP.
DISPLAY DBPARAM(1).
Would display the 8 character long result:
-db spor
While running the following snippet:
CONNECT
-db sports
-S sports
-H myserver
-N TCP.
DISPLAY DBPARAM(1) FORMAT "x(50)".
Would display the result:
-db sports,-S sports,-H myserver,-N TCP