Application Development

Symbols

% (percent sign)

in message file 45-8

%A

display attributes in messages 45-9

%B

bell for messages 45-10

%K

key label in message 45-10

%Md

force user acknowledgment of messages 45-11

%Mu

acknowledgment of error messages 45-12

%N

carriage returns in messages 45-12

%W

popup window for messages 45-12

:+ (colon-plus processing) 30-2

:: (parameters)

in DECLARE CURSOR command 30-11

:= (colon-equal processing) 30-7

@ (at)

to reference database driver variable 37-4

@ object modifiers 19-34

@app 19-34

@field_num 19-35

@id 19-34

@ldb 19-35

@obj 19-36

@screen 19-34

@screen_num 19-35

@tp_req 19-36

@widget 19-35

@bi(field) global variable 36-18

@date

defining format for 45-19

in JPL 19-51

@length

in JPL 19-51

@property modifier 19-40

@range 39-26

@sum

in JPL 19-52

@tm global variables 36-18

@tm_sel_cursor

default select cursor name 28-8

A

ActiveX controls

event handler in Java 21-6

manipulating at runtime 23-13

Aggregate functions

aliasing to widgets 29-6

in automated SQL generation 33-17

ALIAS

dbms command

aliasing column names 29-4

Aliasing

colors 45-26

column names to widgets 29-4

Alphabetic data

range checking 48-5

Animation 39-8, 39-20

Application

customizing 43-7

debugging 39-19

defining project requirements 3-1

exiting base form 24-3

menu

attaching 15-4

optimizing 41-1

packaging checklist D-2

Windows D-2

specifying splash screen for 43-8

specifying startup file 43-8

Application architecture 1-2

defining 4-1

Application behavior

understanding events 17-1

Application components

building 1-12

integrating 1-20

referencing 19-33

with object modifiers 19-34

Application data 45-45

Application Data option

in debugger 39-9

Application development

accessing the database 27-1, 28-1

defining the project team 1-3

defining the requirements 1-2

development environment 1-6

programming application events 1-16

steps 1-2

with the transaction manager 31-2

Application messages 45-6

header file A-34

Application server

preparing 1-4, 5-1

Array

accessing in JPL 19-39

clearing all data 23-8

in transaction manager 36-10

defining 14-5

deleting occurrence 23-8

elements 14-4

inserting occurrence 23-8

numbering 14-6

scrolling 14-6

setting array size 14-6

sum of occurrences 19-52

ASC keyword

specifying data order 33-21

ASCII

non-ASCII display 45-45

ASCII output

menus A-22

reports A-11

screens A-11

service components A-11

Auto Raise/Close 39-8

Automatic functions

defined 44-2

example 44-65, 44-71

installing

field function 44-19

group function 44-27

screen function 44-13

screen function 17-8

B

Background status

displaying 26-9

Backward scrolling

viewing database rows 29-12

Base form

exiting 24-3

Basic colors

keywords 45-27

Before image processing

modifying data in transaction manager 36-7, 36-26

Bell

setting in messages 45-10

bin2c A-2

bin2hex A-4

Binary columns

writing to database 30-10

Binding

supplying database column values 28-6, 30-11

binherit A-6

Bitwise expression 19-54

Bitwise operators 19-52

Breakpoint

clearing 39-21

listing of 39-5

setting 39-20

in JPL 39-15

on event 39-23

sorting 39-10

specifying location 39-24

Breaks menu

for debugger breakpoints 39-11

Built-in control functions 18-7

C

C functions

calling 20-6

executing from control string 18-5

linking to executable 20-4, 42-4

writing your own 20-1

C Type property 30-4

formatting fetched data 29-16

writing values to database

character strings 30-10

hexadecimal strings 30-10

numeric data 30-7

Calling Java Object Methods 21-19

Calling JPL procedure

as hook function 19-21

from control string 19-22

through call command 19-23

within expression 19-23

Cancel Check Out 10-8

Carriage return

in message

%N 45-12

Case sensitivity

alias names 29-5

column names 7-4, 7-8

connection names 8-3

cursor names 28-5

engine names 7-4, 7-7

specifying for library members A-16

widget names 29-3

CATQUERY

dbms command

writing results to widget or file 29-19

Character data

8-bit 45-45

Character mode

setting line and box style in cmap file 45-34

Character strings

reading from database 29-15

writing to database 30-6, 30-10

Check box widget

event handler in Java 21-7

Check digit function 44-40

return codes 44-40

Check In 10-8

Check Out 10-7

Child property

determining child table view 31-8

Class property 36-14

Client

configuring environment of 6-1

Client authentication

installing data function 44-28

installing post-connection function 44-30

Client executables 42-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 28-9

Close Item property 13-2

CLOSE_ALL_CONNECTIONS

dbms command

