Application Development


A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

Index

Symbols

% (percent sign)
in message file 44-8
%A
display attributes in messages 44-9
%B
bell for messages 44-10
%K
key label in message 44-11
%Md
force user acknowledgment of messages 44-11
%Mu
acknowledgment of error messages 44-12
%N
carriage returns in messages 44-12
%W
pop-up window for messages 44-12
:+ (colon-plus processing) 29-2
:: (parameters)
in DECLARE CURSOR command 29-11
:= (colon-equal processing) 29-8
@ (at)
to reference database driver variable 36-4
@date
defining format for 44-19
in JPL 19-52
@length
in JPL 19-52
@range 38-26
@sum
in JPL 19-53
@tm_sel_cursor
default select cursor name 27-8

A

ActiveX Control
event handler
in Java 21-6
ActiveX controls
manipulating at runtime 22-14
Aggregate functions
aliasing to widgets 28-6
in automated SQL generation 32-17
ALIAS
dbms command
aliasing column names 28-4
Aliasing
colors 44-27
column names to widgets 28-4
Alphabetic data
range checking 47-4
Animation 38-8, 38-20
Application
customizing 42-7
debugging 38-19
defining project requirements 3-1
exiting base form 23-3
menu
attaching 15-4
optimizing 40-1
packaging checklist E-2
Windows E-2
specifying splash screen for 42-8
specifying startup file 42-8
Application architecture 1-2
defining 4-1
Application behavior
understanding events 17-1
Application components
building 1-13
integrating 1-21
referencing 19-33
with object modifiers 19-34
Application data 44-45
Application Data option
in debugger 38-9
Application development
accessing the database 26-1, 27-1
defining the project team 1-3
defining the requirements 1-2
development environment 1-6
programming application events 1-17
steps 1-2
with the transaction manager 30-2
Application messages 44-6
header file A-34
Application server
preparing 1-4, 5-1
Array
accessing in JPL 19-40
clearing all data 22-9
in transaction manager 35-10
defining 14-5
deleting occurrence 22-9
elements 14-4
inserting occurrence 22-9
numbering 14-6
scrolling 14-6
setting array size 14-6
sum of occurrences 19-53
ASC keyword
specifying data order 32-21
ASCII
non-ASCII display 44-45
ASCII output
menus A-22
reports A-12
screens A-12
service components A-12
Auto Raise/Close 38-8
Automatic functions
defined 43-2
example 43-71, 43-79
installing
field function 43-20
group function 43-28
screen function 43-13
screen function 17-8

B

Background status
displaying 25-9
Backward scrolling
viewing database rows 28-12
Base form
exiting 23-3
Basic colors
keywords 44-28
Before image processing
modifying data in transaction manager 35-7, 35-27
Bell
setting in messages 44-10
bin2c A-2
bin2hex A-4
Binary columns
writing to database 29-11
Binding
supplying database column values 27-6, 29-11
binherit A-6
Bitwise expression 19-55
Bitwise operators 19-53
Breakpoint
clearing 38-21
listing of 38-5
setting 38-20
setting in JPL 38-15
setting on event
setting on event 38-23
sorting 38-10
specifying location 38-24
Breaks menu
for debugger breakpoints 38-11
Built-in control functions 18-7

C

