Variables In PowerBuilder

Arrays

Initializing

1 2	String ls_array[] Ls_array = {"value1", "value2","value3", "value4"}

Set to Null Array

String ls_arrayofnulls

SetNull(ls_arrayofnulls)

// … some code that loads values into ls_array[]

ls_array = ls_arrayofnulls

Decimal

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

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

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!

Tips & Tricks

Connection Information