closing database connections 8-5

Closing

screens 13-7

cmap2bin A-8

Colon preprocessing 19-27, 30-1

colon equal 30-7

colon plus 30-2

examples 30-8

substring specifier 19-29

Color properties

aliasing colors 45-26

display attributes

keywords 45-27

highlighted colors

in Windows 45-27

Panther basic colors

keywords 45-27

Color terminal

display attributes in messages 45-9

Column Click Action property 17-17

Column Click Func 17-17

Column Click Sort 17-17

Column Edits subproperties 11-7

Column Name property 33-3

in automated SQL generation 33-10, 33-33, 33-37

Column Titles property 31-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 28-10

Common library 1-13

Configuration

converting message files to binary A-29

of debugger 39-6

setting up development clients 6-1

Configuration map file

aliasing colors 45-26

colors section 45-26

converting to binary A-8

defining default fonts 45-36

making memory-resident 42-11

object specification keywords 45-32

scheme section 45-30

Connecting

to JetNet via the request broker 9-3

CONNECTION

dbms command

setting database connection 8-4

Constants in JPL 19-31

Continuation character 19-4

Continuation file

scrolling through select set 29-12

specifying

in the transaction manager 36-5

CONTINUE

dbms command

fetching next set of rows 29-11

Control flow

in JPL 19-4

Control function 44-44

example 44-87

return codes 44-45

standard argument 44-44

Control string 18-2

calling JPL 18-5, 19-22

executing function from 18-5

executing OS command from 18-8

getting information in debugger 39-18

target string in 18-6

Conversion utilities

bin2c A-2

bin2hex A-4

cmap2bin A-8

f2asc A-11

jif2asc A-19

jpl2bin A-20

m2asc A-22

msg2bin (message files to binary) A-29

s2asc (styles file to/from ASCII) A-40

Count Select property 36-6

Count Threshold property 36-6

Creating

repository 11-3

service components 12-1

Currency format 45-19

default entries in message file 45-21

fetching from database 29-16

writing to database

colon-plus processing 30-7

Cursor

changing delay state 46-9

position

after check digit function 44-40

after field validation 44-19

after group validation 44-27

displaying 26-7, 26-9

Cursor (database) 28-3

closing 8-4, 28-9

declaring 28-4, 30-11

redeclaring 28-8

using bind values 28-6, 30-11

using colon expansion 28-5

using the default 28-3

D

Data

displaying

displaying in arrays 14-6

modifying

in the transaction manager 36-7

selecting

in the transaction manager 36-3

using a database driver 29-1

with warning message 36-6

writing to a database 30-1

Data Formatting property

formatting fetched data 29-16

using in database updates 30-5

Data Watch option 39-6

sorting variables

in debugger 39-10

Database

accessing 1-3, 1-6, 27-2

designing schema 3-3

importing database to a repository 11-5

reading information from 29-1

transaction processing 28-10

using in Panther 27-1

writing information to 30-1

Database columns

aliasing to widgets 29-4

automatic mapping to widgets 29-3

importing to a repository 11-5

in automated SQL generation 33-3, 33-10, 33-33, 33-37

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 29-1

setting current 8-4

setting default 8-4

writing to a database 30-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 37-4

Database events

trace warning in debugger 39-8

Database information

importing into Panther 1-12

Database properties

for SQL generator 33-4

Database version

identify in executable 42-5

Date

JPL @date operator 19-51

Date/time format

customizing 45-12

defaults 45-13

fetching from database 29-16

for non-English applications 45-17

literal format for @date calculations 45-19

tokens 45-14

writing to database 30-9

colon-plus processing 30-6

DB Interactions window

viewing transaction tree 31-10

dbiinit.c

creating new 7-6

DBUG key (debug) 39-4

DDE

callback function 47-8

cold links

creating for Panther client 47-6

updated from Panther server 47-4

cold paste links

creating for Panther client 47-6

destroying links on Panther client 47-9

disabling Panther as server 47-5

enabling Panther as client 47-5

enabling Panther as server 47-2

executing command from Panther client 47-9

executing command on Panther server 47-10

hot links

creating for Panther client 47-6

specifying in initialization file 47-7

updated from Panther server 47-4

hot paste links

creating for Panther client 47-6

links

created on Panther server 47-2

creating for Panther client 47-6

specifying in initialization file 47-7

updated from Panther server 47-3

paste links

creating for Panther client 47-6

poking data from Panther client 47-10

poking data into Panther server 47-10

requesting link data 47-8

updating Panther client data 47-8

warm links

creating for Panther client 47-6

updated from Panther server 47-4

warm paste links

creating for Panther client 47-6

Debuggable server

in JetNet applications 39-2

Debugger 38-2

accessing 39-3

from Test mode 38-6, 38-7, 38-8

animation 39-8, 39-20