C functions
calling 20-6
executing from control string 18-5
linking to executable 20-4, 41-5
writing your own 20-1
C Type property 29-4
formatting fetched data 28-16
writing values to database
character strings 29-10
hexadecimal strings 29-11
numeric data 29-7
Calling JPL procedure
as hook function 19-21
from control string 19-22
through call command 19-23
within expression 19-23
Carriage return
in message
%N 44-12
Case sensitivity
alias names 28-5
column names 7-4, 7-8
connection names 8-3
cursor names 27-5
engine names 7-4, 7-8
specifying for library members A-17
widget names 28-3
CATQUERY
dbms command
writing results to widget or file 28-19
Character data
8-bit 44-45
Character strings
reading from database 28-15
writing to database 29-6, 29-10
Character-mode Prolifics
setting line and box style in cmap file 44-34
Check box widget
event handler
in Java 21-6
Check digit function 43-40
return codes 43-40
Check Out 10-6
Child property
determining child table view 30-8
Class property 35-14
Client
configuring environment of 6-1
Client authentication
installing data function 43-29
installing post-connection function 43-31
Client executables 41-1
Client library 1-13
Clients
building screens for 13-1
CLOSE CONNECTION
dbms command
closing database connections 8-4
CLOSE CURSOR
dbms command
closing database cursor 27-9
Close Item property 13-2
CLOSE_ALL_CONNECTIONS
dbms command
closing database connections 8-5
Closing
screens 13-7
cmap2bin A-9
Colon preprocessing 19-28, 29-1
colon equal 29-8
colon plus 29-2
examples 29-8
substring specifier 19-30
Color properties
aliasing colors 44-27
display attributes
keywords 44-28
highlighted colors
in Windows 44-28
Prolifics basic colors
keywords 44-28
Color terminal
display attributes in messages 44-9
Column Edits subproperties 11-7
Column Name property 32-3
in automated SQL generation 32-10, 32-33, 32-36
Column Titles property 30-13
COM components
deploying 1-6
Combo box widget
event handler
in Java 21-7
Comments
in JPL 19-5
COMMIT
dbms command
committing transactions 27-10
Common library 1-14
Configuration
converting message files A-29
of debugger 38-6
setting up development clients 6-1
Configuration map file
aliasing colors 44-27
colors section 44-27
converting to binary A-9
defining default fonts 44-37
making memory-resident 41-12
object specification keywords 44-32
scheme section 44-31
Connecting
to JetNet via the request broker 9-3
CONNECTION
dbms command
setting database connection 8-4
Constants in JPL 19-32
Continuation character 19-4
Continuation file
scrolling through select set 28-12
specifying
in the transaction manager 35-5
CONTINUE
dbms command
fetching next set of rows 28-11
Control flow
in JPL 19-4
Control function 43-44
example 43-103
return codes 43-45
standard argument 43-44
Control string
calling JPL 18-5, 19-22
executing function from 18-5
executing OS command from 18-8
getting information in debugger 38-18
target string in 18-6
Control Strings property 18-2
Conversion utilities
bin2c
bin2hex A-2
bin2hex A-4
cmap2bin A-9
f2asc A-12
jif2asc A-19
jpl2bin A-20
m2asc A-22
message files to binary (msg2bin) A-29
styles file to/from ASCII
s2asc A-40
Count Select property 35-6
Count Threshold property 35-6
Creating
repository 11-3
service components 12-1
Currency format 44-20
default entries in message file 44-21
fetching from database 28-16
writing to database
colon-plus processing 29-7
Cursor
changing delay state 46-9
position
after check digit function 43-40
after field validation 43-20
after group validation 43-28
displaying 25-7, 25-9
Cursor (database) 27-3
closing 8-4, 27-9
declaring 27-4, 29-11
redeclaring 27-8
in transaction manager 27-8
using bind values 27-6, 29-11
using colon expansion 27-5
using the default 27-3

D

Data
displaying
displaying in arrays
in arrays 14-6
modifying
in the transaction manager 35-7
selecting
in the transaction manager 35-3
using a database driver 28-1
with warning message 35-6
writing to a database 29-1
Data Formatting property
formatting fetched data 28-16
using in database updates 29-5
Data Watch option 38-5
sorting variables
in debugger 38-10
Database
accessing 26-2
designing schema 3-3
using in Panther 26-1
Database access 1-3, 1-6
Database columns
aliasing to widgets 28-4
automatic mapping to widgets 28-3
importing to a repository 11-5
in automated SQL generation 32-3, 32-10, 32-33, 32-36
Database connections
closing 8-3, 8-4
declaring 8-3
setting current 8-4
setting default 8-4
Database drivers
accessing 8-2
initializing 7-2
in Windows 7-7
selecting data 28-1
setting current 8-4
setting default 8-4
writing to a database 29-1
Database engines
adding support for an engine 7-6
initializing 7-2
in Windows 7-7
setting current 7-3
setting default 7-3
viewing error messages 36-4
Database events
trace warning in debugger 38-8
Database information
importing into Panther 1-13
Database properties
for SQL generator 32-4
Database version
identify in executable 41-5
Databases
importing database to a repository 11-5
reading information from 28-1
transaction processing 27-10
writing information to 29-1
Date
using in JPL expressions
JPL @date operator 19-52
Date/time format
customizing 44-13
defaults 44-13
fetching from database 28-15
for non-English applications 44-17
literal format for @date calculations 44-19
tokens 44-14
writing to database 29-9
colon-plus processing 29-6
DB Interactions window
viewing transaction tree 30-10
dbiinit.c
creating new 7-6
DBUG key (debug) 38-4
DDE
callback function 45-9
cold links
creating for Prolifics client 45-7
updated from Prolifics server 45-4
cold paste links
creating for Prolifics client 45-6
destroying links on Prolifics client 45-9
disabling Prolifics as server 45-5
enabling Prolifics as client 45-6
enabling Prolifics as server 45-2
executing command from Prolifics client 45-10
executing command on Prolifics server 45-10
hot links
creating for Prolifics client 45-6
specifying in initialization file 45-7
updated from Prolifics server 45-4
hot paste links
creating for Prolifics client 45-6
links
created on Prolifics server 45-2
creating for Prolifics client 45-6
specifying in initialization file 45-7
updated from Prolifics server 45-4
paste links
creating for Prolifics client 45-6
poking data from Prolifics client 45-10
poking data into Prolifics server 45-11
requesting link data 45-8
updating Prolifics client data 45-8
warm links
creating for Prolifics client 45-7
updated from Prolifics server 45-4
warm paste links
creating for Prolifics client 45-6
Debuggable server
in JetNet applications 38-2
Debugger 37-2
accessing 38-3
from Test mode 37-6, 37-7, 37-8
animation 38-8, 38-20
Application Data window 38-27
calling a function 38-9
calling a function on breakpoint 38-26
configuring 38-6
Data Watch window 38-26
enabling in screen editor 38-3
exiting 38-4
expert mode 38-8, 38-23
menu bar 38-8
module browsing 38-12
saving preferences 38-7
View menu 38-4
viewing control string assignments 38-18
viewing JPL 38-11
Decimal symbol
setting default 44-23
DECLARE CONNECTION
dbms command
making database connection 8-3
DECLARE CURSOR
dbms command
creating database cursor 29-11
using bind values 27-6, 29-11
using colon expansion 27-5
DECLARE CURSOR dbms command
creating database cursor 27-5
Delay cursor 46-9
Delete Order property
in automated SQL generation 32-38
Delete Service property 32-5
DELETE statement
SQL generation from properties 32-38
Demand functions
example 43-76
installing
field function 43-20
group function 43-28
screen function 43-13
Deployment
directory structure E-1
DESC keyword
specifying data order 32-21
Dialog property 13-2
Display area
size for portability 47-2
Display attributes
keywords 44-28
portability 47-2
setting
in messages 44-8
in status line 44-9
Distinct property 32-13
Distribution
directories defined 2-1
Duplicate rows
eliminating 32-13
Dynamic label widget
event handler
in Java 21-7

