Home Starting Environment DBMS VisualPQL Procedures SQL Forms Host/API Index # 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		A

A

• A data type
  • DATABASE /Schema /DATA LIST
• A format
  • DATABASE /Introduction /Variable Formats
  • DATABASE /Schema /INPUT FORMAT
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /WRITE RECORDS /WRITE RECORDS
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• a picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• ABORT
  • FORMS /Concurrency /Master Messages
  • SQL /Control Commands /Execution Statement
• ABS function
  • FORMS /COMPUTE /Functions
  • SQL /SQL Functions /Standard Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• absolute value function
  • FORMS /COMPUTE /Functions
• ABUTTON
  • VISUALPQL /PQLForms /ABUTTON
• ACCEPT
  • DATABASE /Data /ADD REC
  • FORMS /Screens /ACCEPT
• ACCEPT REC IF
  • DATABASE /Schema /ACCEPT REC IF
• ACCEPT RECORD IF
  • VISUALPQL /PQLForms /SCREEN
• ACOS function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• across record functions
  • VISUALPQL /Functions /Across Record Functions
• ACTIVITIES
  • FORMS /FORM /USERS
  • FORMS /Introduction /Security
  • FORMS /Concurrency /LOCK
  • FORMS /Screens /USERS
• activities;permissions
  • FORMS /General Clauses /ACTIVITIES
• ADD
  • DATABASE /Data /UPDATE REC
• ADD REC
  • DATABASE /Data /ADD REC
• add recs
  • ENVIRONMENT /Menus /File Input
• ADD VARS
  • DATABASE /Schema /Modifying Database Definitions
• addition function
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AFTER
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /Control Flow /AFTER
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• AFTER REPORT
  • PQL PROCEDURES /Full Report /AFTER REPORT
• aggregation functions
  • SQL /SQL Functions /Aggregation functions
  • SQL /SELECT /Aggregation
• AINT function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• alias
  • SQL /Overview /Syntax Rules
  • SQL /SELECT /Alias
• ALIMIT
  • DATABASE /Data /ADD REC
• ALL
  • DATABASE /Data /ADD REC
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
  • VISUALPQL /Variables /PUT VARS
• ALL BUT
  • SQL /DISPLAY /EXCLUDE and INCLUDE
• ALL function
  • SQL /SQL Functions /Standard Functions
• ALL, GET VARS
  • VISUALPQL /Variables /GET VARS
• ALOG function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• ALOG10 function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• alphanumeric variables
  • DATABASE /Introduction /Defining Variables
• alternate input
  • SQL /SET, SHOW and CLEAR /Parameter List
  • SQL /SET, SHOW and CLEAR /Parameter List
• alternate procedure file
  • ENVIRONMENT /Appendix /Execution Parameters
• AMOD function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AND
  • FORMS /COMPUTE /Conditions
  • VISUALPQL /Control Flow /Compound Conditions
• angle brackets
  • ENVIRONMENT /Commands /Global Variables
• ANY function
  • SQL /SQL Functions /Standard Functions
• APPDIR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• APPEND
  • VISUALPQL /Reading and Writing Files /OPEN
• APPEND ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• APPEND LINE
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• Application Directory
  • VISUALPQL /Functions /Alphabetic List of All Functions
• arc cosine function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• arc sine function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• arc tangent function
  • FORMS /COMPUTE /Functions
• ARCOS function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• arctangent function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• argument list functions
  • VISUALPQL /Functions /Argument List Functions
• Array
  • VISUALPQL /Introduction /Variables
  • VISUALPQL /Variables /Arrays
• array;declaring
  • VISUALPQL /Variables /Arrays
• array;dimensions
  • VISUALPQL /Variables /Arrays
• array;element
  • VISUALPQL /Introduction /Variables
• array;preset elements
  • VISUALPQL /Variables /PRESET
• array;redefine
  • VISUALPQL /Variables /Arrays
• array;sorting
  • VISUALPQL /Variables /Arrays
• array;subscript
  • VISUALPQL /Introduction /Variables
• array;subscripts
  • VISUALPQL /Variables /Arrays
• array;warning messages
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• ARRAYS
  • VISUALPQL /Variables /DEFINE PROCEDURE VARIABLES
• ARRDIMN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• ARRDIMST function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• ARRDIMSZ function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• arrow keys
  • FORMS /Using Forms /Entering Data
• ARSIN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AS
  • SQL /Overview /Syntax Rules
  • SQL /SELECT /Alias
• AS SELECT
  • SQL /Paths and Views /CREATE VIEW
• AS SELECT;CREATE VIEW
  • SQL /Paths and Views /CREATE VIEW
• ASIN function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• asterisk (*), use of
  • FORMS /Compiler Directives /Compiler Directives
• AT
  • FORMS /CALL /DATA
  • FORMS /Field /DATA
  • FORMS /General Clauses /AT
  • VISUALPQL /PQLForms /CALL SCREEN
• AT command
  • FORMS /AT, DRAW and TEXT /AT
  • FORMS /General Clauses /AT
• AT END BLOCK
  • PQL PROCEDURES /Full Report /AT END BLOCK
• AT;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• ATAN function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• ATTRIBUTE
  • ENVIRONMENT /Commands /ATTRIBUTE
  • PQL PROCEDURES /XML SAVE FILE /XML SAVE FILE
  • SQL /Control Commands /CREATE ATTRIBUTE
• Attribute name
  • VISUALPQL /Functions /Alphabetic List of All Functions
• attributes
  • ENVIRONMENT /Menus /File Attributes
• ATTRNAME function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AUTO
  • SQL /Control Commands /CONNECT TABFILE
  • VISUALPQL /PQLForms /FORM
  • VISUALPQL /PQLForms /SCREEN
  • VISUALPQL /PQLForms /CALL SCREEN
• AUTO CALL
  • FORMS /CALL /AUTO
• auto increment key
  • DATABASE /Schema /KEY FIELDS
• AUTO RETURN
  • FORMS /CALL /AUTO
• AUTO WRITE
  • FORMS /CALL /AUTO
  • FORMS /FORM /AUTO WRITE
  • FORMS /Screens /AUTO WRITE
• AUTODISP
  • SQL /SET, SHOW and CLEAR /Parameter List
• AutoKill Limit
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AUTOSAVE
  • SQL /SET, SHOW and CLEAR /Parameter List
• AUTOSET
  • VISUALPQL /Variables /AUTOSET
• AUTOTAB
  • FORMS /Using Forms /Flow of Control
• average
  • PQL PROCEDURES /Condescriptive /Condescriptive
  • PQL PROCEDURES /Frequencies /Frequencies
• average value function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• AVG
  • SQL /SELECT /Aggregation
• AVG function
  • SQL /SQL Functions /Aggregation functions
• AVG;SUBTOTAL
  • SQL /DISPLAY /SUBTOTAL
• AVG;TOTAL
  • SQL /DISPLAY /TOTAL
• AVGREC
  • DATABASE /Backup /RELOAD FILE