Application Data window 39-27

calling a function 39-9

calling a function on breakpoint 39-26

configuring 39-6

Data Watch window 39-26

enabling in screen editor 39-4

exiting 39-4

expert mode 39-8, 39-23

menu bar 39-8

module browsing 39-12

saving preferences 39-7

View menu 39-4

viewing control string assignments 39-18

viewing JPL 39-11

Decimal symbol

setting default 45-23

DECLARE CONNECTION

dbms command

making database connection 8-3

DECLARE CURSOR

dbms command

creating database cursor 28-5, 30-11

using bind values 28-6, 30-11

using colon expansion 28-5

Delay cursor 46-9

Delete Order property

in automated SQL generation 33-38

Delete Service property 33-5

DELETE statement

SQL generation from properties 33-38

Demand functions

example 44-69

installing

field function 44-20

group function 44-27

screen function 44-13

Deployment

directory structure D-1

DESC keyword

specifying data order 33-21

Destroying Java Objects 21-19

Dialog property 13-2

Display area

size for portability 48-2

Display attributes

keywords 45-27

portability 48-2

setting

in messages 45-8

in status line 45-9

Distinct property 33-13

Distribution

directories defined 2-1

Duplicate rows

eliminating 33-13

Dynamic label widget

event handler in Java 21-8

E

Edit menu

in debugger 39-10

Editor

invoking from JPL dialog box 19-17

using 1-15

Elements

numbering 14-6

Email 49-1

creating mail object 49-4

properties 49-1

sending 49-5

attachments 49-6

ENGINE

dbms command

setting database engine 7-3

Enterprise JavaBeans

service components for 12-5

Entry Function property

screen 17-8

Environment setup

development clients 6-1

Error function 44-37

example 44-81

return codes 44-38

standard arguments 44-38

Error handling 26-1

installing database error handler 37-9

Error hook function 26-9

Error messages

acknowledgment 45-11

disabling display of 26-2

Error messages (database) 37-1, 37-2

customized processing 37-6

default processing 37-2

engine-specific messages 37-4

error handler 37-7

exit handler 37-7

generic database driver messages 37-4

installing error handler 37-6, 37-9

transaction error handling 28-12

transaction hook functions 32-4

warning codes 37-4

Event function arguments

client authentication connection 44-28

client authentication post-connection 44-30

control 44-44

error 44-38

field 44-15

grid 44-21

group 44-26

initialization 44-42

key change 44-37

playback 44-43

record 44-43

reset 44-42

screen 44-11

tab control 44-24

timeout 44-33

timer 44-35

transaction manager 44-50

video processing 44-47

Event function return codes

transaction manager 32-3

Event function types

transaction manager 32-1

Event functions

in the transaction manager 31-15

programming for 1-16

transaction manager 32-1

Event handlers

in Java 21-4

Event stack

for transaction manager 35-7

in debugger 39-6

Events

in Panther applications 17-1

setting breakpoints on 39-21

user-initiated 17-22

Executables

building 42-1

including your C functions 20-1

renaming 42-6

EXECUTE

dbms command

executing statement 28-5

Exit

debugger 39-4

Exiting Panther 38-8

Expert mode 39-8, 39-19

Extended colors

aliasing colors 45-26

External menu 15-6

F

f2asc

generating ASCII output A-11

Fetch data properties 33-10

Fetch Directions property 36-6

Field

characteristics

internationalization 48-3

decimal symbol 45-23

displaying status of 26-8

getting current field number 14-3

getting screen's amount of 13-8

Field data

clearing all fields 23-8

clearing from array 23-8

getting length 19-51, 23-6

reading 23-5

testing

all fields for changes 23-15

for no value 23-6

for yes value 23-6

if null 23-6

writing 23-7

Field function 44-14

example of automatic function 44-65

example of demand function 44-69

passing non-standard arguments into 44-67

standard arguments 44-15

Field number

assignment 14-4

Field validation 23-14

causes 44-15

File

required in deployment 43-4

File locking A-16

Font

setting display default 45-36

Force Valid property 33-12

Foreign keys

enforcing with validation link 33-48

Form

opening 13-3

Form stack 24-2

FORMAT

dbms command

formatting result set 29-19

Formatting text

for a database 30-12

from a database 29-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 Column Click 17-17

Grid function 44-20

return codes 44-23

standard arguments 44-21

Grid widgets

event handler in Java 21-8

Group

converting to field number 14-9

getting information in debugger 39-17

getting name from field reference 14-9

getting screen's amount of 13-8

identifying members of 23-3

validation 44-26

GROUP BY clause

in automated SQL generation 33-17

Group By property 33-17

Group function 44-25

example of automatic function 44-71

return codes 44-27

standard arguments 44-26

Group widgets

event handler in Java 21-9

H