E

Edit menu
in debugger 38-10
Editor
invoking from JPL dialog box 19-17
using 1-15
Elements
numbering 14-6
ENGINE dbms command
setting database engine 7-3
Enterprise Java Beans
service components for 12-5
Entry Function property
screen 17-8
Environment setup
development clients 6-1
Error function 43-37
example 43-94
return codes 43-38
standard arguments 43-38
Error handling 25-1
installing database error handler 36-9
Error hook function 25-9
Error messages
acknowledgment 44-11
disabling display of 25-2
Error messages (database) 36-1, 36-2
customized processing 36-6
default processing 36-2
engine-specific messages 36-4
error handler 36-7
exit handler 36-7
generic database driver messages 36-4
installing error handler 36-6, 36-9
transaction error handling 27-12
transaction hook functions 31-4
warning codes 36-4
Event function arguments
client authentication connection 43-29
client authentication post-connection 43-31
control 43-44
error 43-38
field 43-16
grid 43-21
group 43-27
initialization 43-42
key change 43-36
playback 43-43
record 43-43
reset 43-42
screen 43-11
tab control 43-25
timeout 43-34
transaction manager 43-50
video processing 43-47
Event function return codes
transaction manager 31-3
Event function types
transaction manager 31-1
Event functions
in the transaction manager 30-15
programming for 1-17
transaction manager 31-1
Event handlers
in Java 21-4
Event stack
for transaction manager 34-7
in debugger 38-5
Events
in Panther applications 17-1
setting breakpoints on 38-21
user-initiated 17-22
Executables
building 41-1
including your C functions 20-1
renaming 41-6
EXECUTE
dbms command
executing statement 27-5
Exit
debugger 38-4
Exiting Panther 37-8
Expert mode 38-8, 38-19
Extended colors
aliasing colors 44-27
External menu 15-6

F

f2asc
generating ASCII output A-12
Fetch data properties 32-10
Fetch Directions property 35-6
Field
characteristics
internationalization 47-3
decimal symbol 44-24
displaying status of 25-8
getting current field number 14-3
getting screen's amount of 13-8
Field data
clearing all fields 22-9
clearing from array 22-9
getting length 19-52, 22-7
reading 22-6
testing
all fields for changes 22-16
for yes value 22-7
if null 22-7
testing for no value 22-7
writing 22-8
Field function 43-14
example of automatic function 43-71
example of demand function 43-76
passing non-standard arguments into 43-74
return codes 43-19
standard arguments 43-16
Field number
assignment 14-4
Field validation 22-15
causes 43-15
File
required in deployment 42-4
File locking A-17
Font
setting display default 44-37
Force Valid property 32-12
Foreign keys
enforcing with validation link 32-47
Form
opening 13-3
Form stack 23-2
FORMAT
dbms command
formatting result set 28-19
Formatting text
for a database 29-13
from a database 28-15
formlib
with -g option 10-5
Function keys
associating with control string 18-2
setting default behavior 18-2

G

Global JPL variable
declaring 19-26
Grid function 43-21
return codes 43-24
standard arguments 43-21
Grid widgets
event handler
in Java 21-8
Group
converting to field number 14-9
getting information in debugger 38-17
getting name from field reference 14-9
getting screen's amount of 13-8
identifying members of 22-3
validation 43-27
GROUP BY clause
in automated SQL generation 32-17
Group By property 32-17
Group function 43-26
example of automatic function 43-79
return codes 43-28
standard arguments 43-27
Group widgets
event handler
in Java 21-9

H

HAVING clause
in automated SQL generation 32-20
Having property
in automated SQL generation 32-20
Header file
creating A-34
sample A-35
Help function 43-33
example 43-82
return codes 43-33
Hexadecimal strings
writing to database 29-7, 29-11
Hidden property
and version columns 32-41
Hook functions
invoking 19-21

