B
bar graphs 212
base menu 302
base object 229
binary files 61
bitmap 274
blank DataWindow 189
blank out 189
blobs 334
boolean 187, 322
browser 72, 336
build process 42
button down 274
C
C code 42, 298
C/C++ 327
call 120
calling code 232
canceldialog 198
cascaded menus 268, 270, 298
centering a window 238
CGI programs 333
change color
choosing a color 243
command button 242, 243
drop-down list 242
hardcode 243
PowerBuilder painters 242
screen resolutions 242
SetSysColors() 243
change colors 164
CHECK-IN 70
CHECK-OUT 70
child DataWindow 156
child window 330
CHOOSE CASE statement 93, 94
class name 232
ClassName() 232
client 318, 332
client application 315, 316
client area 296
client information window 33
client/server 328
computing 4
programming 2
client's library list 318
CLOSE 130
CloseTab() 257
CloseWithReturn() 103
closing a tab 257
COBOL 5
code 24, 61, 256
adding scrollbars 298
arrow keys 187
client requests 319
connecting to server 320
embedding into web pages 332
graphs 214
populating a datawindowchild 160
printing windows 200
referencing colors 105
responding to system errors 86
RetrieveRow event 162
retrieving a string value 116
Rich Text control 261
row focus 97
setting colors 99
setting focus 106
setting up SQLCA 149, 287
to insert a tab 257
window position 238
window sizing 299
code table 182, 215
coding conventions xxiv
colheading 329
color bitmap 243
command buttons 244, 330, 335
structure 249
command prompt 52
COMMANDBUTTON! 250
commit statement 289
communicating 29
communications 320
drivers 334
compile 40
application 22
compiler error 318
computed expression 211
concurrent development 176
conditional basis 164
config.sys 53
CONNECT USING SQLCA 286
Connection Object 320, 321
ConnectString 283
values 283
constant variables 21, 31
declaring 32
constructor event 24, 223
Contents 311
control 254
control array 249
control menu 298
Control Objects 225
controlname 218, 253, 254
controls 306, 330
create 42
Create New tab 310
Create() 196, 197
creation of tables 291
ctGauge 307
CTRL-Click method 59
current tab 255
cursors 130
custom user event 299
custom Visual Object 224
customer ID 36
D
dashes in identifiers 275
data buffer 195
data column 158
data retained on save 182
database 332
application connectivity 285
autocommit 289
drop-down list box 282
management system name 281
name 281, 282
not enabled 281
performance degradation 285
PowerSoft demo 283
profiles 281, 285
server name 281
storing information 286
table 244
transaction log 290
database connection parameters 26
Database Deployment Kit 15
DataBase Management System 16
Database painter 284
datapoint 218
datasource 141
Datasource name
Windows Control Panel 283
DataStore 181, 244, 317, 334
datatype 176, 322
DataWindow 75, 133-200, 323, 330
"information is not available" 135, 148
"not updatable" 135, 150
background layer 146
band layer 146
bands 134, 146
blank 189
changing properties 166
child 156
control 134
definition 134
detail band 146
display formats 170
does not appear 153
edit masks 170
footer band 146
foreground layer 146
formats 170
header band 146
layers 134, 146
Object 134, 147, 177
painter 136, 166
painter InputFields 265
plug-in 328, 330
previewing 170
printing 140, 198
printing headers 169
prints blank page 169
processing keystrokes 186
SetTransObject error 179
SQL UPDATE and DELETE commands 151
test field 172
Update() 150
versus DataStore 181
DataWindow control 147, 168, 173, 222
DATAWINDOW! 232, 250
datawindowchild 160
datawindowname 198
DB process 293
DB Profile icon 281
dberror event 223
DBMS 16
DBParm 282
DDK directory 9, 15
DECLARE 130
declare 112
constant variables 31
global variables 31
DEFAULT 334
default icon 39, 311
default MicroHelp 295, 300
altering 301
default values 334
default Window's printer 198
DELETE commands 152
delete function 151
Deployment Kit install 15
descendant 187, 277
scripts 226
design 30
design menu item 248
Design Options Window 248
desktop database 282
DESTROY 27
dialog box 48
direct referencing 33
directly 190
directly referenced 190
DISCONNECT 27
disconnect 293
DISCONNECT USING SQLCA 286
display
changing data 328
formats 170
type 311
values 215
distributed PowerBuilder 315, 317, 322
functions 315
remote functions 317
server 316
single return value 315
distribution 50
DLL 190, 298, 331
conflicts 9, 11
DO 93
DO? UNTIL statement 95
DO? WHILE statement 95
dot notation 226, 254
DoubleClick 311
download 330
drivers 16, 319, 320
native PowerBuilder 285
ODBC 285
drop-down list 151, 211, 215
window color 242
DropDownDataWindow 136, 156-159, 189, 215
creation 156
DropDownListbox 158
duplicate variable 49
dwstartcolumn 194
E
edit control 173
edit mask 137, 170, 173, 246, 247
editmaskname 247
embed statement 331
embedded
object 310
SQL 127, 292
embedding
another application 309
Create From File tab 309
Create New 309
Microsoft Word 310
OLE 2.0 standard 309
OLE server 309
empty string is NULL 189
empty string property 176
encapsulation xxiv, 30, 228, 253
endcolumn 194
endrow 194
Enumerated tab 187
error message 9
Error Object 85-89
errors 176
and constant variables 32
control array 249
create of EXE failed 22, 42
duplicate variable 23, 49
exceeds 64K 44
invalid datatype 269, 275
null object 22
Null Object Reference 49
obsolete function 22, 45
out-of-memory 23, 51
runtime DLLs 23, 53
SetTransObject 179
transaction information not available 190
errorstring 197
event 113, 116, 117, 118
event ID 307
event messages 300
EXE 42
EXECUTE IMMEDIATE 288
explode 218
export 60
Export icon 61
Expression painter 165
Expressions tab 164
external DataWindows 134, 145
external functions 123, 298
F
f_getdata() 318, 321
failed 42
FETCH 130
file menu 270
filename 329
Find icon 59
fire an event 255
fired and destroyed 34
floating toolbar 241
flow control 93
focus 170
fonts 237
FOR 93
FOR? NEXT statement 95
FORM 335
format 137, 170
frame window 296
Full Rebuild 69
function 118, 315
Activate() 312
ClassName() 232
CloseTab() 257
CloseWithReturn() 103
Create() 196
Datasource() 263
f_getdata() 318
GetActiveSheet() 119
GetDataPieExplode() 218
GetFileOpenName() 261
GetItem() 173
GetText() 174
GetUser() 30
ImportFile() 194
Importstring() 323
InputFieldInsert() 263
InsertDocument() 261
IsNull() 334
LibraryImport() 76
LinkTo() 311
LookUpDisplay() 216
Modify() 178
Move() 81
ObjectAtPointer() 217
OpenSheet() 298
Print() 198
PrintOpen() 199
PrintSetup() 198
ProfileString() 287
RegistryGet() 239, 286
RegistrySet() 239
SaveAs() 328
SaveDocument() 261
SetColumn() 106
SetDataPieExplode() 218
SetMask() 246
SetNull() 37
SetPosition() 241
SetSysColors() 243
SetTrans() 135
SetTransObject() 135
ShareData() 195
Update() 150
Yield() 163
Function painter 121
functional areas 228
functions.pbl 65
G
g_transport 319
generic function 38
GetActiveSheet() 119
GetDataPieExplode() 218
GetFileOpenName() 261
GetFocus 311
GetItem() 173
GetUser() 30
global declarations 124
global Non-Visual 30
global variable 21, 25, 29, 49, 244, 319, 331
declare 31
defined 32
graph
functions and usage 214
graph control 213
Graph Object 211-219
axis tab 212
datatype tab 212
division scale tab 212
graph tool 211
graph types 212
graphcontrol 218
graphs 209-219
associated value 215
axis 211
controlname 217
creating 211
default mouse pointer 212
fonts 212
graphcontrol 217
interactive 218
NULL value 217
ObjectAtPointer() 217
populating 214
return values and meanings 217
setting up columns 216
grayed out 307
grid lines 180
H
handle 111
handleafter 75
handleparent 75
hardcoded 90, 301
headers 169
HTML 328, 329, 332
code 335
formatted string 335
HTML page 332
I
icon 22, 38, 273, 311
suite of 39
IDE 167
IF 93
IF function 165
IF? THEN statement 93
image 39
import a text file 194
Import icon 61
ImportFile() function 194
Importstring() 323
increased functionality 222
index 323
indirectly referenced 190
inheritance xxv, 222, 231, 245, 267, 269, 276, 302
changing 56, 60
new menu items 278
Inheriting menus 276
INI file 239, 287
In-place activation 312
input fields 263
INSERT 152, 290, 323
Insert Contro 309
Insert Control 306
Insert Object 309
Insert Object dialog 306, 310
InsertDocument() 261
inserting data
datasource 263
Datasource() function 263
InputFieldInsert() 263
retrieve 263
Rich Text edit control 263
inserting tabs 257
inserts 328
installation 18
installation process
overview 8
installing DLLs
outside the system directory 54
instance variables 49, 229, 249, 255, 332
defined 32
memory overhead 34
Instance Variables Declaration Dialog 32
integer variable 218
interactive graphs 218
interface elements 224
Internet 328
applications 326-336
server's CGI programming interface 327
Internet aware application 332
Intranet 328
intranet
applications 326-336
invisible controls 248
IsNull() 334
itemchanged event 167, 169, 175
K
key
columns 293
errors 324
modification 152
keypress event 186
keystroke 186
L
layers 146
less than 600K 52
Level One VBX 304
libraries 55-77
overview 55
searching 58
size 63
Library painter 10, 58, 196, 318
library path 21, 28
library search path 65
LibraryImport() function 76
lifetime of the application 31
line graph 212
link update 311
Automatic setting 311
linked 310
LinkTo() function 311
list window 34
listbox 28, 224, 306, 330
listen 319
Local 332
local area network 2
local declarations 124
local variables 34
LogID 282
login window 287
LogPassword 282
LongParm 116
LookUpDisplay() 216
low resolution 237
M
machine code 23, 51
main window 318
Manual 312
mask setting 246
masktype 247
master/detail setting 195
maximize
nonzero 300
maximize button 331
disabling 295, 299
maximized 300
MDI application
OpenSheet() 298
MDI frame 25, 274, 276, 297
client area 296
code example 296
Window painter 297
MDI Frame menu
inherited 301
MDI frame menu 295
MDI menu
communicating with sheets 296, 302
MDI window 296
mdiwindow 300
memory leaks 26
memory resident 14
menu bar 269
menu inheritance
problem 277
Menu painter 267, 273
menuid attribute 301
menus 267, 312, 331
cascaded 268, 270, 272
creating cascaded 271
creating for functionality 270
deleting items 269, 278
descendant properties 278
inheritance 276
invalid datatype 269, 275
Microsoft guidelines 268
saving 275
toolbar 269
toolbar does not appear 274
visible attribute 278
Message Object 83, 244
message.doubleparm 84
message.longparm 84
message.powerobjectparm 84
message.stringparm 84
message.wordparm 84
MicroHelp 300
Application Object 301
default value 301
value 301
MicroHelp bar 300
Microsoft
autocommit 289
Internet Explorer 3.x 330
Word 310, 313
middle tier 315, 317
migrate 45, 48, 49
migration 45
minimize 300
nonzero 300
minimize button
disabling 295, 299
modal dialog 25, 241
modal windows 26
Modify() 178
more button 282
Move() 81
MS SQL Server 285
multi-line edit control 259
multiple objects 56, 58
multiple rows 322
N
NamedPipes 334
Navigator 3.x 330
Netscape plug-ins 330
network 9
Network Install 12
new value 230
newindex 255
newindex value 255
NEWMODIFIED! 323
NEXT 93
Next Level icon 271
NONE 189
non-existent element 249
NonVisual Objects 229
NonVisual User 38
NonVisual User Object 27, 228, 317, 318, 320
NOTMODIFIED! 192, 324
n-tiered client/server 3
NULL 21, 334
structure 37
Null Object 48
Null Object reference 48, 119
NVOs 320
O
Object Browser 72
object linking and embedding 304
object's tag property 232
ObjectAtPointer() 217
NULL value 217
object-oriented
possibilities 30
programming 328
obsolete function error 45
OCX 306, 330
OCX control 305, 306, 307, 309
accessing 309
OCX registrations 306
ODBC 282
database 282
driver 280, 285
OFFSITE! 312
oldindex 255
OLE
2.0 306, 307
2.0 control 305, 309, 312, 313
container application 309
server application 309
OLE automation 305, 313
object attribute 313
OLE Object
initial properties 310
OLEControlname 309
OPEN 130
open event 24, 298, 331
open event script 319
OpenSheet()
arrangeopen argument 297
default values 297
OpenTab() 257
Oracle 285
order ID 36
ORIGINAL! 297
out-of-memory 51
P
painters 331
parameters
distributed PowerBuilder 335
PBWEB.INI 334
parent 91
ParentWindow 91, 301
passing data 244, 322
base ancestor window 245
structures 245
passing parameters 116
password 282, 287
coding for change 280, 288
encryption 283
paste statement 96
path 54, 329
PB.INI file 10, 283
PBLs 57, 59
pbm_keydown ID 186
pbm_keyup ID 186
PBR file 39, 190
PBRTE050.DLL 53
PBWEB.INI 334
P-Code 320
performance degradation 285
picklist 224
reusable 225
picture button 244
Pictures tab 273
pie chart 212
pie graph 218-219
platform 50
polymorphism xxv
post 113
PostEvent() 25
PowerBuilder 5
Code Table 182
database drivers 285
database functionality 285
distributed 315
Dynamic Libraries 331
5.0 249
library 61
native drivers 286
Object Searcher 60
and ODBC compliant drivers 285
painters, changing color 242
profile 15
Properties dialog 307
Runtime DLLs 334
SetColumn() 106
window plug-in 330
PowerObjectParm 84, 245
PowerScript 78, 130, 253
cursors 130
PowerSoft Report File 328
presentationstyle 197
preview mode 271
previewing 170
primary bands 146
primary key 152
primarydatawindowname 196
print jobs 199
Print() 198
printing
selecting a printer 198
printing a DataWindow 140, 198
printing headers 169
PrintOpen() 199
PrintSetup() 198
profiles 16, 280
adding 281
database drivers 285
database name 281
dialog 283
management system name 281
password 281
server name 281
user ID 281
ProfileString() 287
project 40
Project painter 40
creating the executable 42
first opened 41
pronouns 90, 91
parent 91
parentwindow 91
this 91
properties 307
changing as a group 166
properties dialog 260
PropertyName 309
Proxy Object 318, 320
stubs 318
PSR 328, 329, 330
PSREPORT! 329
PWD 283
Q
queries 161
query
by example 193
query mode 139, 193
R
radius 218
RAM 277
rebooting 14, 184
client 293
reference the window 332
regenerate 57, 67
Register New button 306
registration/download page 330
RegistryGet() 286
default values 287
remote DataStore 324
remote function 322, 324, 336
remote server 318, 324
resetting update flags 192
resize event 296, 297
resolutions 237
changing color 242
response windows 26
result set 184
retrieval arguments 153
retrieve as needed 184
Retrieve() 148, 159
RetrieveRow event 162
return 117
rewrite your code 47
Rich Text control 259
DataWindow painter 265
functions 261
properties 260
toolbar 260
versus Rich Text style 264
Rich Text edit control 259, 263
inserting data 259
Rich Text presentation style 265
Rich Text style 259, 264
right click 307
right clicking 311, 318
rollback 290
row menu 183
row not found 292
RowFocusChanged 96
rownumber xxiv
runtime 301
runtime DLL 23, 53
runtime library 71
S
Save event 250
save function 151
SaveAs() 328
SaveDocument() 261
scope 32
scope of global 31
screen resolutions 238
script
in a window 254
line number 89
outside a window 254
Script Editor 307
Script painter 223
search window 193
secondarydatawindow 196
segment 44
exceeds 64K 44
SELECT 211
selectedtab 255
selectionchanged event 255
argument 255
separator bar 275
series 218
server 316
application 310-318
function 322
root directory 333
server application 318
server function 322
Server setting 282
server-based application 320
server-side application 320
SetColumn 106
SetDataPieExplode() 218
SetMask() 246
SetMicroHelp() 300
SetNull() 37
SetPosition() function 241
SetProxyName 318
SetSysColors() 243
SetTrans() 135, 149
prototyping 156
purpose 155
SetTransObject() 135, 149
error 179
production code 156
purpose 155
shared variables
danger 33
defined 33
ShareData() 140, 195
syntax 195
sharing violation 69
sheets
communicating with MDI menu 296, 302
controlling user resizing 295
default sizing 298
does not appear 295
hidden controls 298
lower in frame 295, 298
original values 298
resizable 298
scrollbars 298
size 295, 296, 297
X position 298
Y position 298
signal error 89
single line edits 288
single return value 315, 322
single structure 35
16-bit
code 287
windows 198
applications 320
size 44
size exceeds 64K 22
Sockets 334
Source Control Interface 18
spin control 137, 172
increments/decrements 172
splash window 25
SQL 289, 323
select statement 197
update fails 191
user input 140, 196
SQL Server 288, 291
SQLCA 286
SQLCA Transaction Object 286
standalone applications 331
standard Visual User Object 222
startcolumn 194
startrow 194
status bar 296, 300
stock pictures 273
store 322
stored procedures 132
storing database information 280
storing startup information 31
str_mystructure 37
str_user 35
string literal 40
strings 323, 334
Structure painter 36
structures 21, 35, 245, 322
importance 36
NULL values 37
stubs 318
submenus 270
submit button 336
Sybase
autocommit 289
SQL Server 285
synch 324
synchronous processing 99
syntax 76
builder 178
system menus 299
systemerror 331
T
tab control 256
Tab Object 250, 253
tabbed dialog box 273
tabpagename 256
tabs
adding 257
deleting 257
at design time 257
at runtime 257
tag of type string 232
template 263
text 176
text editor 61
THEN 93
third-party add ons 306
32-bit
applications 320
code 287
programming 304, 306
three-tiered 321
approach 5
client/server 317
three-tiered client/server programming 315
timer 328, 329
timestamp column 280, 292, 293
update 292
value 292
WHERE clause 292
title bar 298
toolbar 296, 312
icon 273
toolbarvisible property 274
transaction 290
multi-statement 291
transaction information not available 190
Transaction Object 190, 286, 320
Transaction processing 288
Transport Object 319, 320
Tree Control 74
treecontrolname 75
trigger 113
triggered event 114
triggering code 228
True-Type fonts 237
two-tiered system 316
type 331
type popup 331
U
UID 283
UPDATE 152, 290
update 150, 192, 328
fails 191
flags 192, 323
properties 292
user events 110, 307
User Events Dialog 112
user functions 121
user ID 282
user interface 225
User Object 226, 244, 250
User Object DataWindow 231
User Object dialog 222
User Object painter 229, 257, 317
dberror event 223
new code 223
rollbacks 223
User Object tab control 254
user profile 229
user's name 30
user-defined function 121, 322, 332
V
validation error 176
valuename 286
valuevariable 240, 286
variable name 90
variablename 33
variables 321
avoiding conflicts 49
constant 21, 31
differences 32
global 21, 25, 29, 49, 244
instance 32, 49, 229, 249, 255
local 34
scope of 32
shared 33
VBX controls 306
Verify 166
visible attribute 278
Visual Basic 6, 304
Visual-Standard 222
W
web browser 327, 328, 330
Microsoft's Internet Explorer 3.0 328
Netscape's Navigator 3.0 328
Web.PB 335
web server software 333
Web.PB 327, 332
application limitations 334
files 333
WHERE 154, 264, 293
timestamp column 292
WHILE 93
wild card mask characters 170
win.ini 198
window 254
plug-in 330, 331
position 237, 239, 241
position, RegistryGet() 239
position, RegistrySet() 239
position, SetPosition() 241
stay on top 241
too small 297
window.pbl 65
windowname 61, 240
Windows
close event 331
command button limitations 244
Windows 3.1 23
Windows 3.x 9, 50, 51, 287
Windows 95 27, 50, 198
registry 286
Windows API 123
Windows NT 198
Word document 310
word processing capabilities 264
WordBasic 313
WordParm 116
wordparm element 299
X
X-axis 211
Y
Y-axis 211
Yield() 163