HAVING clause

in automated SQL generation 33-20

Having property

in automated SQL generation 33-20

Header file

creating A-34

sample A-35

Help function 44-32

example 44-73

return codes 44-32

Hexadecimal strings

writing to database 30-7, 30-10

Hidden property

and version columns 33-42

Hook functions

invoking 19-21

I

Icon

for application 42-8

Import

of database objects to a repository 11-5

In Delete Where property 33-41

in automated SQL generation 33-41

IN keyword

in automated SQL generation 33-16

In Update Where property 33-41

in automated SQL generation 33-41

Included JPL modules 19-5

Infinite loops

breaking out in debugger 39-4

Inherit From property

removing specification 11-10

Inherit menu option 11-10

Inheritance 1-14, 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 44-41

example 44-82

return codes 44-42

standard argument 44-42

Insert Service property 33-5

INSERT statement

SQL generation from properties 33-32, 33-44

Insert toggle function 44-39

example 44-81

return codes 44-39

Installed function return codes

check digit 44-40

client authentication connection 44-28

control 44-45

error 44-38

grid 44-23

group 44-27

help 44-32

initialization 44-42

insert toggle 44-39

key change 44-37

playback 44-43

record 44-43

reset 44-42

screen 44-12

status line 44-46

timeout 44-33

timer 44-35

transaction manager 44-50

video processing 44-49

Installed function types

check digit 44-40

client authentication connection 44-28

client authentication post-connection 44-30

control 44-44

database driver errors 44-49

error 44-37

field 44-14

grid 44-20

group 44-25

help 44-32

initialization 44-41

insert toggle 44-39

key change 44-36

playback 44-43

prototyped 44-8

record 44-43

reset 44-41

screen 44-10

status line 44-45

tab control 44-24

timeout 44-33

timer 44-34

transaction manager 44-50

video processing 44-47

Installed functions

automatic 44-2

installing 44-4

standard arguments 44-3

Instantiating Java Objects 21-17

Interface

three-tier

between client and server 1-7

Internationalization

8-bit characters 45-45

alternate message files 45-24

currency formats 45-19

decimal symbol 45-23

keystroke filters 48-3

library functions 45-45

of application screens 45-46

range checks 48-4

yes/no values 45-24

Interrupt handler 44-41

J

Java

event handler interfaces 21-4

implementing event handlers 21-1

sample 21-23

samples C-1

setting environment variables 21-2

Java Tag property 21-3

JetNet

connecting to

via the request broker 9-3

creating service components 12-1

using with transaction manager 35-12

JIF

defining service availability 1-8

jif2asc A-19

jmain.c 42-6

Join 33-23

implementing

full outer join 33-30

inner join 33-29

left outer join 33-30

right outer join 33-31

Join Type property 33-28

JPL

choosing an editor 19-17

comments 19-5

constants 19-31

control flow 19-4

memory-resident 42-9

null statement 19-5

optimizing performance 19-56

setting breakpoint in 39-15

validation 19-8

viewing with debugger 39-11, 39-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-55

JPL expression

bitwise 19-54

numeric 19-53

numeric format 19-54

operand conversion 19-49

specifying substring in variable 19-50

string 19-53

JPL module 19-1

accessing with debugger 39-11, 39-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 module 19-9

storing in library 19-11

types 19-8

unnamed procedure 19-2

widget validation 19-8

JPL operators 19-47

@date 19-51

@length 19-51

@sum 19-52

bitwise 19-52

concatenation 19-50

precedence 19-49

substring specifier 19-50

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-27

resolving name ambiguity 19-38

scope and lifetime 19-27

substring specifier 19-50

watching through debugger 39-9, 39-26

jpl2bin A-20

Jterm

enabling data compression 42-12

K

K_ENTRY flag

set on field entry 44-16

set on grid entry 44-21

set on screen entry 44-11

set on tab card entry 44-25

K_EXIT flag

set on field exit 44-17

set on grid exit 44-21

set on screen exit 44-11

set on tab card exit 44-25

K_EXPOSE flag

set on screen exposure 44-11

K_KEYS bitmask 44-12, 44-17, 44-22

Key change function 44-36

example 44-79

return codes 44-37

standard argument 44-37

Key label

displaying in messages 45-10

portability 48-3

Key translation

internationalization 45-46

portability 48-3

Key translation file

making memory-resident 42-11

Keyboard

portability 48-3

Keystroke Filter property

translation support 48-3

using in database updates 30-5

using to format database values 30-9, 30-10

L

LDB 25-7

loading

multiple instances of 25-9

popping 25-11

Length property

defined in database 11-7

Library

lock on 10-9

making read-only A-17

set file locking scheme A-16

source control management 10-4

storing JPL modules 19-12

synchronize with source code management A-17

Library JPL module 19-16