I

Icon
for application 41-9
Import
of database objects to a repository 11-5
In Delete Where property 32-41
in automated SQL generation 32-41
IN keyword
in automated SQL generation 32-16
In Update Where property 32-41
in automated SQL generation 32-41
Included JPL modules 19-5
Infinite loops
breaking out in debugger 38-4
Inhe·it menu option 11-10
Inherit From property
removing specification 11-10
Inheritance 1-15, 11-9
ensuring 11-2
preventing propagation 11-9
propagating to screen (binherit) A-6
source
finding 11-10
Initialization
database engines 7-2
Initialization function 43-41
example 43-96
return codes 43-42
standard argument 43-42
Insert Service property 32-5
INSERT statement
SQL generation from properties 32-32, 32-44
Insert toggle function 43-39
example 43-95
return codes 43-39
Installed function return codes
check digit 43-40
client authentication connection 43-30
control 43-45
error 43-38
field 43-19
grid 43-24
group 43-28
help 43-33
initialization 43-42
insert toggle 43-39
key change 43-37
playback 43-43
record 43-43
reset 43-42
screen 43-13
status line 43-46
timeout 43-35
transaction manager 43-50
video processing 43-49
Installed function types
check digit 43-40
client authentication connection 43-29
client authentication post-connection 43-31
control 43-44
database driver errors 43-49
error 43-37
field 43-14
grid 43-21
group 43-26
help 43-33
initialization 43-41
insert toggle 43-39
key change 43-36
playback 43-43
prototyped 43-8
record 43-43
reset 43-41
screen 43-11
status line 43-46
tab control 43-25
timeout 43-34
transaction manager 43-50
video processing 43-47
Installed functions
automatic 43-2
installing 43-4
standard arguments 43-3
Interface
three-tier
between client and server 1-7
Internationalization
8-bit characters 44-45
alternate message files 44-25
currency formats 44-20
decimal symbol 44-23
keystroke filters 47-3
library functions 44-44
of application screens 44-46
range checks 47-4
yes/no values 44-25
Interrupt handler 43-41

J

Java
event handler interfaces 21-4
implementing event handlers 21-1
sample 21-18
samples C-1
setting environment variables 21-2
Java Tag property 21-2
JetNet
connecting to
via the request broker 9-3
creating service components 12-1
using with transaction manager 34-12
JIF
defining service availability 1-9
jif2asc A-19
jmain.c 41-7
Join 32-23
implementing
full outer join 32-30
inner join 32-29
left outer join 32-30
right outer join 32-31
Join Type property 32-28
JPL
choosing an editor 19-17
comments 19-5
constants 19-32
control flow 19-4
memory-resident 41-10
null statement 19-5
optimizing performance 19-56
setting breakpoint in 38-15
validation 19-8
viewing with debugger 38-11, 38-26
JPL calls
from control string 18-5, 19-22
from screen 19-21
from screen and report 19-14
from widget 19-21
inline calls 19-23
return value 19-20
search order 19-24
JPL commands
arguments 19-56
JPL expression
bitwise 19-55
numeric 19-54
numeric format 19-54
operand conversion 19-50
specifying substring in variable 19-51
string 19-54
JPL module 19-1
accessing with debugger 38-11, 38-12
compiling A-20
continuation character 19-4
include module 19-5
library modules 19-11, 19-16
line length 19-4
loading as public 17-6
memory-resident 19-13
named procedure 19-2
screen
screen module 19-9
storing in library 19-11
types 19-8
unnamed procedure 19-2
widget validation 19-8
JPL operators 19-48
@date 19-52
@length 19-52
@sum 19-53
bitwise 19-53
concatenation 19-51
precedence 19-49
substring specifier 19-51
JPL procedure 19-1
attaching to screen and report 19-14
attaching to widget 19-16
declaring parameters 19-2
declaring return type 19-4
execution 19-4
named 19-2
returning from 19-20
unnamed 19-2
JPL text dialog box
compiling and saving 19-18
invoking local editor 19-17
JPL variable 19-24
declaring 19-25
global 19-26
expanding to literal value 19-28
resolving name ambiguity 19-38
scope and lifetime 19-27
substring specifier 19-51
watching through debugger 38-9, 38-26
jpl2bin A-20
Jterm
enabling data compression 41-13

K

K_ENTRY
set on field entry 43-17
set on grid frame entry 43-22
set on screen entry 43-12
set on tab card entry 43-26
K_EXIT flag
set on field exit 43-17
set on grid frame exit 43-22
set on screen exit 43-12
set on tab card exit 43-26
K_EXPOSE flag
set on screen exposure 43-12
K_KEYS bitmask 43-12, 43-18, 43-22
Key change function 43-36
example 43-91
return codes 43-37
standard argument 43-36
Key label
displaying in messages 44-11
portability 47-3
Key translation
internationalization 44-45
portability 47-3
Key translation file
making memory-resident 41-12
Keyboard
portability 47-3
Keystroke Filter property
translation support
47-3
using in database updates 29-5
using to format database values 29-9, 29-10

L

