Home Starting Environment DBMS VisualPQL Procedures SQL Forms Host/API Index VisualPQL 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 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 PROCESS DATA 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 Alphabetic List of All Functions
14 The VisualPQL Debugger	Error Messages Overview to the VisualPQL GUI Debugger