Line length of JPL statement 19-4

Line styles

names of 45-34

setting in cmap file 45-34

Link widget

relationship properties 33-23

Links 31-7

in automated SQL generation 33-22

setting child table view 31-8

setting parent table view 31-8

setting the link type 31-9

validation 31-13, 33-46, 33-47

adding lookup 33-49

enforcing foreign keys 33-48

List box widget

event handler in Java 21-9

Local decimal symbol 45-23

Lock

on library/repository 10-9

Lock files A-16

Log file

debugger 39-6

writing to 39-10

Logical key

invoking control string from 18-2

Lookup specification 33-49

in Relations dialog box 33-49

M

m2asc A-22

Mail 49-1

creating mail object 49-4

properties 49-1

sending 49-5

attachments 49-6

makefile

list 42-3

makevars 42-4, 42-5

MDI frame

in Windows applications 13-6

with dockable toolbars 15-10

MDT bit 23-14

clearing for all fields 23-15

testing to find first modified field 23-15

Memory-resident

JPL modules 19-13, 42-9

screens 42-9

Menu

ASCII/binary conversion A-22

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

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

popup for field

invoking 15-13

properties of

changing ar runtime 15-9

removing from display 15-12

scope assignment and display 15-4

testing 38-8

Menu bar

in application mode 38-2

Menu item

displaying status of 26-8

Menu Name property 15-4

Menu script

loading into memory 15-2

unloading from memory 15-12

Menu Script File property 15-2

Message

acknowledgment 26-2, 45-12

forcing 45-11

bell 45-10

creating 45-5

default display

in status line 26-1

in window 26-1

disabling display of 26-2

display attributes in 45-8, 45-9

hexadecimal codes for 45-9

displaying

background status 26-9

in window 45-12

on status line 26-7

error 26-1

forcing to status line

automatic dismissal 45-11

functions for displaying 26-4

key labels in 45-10

multiple lines in 45-12

Panther-specific 45-4

send via request broker 9-2

Message file 45-2

converting to binary (msg2bin) A-29

making memory-resident 42-11

modifying 45-2

multiple sections 45-6

size 45-6

syntax 45-4

text 45-5

translating 45-2

using alternate 45-24

Method property 36-7, 36-11

Middleware

connecting to 1-7, 9-1

Module type

specifying in debugger 39-14

Monochrome terminal 45-9

Motif

deploying application D-4

Motif resource file

specifying 43-8

splash screen 43-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

MSSCCI Support 10-1

MTS

creating service components 12-8

Multi-item properties

Multi-item properties

accessing in JPL 19-41

Multiple sections

in message file 45-6

Multi-user access 10-3

N

NCARD key (next card) 23-12

Null edit

colon-equal processing 30-7

writing null value to database 30-3, 30-9

Null Field property

in automated SQL generation 33-17

writing null values to database 30-3, 30-9

Null statement in JPL 19-5

Null value

writing to database 30-3, 30-9

Numbering

in arrays 14-6

Numeric data

range checking 48-4

reading from database 29-16

writing to database 30-7

Numeric expression

JPL 19-53

Numeric format

JPL 19-54

O

Object ID

for widgets 14-3

OCCUR

dbms command

setting occurrence for SELECT 29-14

Occurrence

deleting 23-8

inserting 23-8

numbering 14-6

setting the number of 14-6

ONENTRY

dbms command

calling function before dbms command 37-7

ONERROR

dbms command

installing error handler 37-7

ONEXIT

dbms command

calling function after dbms command 37-7

Opening

screens 13-3

Operands

conversion in JPL 19-49

Operating system

accessing from control string 18-8

Operator property 33-15

in automated SQL generation 33-15

Operators

JPL operators 19-47

supported in WHERE clause 33-14

Optimistic locking

property settings 33-39

Option menu widget

event handler in Java 21-10

ORDER BY clause

in automated SQL generation 33-21

Output processing

messages 26-7

P

Panther

description 1-1

description of directories 2-1

Panther basic colors

keywords 45-27

Panther executables

building 42-1

including your C functions 20-1

modifying 42-6

Panther type

character strings

fetching from database 29-15

writing to database 30-6, 30-8

converting to C type 30-4

currency formats

writing to database 30-5, 30-7

date and time formats

fetching from database 29-16

writing to database 30-5, 30-6, 30-9

hexadecimal strings

writing to database 30-7

numeric data

fetching from database 29-16

writing to database 30-7, 30-10

using to format selected data 29-15

Parameters

declaring in JPL 19-2

for binding

in DECLARE CURSOR command 28-6, 30-11

Parent object

turning inheritance on/off for specific properties 11-9

Parent property

determining parent table view 31-8

Partial command 34-6

PCARD key (previous card) 23-12

Pending keys 39-6

Percent escapes

in message file 45-8

