Variables In PowerBuilder
Arrays
Initializing
1 2 | String ls_array[] Ls_array = {"value1", "value2","value3", "value4"} |
Set to Null Array
1 2 3 4 | String ls_arrayofnulls SetNull(ls_arrayofnulls) // … some code that loads values into ls_array[] ls_array = ls_arrayofnulls |
Decimal
1 2 3 4 5 6 7 8 | decimal {4} a,b,d,e,f decimal {3} c a = 20.0/3 // a contains 6.6667 b = 3 * a // b contains 20.0001 c = 3 * a // c contains 20.000 d = 3 * (20.0/3) // d contains 20.0000 e = Truncate(20.0/3, 4) // e contains 6.6666 f = Truncate(20.0/3, 5) // f contains 6.6667 |
Default Values
Variable | Default Value |
Blob | A blob of 0 length; an empty blob |
Char (or character) | ASCII value 0 |
Boolean | FALSE |
Date | 1900-01-01 (January 1, 1900) |
DateTime | 1900-01-01 00:00:00 |
Numeric (integer, long, decimal, real, double, UnsignedInteger, and UnsignedLong) | 0 |
String | Empty string (“”) |
Time | 00:00:00 (midnight) |
Variable Declaration, setting to null
To set a variable to null in the declaration statement
1 | integer si_dup_printer_adjust = SetNull(si_dup_printer_adjust) |
Integer
1 2 3 | integer i i = 32767 i = i + 1 // i is now –32768 |
String
A standard data type that is characters enclosed in single (‘) or double (“) quotation marks, including a string of 0 length (the empty string “”). The maximum number of characters in a string is 60,000.
Null
1 2 3 4 5 6 7 | integer a, b=100, c SetNull(c) a = b+c // all //statements set a to NULL a = b - c a = b*c a = b/c |
Masks
! Upper Case
^ Lower Case
a Alphabetical
x Any character
# Number
Sample format | 5 | -5 | .5 |
[General] | 5 | -5 | 0.5 |
0 | 5 | -5 | 1 |
0.00 | 5.00 | -5.00 | 0.05 |
#,##0 | 5 | -5 | 1 |
#,##0.00 | 5.00 | -5.00 | 0.50 |
$#,##0;($#,##0) | $5 | ($5) | $1 |
$#,##0;-$#,##0 | $5 | -$5 | $1 |
$#,##0;[RED]($#,##0) | $5 | ($5) | $1 |
$#,##0.00;($#,##0.00) | $5.00 | ($5.00) | $0.50 |
$#,##0.00;[RED]($#,##0.00) | $5.00 | ($5.00) | $0.50 |
0% | 500% | -500% | 50% |
0.00% | 500.00% | -500.00% | 50.00% |
0.00E+00 | 5.00E+00 | -5.00E+00 | 5.00E-01 |
Get From Internet
Good Luck!