LDB 24-7
loading
multiple instances of 24-10
popping 24-11
Length property
defined in database 11-7
Library
lock on 10-7
making read-only A-18
set file locking scheme A-17
storing JPL modules 19-12
synchronize with source code management A-18
under source control management 10-4
Library JPL module 19-16
Line length of JPL statement 19-4
Line styles
names of 44-34
setting in cmap file 44-34
Link widget
relationship properties 32-23
Links 30-7
in automated SQL generation 32-22
setting child table view 30-8
setting parent table view 30-8
setting the link type 30-9
validation 30-13, 32-46, 32-47
adding lookup 32-48
enforcing foreign keys 32-47
List box widget
event handler
in Java 21-9
Local decimal symbol 44-23
Lock
on library/repository 10-7
Lock files A-17
Log file
debugger 38-6
writing to 38-10
Logical key
invoking control string from 18-2
Lookup specification 32-49
in Relations dialog box 32-48

M

m2asc A-22
makefile
list 41-3
makevars 41-4, 41-5
MDI
with dockable toolbars 15-10
MDI frame
in Windows applications 13-6
MDT bit 22-16
clearing for all fields 22-16
testing to find first modified field 22-16
Memory-resident
JPL modules 19-13, 41-10
screens 41-10
Menu
ASCII/binary conversion A-22
creating at runtime 15-11
definition 15-1
deleting at runtime 15-11
deleting items at runtime 15-12
displaying as toolbar 15-1, 15-7
external reference 15-6
inserting items at runtime 15-12
installing 15-3
for application 15-4
for screen 15-4
for widget 15-4
unique instances of 15-6
loading script into memory 15-2
pop-up for field
invoking 15-13
removing from display 15-12
scope assignment and display 15-4
testing 37-8
Menu bar
in application mode 37-2
Menu item
displaying status of 25-8
Menu Name property 15-4
Menu runtime properties 15-9
Menu script
loading into memory 15-2
unloading from memory 15-12
Menu Script File property 15-2
Message
acknowledgment 25-2, 44-12
forcing 44-11
bell 44-10
creating 44-5
default display
in status line 25-1
in window 25-1
disabling display of 25-2
display attributes in 44-8, 44-9
hexadecimal codes for 44-9
displaying
background status 25-9
in window 44-12
on status line 25-8
error 25-1
forcing to status line
automatic dismissal 44-12
functions for displaying 25-4
key labels in 44-11
multiple lines in 44-12
Prolifics-specific 44-4
send via request broker 9-2
Message file 44-2
converting to binary (msg2bin) A-29
making memory-resident 41-12
modifying 44-2
multiple sections 44-6
size 44-6
syntax 44-4
text 44-5
translating 44-2
using alternate 44-25
Method property 35-7, 35-11
Middleware
connecting to 9-1
connecting to the 1-7
Module type
specifying in debugger 38-14
Monochrome terminal 44-9
Motif
deploying application E-4
Motif resource file
specifying 42-8
splash screen 42-8
Mouse events
getting name of last clicked-on field 46-5
getting name of last clicked-on screen 46-6
getting state of buttons 46-6
msg2bin
errors A-30
msg2hdr A-34
errors A-35
sample output A-35
MTS
creating service components 12-8
Multi-item properties
Multi-item properties
accessing in JPL 19-42
Multiple sections
in message file 44-6
Multi-user access 10-3

N

NCARD key (next card) 22-13
Null edit
colon-equal processing 29-8
writing null value to database 29-4, 29-9
Null Field property
in automated SQL generation 32-17
writing null values to database 29-4, 29-9
Null statement in JPL 19-5
Null value
writing to database 29-4, 29-9
Numbering
in arrays 14-6
Numeric data
range checking 47-4
reading from database 28-16
writing to database 29-7
Numeric expression
JPL 19-54
Numeric format
JPL 19-54

O

Object identifier
for widgets 14-3
OCCUR
dbms command
setting occurrence for SELECT 28-14
Occurrence
deleting 22-9
inserting 22-9
numbering 14-6
setting the number of 14-6
ONENTRY dbms command
calling function before dbms command 36-7
ONERROR dbms command
installing error handler 36-7
ONEXIT dbms command
calling function after dbms command 36-7
Opening
screens 13-3
Operands
conversion in JPL 19-50
Operating system
accessing from control string 18-8
Operator property 32-15
in automated SQL generation
32-15
Operators
JPL
JPL operators 19-48
supported in WHERE clause 32-14
Optimistic locking
property settings 32-39
Option menu widget
event handler
in Java 21-10
ORDER BY clause
in automated SQL generation 32-21
Output processing
messages 25-8

P