Playback function 44-43

example 44-84

return codes 44-43

standard argument 44-43

Popup menu

invoking 15-13

Popup Menu property

screens 15-4

widgets 15-4

Portability 48-1

aliasing colors 45-26

smmach.h 48-1

Precision

in SELECT results 29-16

Preferences

saving in debugger 39-7, 39-9

setting in debugger 39-6

Primary Key property

in automated SQL generation 33-38

Primary keys

updating

with transaction manager 36-9

Programming

modifying property values 1-16

sharing data 1-21

using application events 1-16

Project

defining requirements 3-1

Project requirements 1-2

defining the project team 1-3

Properties

accessing in JPL 19-40

application properties 19-41

multi-item properties 19-41

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

multi-item properties 19-41

setting at runtime

for menus 15-9

transaction manager 36-19, 36-26

traversal 36-19

value types 19-42

Prototyped function 44-8

examples 44-52

get standard arguments 44-8

valid prototypes 44-10

Public module

loading 17-6

Push button widget

event handler in Java 21-11

PVCS support 10-1

R

Radio button widget

event handler in Java 21-11

Range

checking 48-4

Read-only library A-17

Read-only screen

saving 10-10

Ready/Wait status

displaying 26-8

Receive data

reading bundle data 25-4

Record function 44-43

example 44-84

return codes 44-43

standard argument 44-43

Regenerate SQL property 36-11

Relations property 33-23, 36-5

in automated SQL generation 33-27

Report

JPL 19-14

Reports

ASCII/binary conversion A-11

overview 16-1

overview of 1-19

Repository

benefits 11-1

copying objects

for transaction manager 31-3

for application development 1-13

from a database

build with 1-11

importing database objects 11-5

lock on 10-9

making read-only A-17

screen wizard entries 11-8

set file locking scheme A-16

storing screen templates 11-5

synchronize with source code management A-17

under source control management 10-4

Request broker 9-1

Request broker event handlers

defined 17-26

Request events

in transaction manager 35-3

Reservation

releasing 10-4

Reset function 44-41

example 44-82

return codes 44-42

standard argument 44-42

Return codes

transaction event functions 32-3

Return value 19-20

declaring type in JPL 19-4

Revision control 10-9

ROLLBACK

dbms command

engine-specific behavior

rolling back transactions 28-10, 28-12

Root table view

in the transaction manager 31-8

Row Titles property 31-13

Rows

determining number fetched 29-8

retrieving multiple rows 29-8

scrolling through result set 29-12

setting maximum number 36-6

Runtime properties

accessing in JPL 19-40

S

s2asc A-40

Sample applications

Java 21-23

Samples

two-tier application

VideoBiz B-1

using Java in Panther C-1

SAVE

transaction manager command

saving database changes 32-9

Scale property

defined in database 11-7

Scale widget

event handler in Java 21-12

SCCS support 10-1

Scheme

defining in configuration map file 45-30

object names for color mapping 45-32

Screen

about 13-1

as a dialog box 13-2

ASCII/binary conversion A-11

C data structure conversion A-2

calls to JPL from 19-21

closing 13-7, 38-8

control string 18-2

creating

screen templates 11-5

deleting under source control 10-11

display defaults 13-4

overriding 13-5

entry processing 17-4

event handler in Java 21-5

events 17-2

entry 17-4

exit 17-19

exposure 17-6

functions 44-10

hexadecimal conversion A-4

identifying members of 23-3

JPL 19-14

JPL module 19-9

memory-resident 42-9

menu

attaching 15-4

naming start up 42-7

opening 13-3

as a form 13-3, 24-2

as a sibling window 24-4

as a window 13-3, 24-3

at specific size/dimension 13-5

from control string 18-3

popup menu

attaching 15-4

read-only 10-9

saving 10-10

reserving 10-3

setting properties 13-8

status line text 26-8

testing 38-4

viewing in debugger 39-16

viewport 13-4

Screen editor

accessing from within Panther 38-2

exiting 38-8

Screen entry 17-4

executing screen's unnamed procedure 17-6

Screen events 17-2

Screen exit 17-19

Screen function

return codes 44-12

standard arguments 44-11

Screen functions 44-10

Screen module 19-9

viewing in debugger 39-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 29-12

Select Service property 33-5

SELECT statement

aliasing columns to widgets 29-4

automatic mapping of column names 29-3

changing generated SQL 36-6

concatenating result row 29-19

destination of 29-3, 29-19

aggregate functions 29-6

formatting result set 29-15

generating SQL 36-3

scrolling through result set 29-8

specifying multiple tables

in automated SQL generation 33-22

SQL generation from properties 33-7, 33-44

suppressing repeating values 29-18

transaction manager

writing hook function 32-6

unique column values 29-18

writing results

to a file 29-19

