VISUALPQL		Table of Contents

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 CONTROL VARS DATE INTEGER MISSING VALUES OBSERVATION VARS REAL SCALED VARS STRING TIME VALID VALUES VALUE LABELS VAR LABELS 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 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 RETRY CASE Record Processing Commands RECORD IS DELETE RECORD END RECORD EXIT RECORD NEXT RECORD PREVIOUS RECORD PROCESS REC RESTORE REC RETRY RECORD BACKUP 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 BUTTON CHECK CHOICE EDIT IMAGE LABEL LINE LIST POSTYPE RADIO TEXT 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 Execution Window	ACCEPT CHARACTER BELL BOX CURSOR CURSOR POSITION DISPLAY TEXT ERASE SCREEN FIELD INPUT FILL LINE CHARACTER MENU SENSE MOUSE WAIT Templates DEFINE TEMPLATE POP TEMPLATE PUSH TEMPLATE RESTORE TEMPLATE SCROLL TEMPLATE STORE TEMPLATE
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 Menu Functions Client Server Functions CGI Functions List of Functions from A to Z
14 The VisualPQL Debuggers	Error Messages Overview to the Debuggers Run Time Debugger Interactive Line Mode Monitor Interactive Debugger Commands SET, CLEAR and SHOW The Full Screen Debug Monitor The Top Bar Menu Operating the full screen debugger