Panther
description 1-1
description of directories 2-1
Panther executables
building 41-1
including your C functions 20-1
modifying 41-7
Parameters
declaring in JPL 19-2
for binding
in DECLARE CURSOR command 27-6, 29-11
Parent object
turning inheritance on/off for specific properties 11-9
Parent property
determining parent table view 30-8
Partial command 33-6
PCARD key (previous card) 22-13
Pending keys 38-6
Percent escapes
in JPL message commands
in message commands 25-3
in message file 44-8
Playback function 43-43
example 43-98
return codes 43-43
standard argument 43-43
Pop-up menu
invoking 15-13
Popup Menu property
screens 15-4
widgets 15-4
Portability 47-1
aliasing colors 44-27
smmach.h 47-1
Precision
in SELECT results 28-16
Preferences
saving in debugger 38-7
saving preferences
for debugger 38-9
setting in debugger 38-6
Primary Key property
in automated SQL generation 32-37
Primary keys
updating
with transaction manager 35-9
Programming
modifying property values 1-16
sharing data 1-21
using application events 1-17
Project
defining requirements 3-1
Project requirements 1-2
defining the project team 1-3
Prolifics basic colors
keywords 44-28
Prolifics type
character strings
fetching from database 28-15
writing to database 29-6, 29-8
converting to C type 29-4
currency formats
writing to database 29-5, 29-7
date and time formats
fetching from database 28-15
writing to database 29-5, 29-6, 29-9
hexadecimal strings
writing to database 29-7
numeric data
fetching from database 28-16
writing to database 29-7, 29-10
using to format selected data 28-15
Properties
accessing in JPL 19-40
application properties 19-41
multi-item properties
multi-item properties 19-42
runtime properties 19-41
substring of setting 19-42
for dockable toolbars 15-10
for screens
runtime only 13-8
getting at runtime
for menus 15-9
setting at runtime
for menus 15-9
transaction manager 35-19, 35-26
traversal 35-19
value types 19-42
Prototyped function 43-8
examples 43-52
get standard arguments 43-9
valid prototypes 43-10
Public module
loading 17-6
Push button widget
event handler
in Java 21-10
PVCS support 10-1

R

Radio button widget
event handler
in Java 21-11
Range
checking 47-4
Read-only library A-18
Read-only screen
saving 10-8
Ready/Wait status
displaying 25-8
Receive data
reading bundle data 24-4
Record function 43-43
example 43-98
return codes 43-43
standard argument 43-43
Regenerate SQL property 35-11
Relations property 32-23, 35-5
in automated SQL generation 32-27
Report
JPL 19-14
Reports
ASCII/binary conversion A-12
overview 16-1
overview of 1-19
Repository
benefits 11-1
copying objects
for transaction manager 30-3
for application development 1-14
from a database
build with 1-11
importing database objects 11-5
lock on 10-7
making read-only A-18
screen wizard entries 11-8
set file locking scheme A-17
storing screen templates 11-5
synchronize with source code management A-18
under source control management 10-4
Request broker 9-1
Request broker event handlers
defined 17-25
Request events
in transaction manager 34-3
Reservation
releasing 10-4
Reset function 43-41
example 43-96
return codes 43-42
standard argument 43-42
Return codes
transaction event functions 31-3
Return value 19-20
declaring type in JPL 19-4
Revision control 10-7
ROLLBACK
dbms command
engine-specific behavior
rolling back transactions 27-10, 27-12
Root table view
in the transaction manager 30-8
Row Titles property 30-13
Rows
determining number fetched 28-8
retrieving multiple rows 28-8
scrolling through result set 28-12
setting maximum number 35-6
Runtime properties
accessing in JPL 19-40

S

