1 Introduction

VisualPQL Syntax

Variables

Control Flow

File I/O

Database Access

Table Access

ODBC

Graphical User Interface

Functions

Source Commands

 

2 VisualPQL Programs and Routines

RETRIEVAL, PROGRAM, SUBROUTINE

END

EXECUTE DBMS

EXECUTE SUBROUTINE

PERFORM PROCS

PQL ESCAPE

PQL EXIT DBMS

RETURN

 

3 Variables

Explicit Variable Declarations

Variable Lists

Arrays

Implicit Variables

CAT VARS

CONTROL VARS

DATE

INTEGER

MISSING VALUES

OBSERVATION VARS

REAL

SCALED VARS

STRING

TIME

VALID VALUES

VALUE LABELS

VAR LABEL

VAR RANGES

Assigning Values

Missing Values

Expressions

Database Variables

AUTOSET

COMPUTE

EVALUATE

GET VARS

PRESET

PUT VARS

RECODE

SET

EXTERNAL VARIABLE BLOCK

INCLUDE EXTERNAL VARIABLE BLOCK

DEFINE PROCEDURE VARIABLES

 

4 Control Flow

Logical Conditions

Compound Conditions

IF, IFNOT

JUMP

AFTER

BEGIN

EXIT

FOR

IFTHEN

LOOP

NEXT

UNTIL

WAIT

WHILE

SUBPROCEDURE

EXECUTE SUBPROCEDURE

 

5 Reading and Writing Files

OPEN

CLOSE

DELETE PROCEDURE FILE MEMBER

READ

I/O List - Input Specification

REREAD

WRITE

I/O List - Output Specification

 

6 Database Access

PQL CONNECT DATABASE

PQL DISCONNECT DATABASE

DATABASE IS

Case Processing Commands

CASE IS

DELETE CASE

END CASE

EXIT CASE

NEXT CASE

PREVIOUS CASE

PROCESS CASE

RESTORE CIR

Record Processing Commands

RECORD IS

DELETE RECORD

END RECORD

EXIT RECORD

NEXT RECORD

PREVIOUS RECORD

PROCESS REC

RESTORE REC

BACKUP

Processing Database Journals

PROCESS JOURNAL

JOURNAL RECORD IS

EXIT JOURNAL IS

EXIT PROCESS JOURNAL

NEXT PROCESS JOURNAL

Concurrent VisualPQL

LOOKUP

 

7 Accessing Tables

OPEN TABLE

CLOSE TABLE

PQL CONNECT TABFILE

PQL DISCONNECT TABFILE

DELETE ROW

END ROW

EXIT ROW

NEXT ROW

PREVIOUS ROW

PROCESS ROWS

ROW IS

 

8 ODBC Client

CONNECT

Statement

 

9 Graphical User Interface

WINDOW

WINDOW TITLE

WINDOW STATUS

WINDOW OUTPUT

WINDOW CLEAR

WINDOW SAVE

MENU

MENUITEM

MENUSEP

TBARITEM

TBARSEP

INITIAL

MESSAGE

ENABLE MENUITEM
DISABLE MENUITEM

CHECK MENUITEM
UNCHECK MENUITEM

DISPLAY POPUP LIST

DIALOG

BORDERS

POSTYPE

BUTTON

CHECK

CHOICE

EDIT

COMBO

SPIN

IMAGE

LABEL

LINE

LIST

RADIO

SLIDER

PROGRESS

TEXT

TREE

Dialog Message Processing

Dialog Control Commands

Other GUI Commands

DEDIT

GRID

 

10 PQLForms

Using PQLForms

PQLForms General Clauses

FORM

SCREEN

PAGE

FIELD

CALL SCREEN

FDISPLAY

ABUTTON

FBUTTON

GENERATE

PQLForms Error Messages

 

11 PQLServer

12 Buffers

CLEAR BUFFER

CREATE BUFFER

DELETE BUFFER

DELETE LINE IN BUFFER

EDIT BUFFER

GET LINE FROM BUFFER

INSERT LINE INTO BUFFER

PUT LINE TO BUFFER

DISPLAY WDL

 

13 Functions

Trigonometric Functions

Mathematical Functions

Argument List Functions

Across Record Functions

Date and Time Functions

Global Functions

String Functions

Concurrent Functions

Miscellaneous Functions

Session Functions

Schema & Database Functions

Tabfile & Table Functions

Read/Write Functions

Dialog & Menu Functions

Client/Server Functions

CGI Functions

List of Functions from A to Z

 

14 The VisualPQL Debugger

Error Messages

Overview to the VisualPQL GUI Debugger