to a specific occurrence 29-8, 29-14

to word-wrapped arrays 29-8

Selection group

deselecting 23-11

getting selection data 23-9

identifying members of 14-8

selecting 23-11

testing for selection 23-9

Self-joins

in automated SQL generation 33-24

in the transaction manager 31-8

Send data 25-1

reading bundle data 25-4

writing data to bundle 25-2

Sequential link

in data fetches 36-5

setting the link type 31-9

sequential link 31-9

Sequential link type

in automated SQL generation 33-26

join specification 33-23

Server executables 42-1

Server library 1-13

Server link

setting the link type 31-9

server link 31-9

Server link type

join relationship 33-23

server view 31-9

Server views

traversal properties 36-21

Service

debugging 39-2

Service components

ASCII/binary conversion A-11

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 39-2

Service properties

link widgets 33-47

table view 33-5

Service request

finding the transaction manager operation 36-26

via request broker 9-2

SET clause

in automated SQL generation 33-37

Set Valid property 33-12

Sibling property 24-4

Sibling window

setting for next window 24-4

Single line text widget

event handler in Java 21-13

Slice events

in transaction manager 35-3

SM_CALC_DATE

setting default format 45-19

SM_DECIMAL

setting default 45-23

smmach.h 48-1

SMMSGS

setting alternate value 45-18, 45-24

Sort Order 17-17

Sort Order Func 17-17

Sort Widgets property

in automated SQL generation 33-21

Source code

main routines

modifying 42-6

platform-dependent 48-1

Source Code menu option

in debugger 39-4

Source control management

accessing screen outside of 10-3

deleting screens under 10-11

features of 10-7

in the editor 10-7, 10-8

setting up 10-5

synchronizing library A-17

Splash screen 43-8

SQL

automated 33-1

setting properties for 33-4

constructing SQL statements 28-1

declaring cursors for 28-4

modifying automated SQL 32-1, 33-31

sending to database 27-2

viewing generated SQL 36-2

viewing generated statements 33-43

SQL generation 33-1

modifying automated SQL 33-31

Standard arguments 44-3

client authentication connection function 44-28

client authentication post-connection function 44-30

control function 44-44

error function 44-38

field function 44-15

grid function 44-21

group function 44-26

initialization function 44-42

key change function 44-37

passing into unnamed procedure 19-3

playback function 44-43

prototyped function

getting for 44-8

record function 44-43

reset function 44-42

screen function 44-11

tab control function 44-24

timeout function 44-33

timer function 44-35

types 19-21

video processing function 44-47

START

dbms command

setting starting row 29-15

Startup file 43-8

Startup screen 42-7

Status

determining in debugger 39-4

Status line

default message

overriding 26-8

message functions 26-4

message priority 26-7

message types 26-7

terminal portability 48-2

text

background 26-9

for screen 26-8

for widget 26-8

Status line function 44-45

example 44-96

return codes 44-46

STORE

dbms command

setting continuation file 29-12

String

getting length 19-51

String expression

JPL 19-53

Substring specifier 19-50

colon variables 19-29

Support routine

Database drivers 7-1

database engines 7-4

Synchronization property 36-9

System decimal

defining symbol 45-23

interpreting 45-45

T

Tab Card widget

event handler in Java 21-12

Tab control function 44-24

standard arguments 44-24

Tab controls

about 23-12

getting the number of cards 23-12

setting the card sequence 23-12

setting the topmost card 23-12

Table property

table view

in automated SQL generation 33-14

Table views 31-7

adding a virtual column 31-11

adding members to 31-11

identifying as root 31-8

limiting through commands 34-5

properties for SQL generation 33-2, 33-4, 33-14

setting child table view 31-8

setting parent table view 31-8

traversal properties 36-21

viewing properties 31-8

Tables

in automated SQL generation 33-2, 33-14, 33-36

joining multiple 33-22

storing in repository 11-5

Target string 18-6

Terminal

bell

in message 45-10

portability 48-2

status line 26-7

Test mode 38-4

exiting 38-8

menu bar 38-1

vs. application mode 38-5

Testing

overview of 1-24

Text

entry widgets

event handler in Java 21-13

formatting for a database 30-1

Text editor

invoking for JPL procedures 19-14

Three-tier applications 4-1

Three-tier architecture 1-3, 27-5

Timeout

server configuration 39-3

Timeout function 44-33

example 44-78

return codes 44-33

standard arguments 44-33

Timer function 44-34

return codes 44-35

standard arguments 44-35

Toggle button widget

event handler in Java 21-13

Toolbar 15-7

displaying 15-1

setting runtime properties 15-10

Top Screen option 38-2

Trace menu

in debugger 39-11

Transaction

error handling 28-12

processing database transactions 28-10

Transaction classes

defaults

widgets 36-14