s2asc A-40
Sample applications
Java 21-18
Samples
two-tier application
VideoBiz B-1
using Java in Panther C-1
SAVE
transaction manager command
saving database changes 31-9
Scale property
defined in database 11-7
Scale widget
event handler
in Java 21-11
SCCS support 10-1
Scheme
defining in configuration map file 44-31
object names for color mapping 44-32
Screen
about 13-1
as a dialog box 13-2
ASCII/binary conversion A-12
C data structure conversion A-2
calls to JPL from 19-21
closing 13-7, 37-8
control string 18-2
creating
screen templates 11-5
deleting under source control 10-9
display defaults 13-4
overriding 13-5
entry processing 17-4
event handler
in Java 21-5
hexadecimal conversion A-4
identifying members of 22-3
JPL 19-14
JPL module 19-9
memory-resident 41-10
menu
attaching 15-4
naming start up 41-8
opening 13-3
as a form 13-3, 23-2
as a sibling window 23-4
as a window 13-3, 23-3
at specific size/dimension 13-5
from control string 18-3
pop-up menu
attaching 15-4
read-only 10-7
saving 10-8
reserving 10-3
setting properties 13-8
status line text 25-9
testing 37-4
viewing in debugger 38-16
viewport 13-4
Screen editor
accessing from within Prolifics 37-2
exiting 37-8
Screen entry 17-4
executing screen's unnamed procedure 17-6
Screen events 17-2
Screen function 43-11
example of automatic function 43-67
return codes 43-13
standard arguments 43-11
Screen module 19-9
viewing in debugger 38-16
Screen properties 13-7
number of fields 13-8
number of groups 13-8
runtime only 13-8
Screen wizard
description 1-15
Screens
creating 1-15
Scrolling
specifying backward scrolling 28-12
Select Service property 32-5
SELECT statement
aliasing columns to widgets 28-4
automatic mapping of column names 28-3
changing generated SQL 35-6
concatenating result row 28-19
destination of 28-3, 28-19
aggregate functions 28-6
formatting result set 28-15
generating SQL 35-3
scrolling through result set 28-8
specifying multiple tables
in automated SQL generation 32-22
SQL generation from properties 32-7, 32-43
suppressing repeating values 28-17
transaction manager
writing hook function 31-6
unique column values 28-17
writing results
to a file 28-19
to a specific occurrence 28-8, 28-14
to word-wrapped arrays 28-8
Selection group
deselecting 22-12
getting selection data 22-10
identifying members of 14-8
selecting 22-12
testing for selection 22-10
Self-joins
in automated SQL generation 32-24
in the transaction manager 30-8
Send data 24-1
reading bundle data 24-4
writing data to bundle 24-2
Sequential link
in data fetches 35-5
setting the link type 30-9
Sequential link type
in automated SQL generation 32-26
join specification 32-23
Server executables 41-1
Server library 1-14
Server link
setting the link type 30-9
Server link type
join relationship 32-23
Server views
traversal properties 35-21
Service
debugging 38-2
Service components
ASCII/binary conversion A-12
building 1-7
creating 12-1
for EJBs 12-5
in JetNet 12-1
in MTS 12-8
in TUXEDO 12-1
Service container
debugging 38-2
Service properties
link widgets 32-47
table view 32-5
Service request
via request broker 9-2
Service requests
finding the transaction manager operation 35-27
SET clause
in automated SQL generation 32-37
Set Valid property 32-12
Sibling property 23-4
Sibling window
setting for next window 23-4
Single line text widget
event handler
in Java 21-13
Slice events
in transaction manager 34-3
SM_CALC_DATE
setting default format 44-19
SM_DECIMAL
setting default 44-23
smmach.h 47-1
SMMSGS
setting alternate value 44-19, 44-25
Sort Widgets property
in automated SQL generation 32-21
Source code
main routines
modifying 41-7
platform-dependent 47-1
Source code management
synchronizing library A-18
Source Code menu option
in debugger 38-4
Source control management
accessing screen outside of 10-3
deleting screens under 10-9
features of 10-6
setting up 10-5
Source Mgmt
in the editor 10-6
Splash screen 42-8
SQL
automated 32-1
setting properties for 32-4
constructing SQL statements 27-1
modifying automated SQL 31-1, 32-31
sending to database 26-2
viewing generated SQL 35-2
viewing generated statements 32-43
SQL generator 32-1
modifying automated SQL 32-31
SQL statements
declaring cursors for 27-4
Standard arguments 43-3
client authentication connection function 43-29
client authentication post-connection function 43-31
control function 43-44
error function 43-38
field function 43-16
grid function 43-21
group function 43-27
initialization function 43-42
key change function 43-36
passing into unnamed procedure 19-3
playback function 43-43
prototyped function
getting for 43-9
record function 43-43
reset function 43-42
screen function 43-11
tab control function 43-25
timeout function 43-34
types 19-21
video processing function 43-47
START
dbms command
setting starting row 28-15
Startup file 42-8
Startup screen 41-8
Status
determining in debugger 38-4
Status line
default message
overriding 25-8
message functions 25-4
message priority 25-8
message types 25-8
terminal
portability 47-2
text
background 25-9
for screen 25-9
for widget 25-8
Status line function 43-46
example 43-119
return codes 43-46
STORE
dbms command
setting continuation file
setting continuation file 28-12
String
getting length 19-52
String expression
JPL 19-54
Substring specifier 19-51
colon variables 19-30
Support routine
Database drivers 7-1
database engines 7-4
Synchronization property 35-8
System decimal
defining symbol 44-23
interpreting 44-44

T

