SIR Index		A

A

• A data type
  • DATABASE /Schema /DATA LIST
• A debug command
  • VISUALPQL /The VisualPQL Debuggers /The Top Bar Menu
• A format
  • DATABASE /Introduction /Variable Formats
  • DATABASE /Schema /INPUT FORMAT
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /WRITE RECORDS /21WRITE RECORDS
• a picture
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• ABORT
  • VISUALPQL /The VisualPQL Debuggers /Interactive Debugger Commands
  • SQL /Control Commands /Execution Statement
  • FORMS /Concurrency /Master Messages
• ABS function
  • VISUALPQL /Functions /List of Functions from A to Z
  • SQL /SQL Functions /Standard Functions
  • FORMS /COMPUTE /Functions
• absolute value function
  • FORMS /COMPUTE /Functions
• ABUTTON
  • VISUALPQL /PQLForms /ABUTTON
• ACCEPT
  • DATABASE /Data /ADD REC
  • FORMS /Screens /ACCEPT
• ACCEPT CHARACTER
  • VISUALPQL /Execution Window /ACCEPT CHARACTER
• ACCEPT REC IF
  • DATABASE /Schema /ACCEPT REC IF
• ACOS function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• across record functions
  • VISUALPQL /Functions /Across Record Functions
• activities
  • FORMS /Introduction /Security
• ACTIVITIES
  • FORMS /FORM /USERS
  • FORMS /Screens /USERS
  • FORMS /Concurrency /LOCK
• activities;permissions
  • FORMS /General Clauses /ACTIVITIES
• ADD
  • DATABASE /Data /UPDATE REC
• ADD REC
  • DATABASE /Data /ADD REC
• addition function
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• AFTER
  • VISUALPQL /Control Flow /AFTER
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• AFTER REPORT
  • VISUALPQL PROCEDURES /Full Report /AFTER REPORT
• aggregation functions
  • SQL /SELECT /Aggregation
  • SQL /SQL Functions /Aggregation functions
• AINT function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• ALIAS
  • VISUALPQL /PQLForms /SCREEN
• alias
  • SQL /Overview /Syntax Rules
• ALIAS
  • SQL /SELECT /Alias
• ALIMIT
  • DATABASE /Data /ADD REC
• ALL
  • DATABASE /Data /ADD REC
  • VISUALPQL /Variables /PUT VARS
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
• ALL BUT
  • SQL /DISPLAY /EXCLUDE and INCLUDE
• ALL function
  • SQL /SQL Functions /Standard Functions
• ALL, GET VARS
  • VISUALPQL /Variables /GET VARS
• ALOG function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• ALOG10 function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /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 /Login Procedures
• AM/PM format
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• AMOD function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• AND
  • VISUALPQL /Control Flow /Compound Conditions
  • FORMS /COMPUTE /Conditions
• angle brackets
  • ENVIRONMENT /Commands /Comments and Remarks
• ANY function
  • SQL /SQL Functions /Standard Functions
• APPDIR function
  • VISUALPQL /Functions /List of Functions from A to Z
• 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 /List of Functions from A to Z
• arc cosine function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• arc sine function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• arc tangent function
  • FORMS /COMPUTE /Functions
• ARCOS function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• arctangent function
  • VISUALPQL /Functions /List of Functions from A to Z
• ARGDUMP
  • VISUALPQL /The VisualPQL Debuggers /Run Time Debugger
• argument list functions
  • VISUALPQL /Functions /Argument List Functions
• Array
  • VISUALPQL /Introduction /Variables
• ARRAY
  • 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 /List of Functions from A to Z
• ARRDIMST function
  • VISUALPQL /Functions /List of Functions from A to Z
• ARRDIMSZ function
  • VISUALPQL /Functions /List of Functions from A to Z
• arrow keys
  • FORMS /Using Forms /Entering Data
• ARROWS
  • VISUALPQL /Execution Window /FIELD INPUT
  • VISUALPQL /Execution Window /MENU
• ARSIN function
  • VISUALPQL /Functions /List of Functions from A to Z
• 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
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• asterisk (*), use of
  • FORMS /Compiler Directives /4Compiler Directives
• AT
  • VISUALPQL /PQLForms /CALL SCREEN
  • VISUALPQL /Execution Window /ACCEPT CHARACTER
  • VISUALPQL /Execution Window /DISPLAY TEXT
  • VISUALPQL /Execution Window /FIELD INPUT
  • FORMS /General Clauses /AT
  • FORMS /Field /DATA
  • FORMS /CALL /DATA
• AT command
  • FORMS /General Clauses /AT
  • FORMS /AT, DRAW and TEXT /AT
• AT END BLOCK
  • VISUALPQL PROCEDURES /Full Report /AT END BLOCK
• AT;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• ATAN function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• ATTRIBUTE
  • ENVIRONMENT /Commands /Commands
• attribute
  • SQL /Control Commands /CREATE ATTRIBUTE
• Attribute name
  • VISUALPQL /Functions /List of Functions from A to Z
• attributes
  • ENVIRONMENT /Menus /Run SIRSQL
• ATTRNAME function
  • VISUALPQL /Functions /List of Functions from A to Z
• AUTO
  • VISUALPQL /PQLForms /FORM
  • VISUALPQL /PQLForms /SCREEN
  • VISUALPQL /PQLForms /CALL SCREEN
  • SQL /Control Commands /CONNECT DATABASE
  • SQL /Control Commands /CONNECT TABFILE
• AUTO CALL
  • FORMS /CALL /AUTO
• auto increment key
  • DATABASE /Schema /KEY FIELDS
• AUTO RETURN
  • FORMS /CALL /AUTO
• AUTO WRITE
  • FORMS /FORM /AUTO WRITE
  • FORMS /Screens /AUTO WRITE
  • FORMS /CALL /AUTO
• AUTODISP
  • SQL /SET, SHOW and CLEAR /Parameter List
• AUTOSAVE
  • SQL /SET, SHOW and CLEAR /Parameter List
• AUTOSET
  • VISUALPQL /Variables /AUTOSET
• AUTOTAB
  • VISUALPQL /Execution Window /FIELD INPUT
  • FORMS /Using Forms /Flow of Control
• average
  • VISUALPQL PROCEDURES /Condescriptive /3Condescriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• average value function
  • VISUALPQL /Functions /List of Functions from A to Z
• 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