Transaction events

adding to the stack 35-10

after an error 36-28

controlling the event stack 35-9

unsupported 32-6

Transaction manager

and debugger 39-8

before image processing 36-7

changing the transaction mode 31-14

closing a screen 36-2

commands 34-2

copying from repository 31-3

determining sequence 31-4

creating screens for 31-1

deleting data 36-9

development process for 31-2

disabling 36-3

error processing

controlling display 36-30

event functions 32-1

checking for database errors 32-4

DELETE statement 32-9

INSERT statement 32-9

SELECT statement 32-6

specifying return codes 32-3

UPDATE statement 32-9

event stack 35-7

fetching data 36-3

for update 36-8

with a maximum row count 36-6

generating SQL 1-17, 27-2

hook functions

return codes 44-50

standard arguments 44-50

in JetNet applications 35-12

initiating a transaction 17-7

installed event functions 44-50

opening a screen 36-2

processing at runtime 36-1

processing events 35-1

restrictions 34-2

specifying commands 31-13, 34-4

SQL generation 33-3

tree traversal 31-10

using in Panther 27-2

verifying changes 36-11

viewing generated SQL 36-2

writing event functions 31-15

Transaction manager commands 34-2

availability by mode 34-7

processing for 35-3

specifying full commands 34-6

specifying partial commands 34-6

Transaction mode 36-12

availability of commands 34-7

Transaction model 35-5

for JetNet 35-13

initializing 7-2

return codes 32-3

specifying in Windows 7-8

Transaction styles

ASCII A-40

converting to/from ASCII A-40

defaults 36-14

report

s2asc A-40

Translating 45-45

message file 45-2

substitution variables 45-16, 45-21

Traversal properties

for link widgets 36-25

for table views 36-22

for widgets 36-25

TUXEDO

creating service components 12-1

Two-tier applications 4-3

Two-tier architecture 1-2, 27-4

Type-Specifiers and Arguments 21-18

U

UNIQUE

dbms command

suppressing repeating values

suppressing repeating values 29-18

UNIX

deploying application D-4

Unnamed procedure 19-2

executing in screen JPL 17-6

getting standard arguments 19-3

Updatable property

in automated SQL generation 33-32, 33-36, 33-38

Update Order property

in automated SQL generation 33-36

Update Service property 33-5

UPDATE statement

SQL generation from properties 33-36, 33-45

Use If Null property 33-15

in automated SQL generation 33-17

Use in Insert property 33-33

expression 33-34

in automated SQL generation 33-33

Use in Select property 33-10

Use in Update property

expression 33-37

in automated SQL generation 33-37

Use in Where property 33-14

in automated SQL generation 33-14

operator specification 33-15

Utilities

bin2c A-2

bin2hex A-4

binherit A-6

cmap2bin A-8

f2asc A-11

jpl2bin A-20

m2asc A-22

msg2bin A-29

V

Validation 23-14

clearing MDT bit 23-15

field 44-15

field function invocation 44-15

MDT bit 23-14

screen 44-15

setting mdt property 17-6

setting valided property 17-6, 23-14

testing screen for modified data 23-15

validation bit 23-14

XMIT key 44-15

Validation bit 23-14

Validation Link property 33-46, 33-47

setting on a widget 31-13

valided property

setting 23-14

Variables

monitoring through debugger 39-6

watching through debugger 39-26

Version Column property 33-41

in automated SQL generation 33-42

Video file

making memory-resident 42-11

Video mapping

internationalization 45-46

Video processing function 44-47

return codes 44-49

standard argument 44-47

View menu

in debugger 39-4

Viewport 13-4

Virtual column 31-11

W

Web application architecture 1-22

WHERE clause

in automated SQL generation 33-14, 33-38, 33-41

Widget events 17-2

Widget name

case sensitivity 29-3

getting 14-3

Widget runtime properties

getting 23-6

Widgets

attaching JPL procedure to

attaching JPL procedure 19-16

calls to JPL from 19-21

copying from repository

for transaction manager 31-3

identifying 14-3

including in SQL generation 31-11

JPL validation 19-8

mapping to database columns 29-3

menu

attaching 15-4

properties for SQL generation 33-3

storing templates in repository 11-7

validation 23-14

Window

changing focus among siblings 24-5

deselecting 24-4

displaying messages in 45-12

giving focus to 24-4

opening 13-3

as sibling 24-4

setting next as sibling 24-4

Window stack 24-3

changing order 24-4

Windows

deploying application D-2

using MDI frame 13-6

Windows initialization file

specifying 43-8

splash screen 43-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 29-8

X

XMIT key (transmit)

and push buttons 18-7

screen validation 44-15

XML 22-1

generating 22-3

importing 22-4

properties 22-1

Y

Yes/No

setting default values 45-24

translating 45-45