Tab card widget
event handler
in Java 21-12
Tab control function 43-25
standard arguments 43-25
Tab controls
about 22-13
getting the number of cards 22-13
setting the card sequence 22-13
setting the topmost card 22-13
Table property
table view
in automated SQL generation 32-14
Table views 30-7
adding a virtual column 30-11
adding members to 30-11
identifying as root 30-8
limiting through commands 33-5
properties for SQL generation 32-2, 32-4, 32-14
setting child table view 30-8
setting parent table view 30-8
traversal properties 35-21
viewing properties 30-8
Tables
in automated SQL generation 32-2, 32-14, 32-36
joining multiple 32-22
storing in repository 11-5
Target string 18-6
Terminal
bell
in message 44-10
portability 47-2
status line 25-7
Test mode 37-4
exiting 37-8
menu bar 37-1
vs. application mode 37-5
Testing
overview of 1-24
Text
entry widgets
event handler
in Java 21-13
formatting for a database 29-1
Text editor
invoking for JPL procedures 19-14
Three-tier applications 4-1
Three-tier architecture 1-3, 26-5
Timeout
server configuration 38-3
Timeout function 43-34
example 43-90
return codes 43-35
standard arguments 43-34
Toggle button widget
event handler
in Java 21-13
Toolbar 15-7
displaying 15-1
setting runtime properties 15-10
Top Screen option 37-2
Trace menu
in debugger 38-11
Transaction
error handling 27-12
processing database transactions 27-10
Transaction classes
defaults
widgets 35-14
Transaction events
adding to the stack 34-10
after an error 35-29
controlling the event stack 34-9
unsupported 31-6
Transaction manager
and debugger 38-8
before image processing 35-7
changing the transaction mode 30-14
closing a screen 35-2
commands 33-2
copying from repository 30-3
determining sequence 30-4
creating screens for 30-1
deleting data 35-9
development process for 30-2
disabling 35-3
error processing
controlling display 35-30
event functions 31-1
checking for database errors 31-4
DELETE statement 31-9
INSERT statement 31-9
SELECT statement 31-6
specifying return codes 31-3
UPDATE statement 31-9
event stack 34-7
fetching data 35-3
for update 35-8
with a maximum row count 35-6
generating SQL 1-18, 26-2
hook functions
return codes 43-50
standard arguments 43-50
in JetNet applications 34-12
initiating a transaction 17-7
intstalled event functions 43-50
opening a screen 35-2
processing at runtime 35-1
processing events 34-1
restrictions 33-2
specifying commands 30-13, 33-4
SQL generation 32-3
tree traversal 30-10
using in Panther 26-2
verifying changes 35-11
viewing generated SQL 35-2
writing event functions 30-15
Transaction manager commands 33-2
availability by mode 33-7
processing for 34-3
specifying full commands 33-6
specifying partial commands 33-6
Transaction mode 35-12
availability of commands 33-7
Transaction model 34-5
for JetNet 34-13
initializing 7-2
return codes 31-3
specifying in Windows 7-8
Transaction styles
ASCII A-40
converting to/from ASCII A-40
defaults 35-14
report
s2asc A-40
Translating 44-44
message file 44-2
substitution variables 44-17, 44-22
Traversal properties
for link widgets 35-26
for table views 35-22
for widgets 35-25
TUXEDO
creating service components 12-1
Two-tier applications 4-3
Two-tier architecture 1-2, 26-4

U

UNIQUE
dbms command
suppressing repeating values
suppressing repeating values 28-17
UNIX
deploying application E-4
Unnamed procedure 19-2
executing in screen JPL 17-6
getting standard arguments 19-3
Updatable property
in automated SQL generation 32-32, 32-35, 32-38
Update Order property
in automated SQL generation 32-36
Update Service property 32-5
UPDATE statement
SQL generation from properties 32-35, 32-45
Use If Null property 32-15
in automated SQL generation 32-17
Use in Insert property 32-33
expression 32-34
in automated SQL generation 32-33
Use in Select property 32-10
Use in Update property
expression 32-36, 32-37
in automated SQL generation 32-36
Use in Where property 32-14
in automated SQL generation 32-14
operator specification 32-15
Utilities
bin2hex A-4
binherit A-6
cmap2bin A-9
f2asc A-12
jpl2bin A-20
m2asc A-22
msg2bin A-29

V

Validation 22-15
clearing MDT bit 22-16
field 43-15
field function invocation 43-15
MDT bit 22-16
screen 43-15
setting mdt property 17-6
setting valided property 17-6, 22-15
testing screen for modified data 22-16
validation bit 22-15
XMIT key 43-15
Validation bit 22-15
Validation Link property 32-46, 32-47
setting on a widget 30-13
valided property
setting 22-15
Variable
monitoring through debugger 38-5
watching through debugger 38-26
Version Column property 32-40
in automated SQL generation 32-41
Video file
making memory-resident 41-12
Video mapping
internationalization 44-45
Video processing function 43-47
return codes 43-49
standard argument 43-47
View menu
in debugger 38-4
Viewport 13-4
Virtual column 30-11

W

Web application architecture 1-23
WHERE clause
in automated SQL generation 32-14, 32-37, 32-41
Widget events 17-2
Widget name
case sensitivity 28-3
getting 14-3
Widget runtime properties
getting 22-7
Widgets
attaching JPL procedure to
attaching JPL procedure 19-16
calls to JPL from 19-21
copying from repository
for transaction manager 30-3
identifying 14-3
including in SQL generation 30-11
JPL validation 19-8
mapping to database columns 28-3
menu
attaching 15-4
properties for SQL generation 32-3
storing templates in repository 11-7
validating 22-15
Window
changing focus among siblings 23-5
deselecting 23-4
displaying messages in 44-12
giving focus to 23-4
opening 13-3
as sibling 23-4
setting next as sibling 23-4
Window stack 23-3
changing order 23-4
Windows
deploying application E-2
using MDI frame 13-6
Windows initialization file
specifying 42-8
splash screen 42-8
WITH CONNECTION
dbms command
setting database connection 8-4
WITH ENGINE dbms command
setting database engine 7-3
Word wrapped text
fetching column values 28-8

X

XMIT key (transmit)
and push buttons 18-7
screen validation 43-15

Y

Yes/No
setting default values 44-25
translating 44-45