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		F

F

• F data type
  • DATABASE /Schema /DATA LIST
• F format
  • DATABASE /Introduction /Variable Formats
  • 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
• F parameter
  • ENVIRONMENT /Appendix /Execution Parameters
• FAILFLD
  • VISUALPQL /PQLForms /PQLForms
• FAILMESS
  • VISUALPQL /PQLForms /PQLForms
• FAILSCR
  • VISUALPQL /PQLForms /PQLForms
• families
  • ENVIRONMENT /Menus /Program Members
• FAMILY
  • ENVIRONMENT /Commands /SETCLEAR
  • SQL /SET, SHOW and CLEAR /Parameter List
• FAMILY NAME function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FAMP parameter
  • ENVIRONMENT /Appendix /Execution Parameters
• FBUTTON
  • VISUALPQL /PQLForms /FBUTTON
• FDISPLAY
  • VISUALPQL /PQLForms /FDISPLAY
• FEQ function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• Field Elements;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• field help key
  • FORMS /Using Forms /Entering Data
• FIELD;command
  • FORMS /Field /Field
  • VISUALPQL /PQLForms /FIELD
• FIELDIN
  • VISUALPQL /PQLForms /PQLForms
• FIELDOUT
  • VISUALPQL /PQLForms /PQLForms
• file browse
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Graphical User Interface /Other GUI Commands
• file details
  • VISUALPQL /Functions /Alphabetic List of All Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• file dump
  • DATABASE /Data /SIR FILE DUMP
  • ENVIRONMENT /Menus /SIR File Dump
• file exists
  • VISUALPQL /Functions /Alphabetic List of All Functions
• File I/O Overview
  • VISUALPQL /Reading and Writing Files /Reading and Writing File
• file input
  • ENVIRONMENT /Menus /File Input
• file list
  • DATABASE /Data /SIR FILE LIST
• file name
  • VISUALPQL /Functions /Alphabetic List of All Functions
• file number
  • DATABASE /Backup /RELOAD FILE
• file output
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILECNT function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• fileid
  • VISUALPQL /Reading and Writing Files /OPEN
  • VISUALPQL /Reading and Writing Files /READ
  • VISUALPQL /Reading and Writing Files /WRITE
• FILEIN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILEIS function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILEN function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILENAME
  • DATABASE /Schema /SIR SCHEMA LIST
  • FORMS /FORM /TABFILE
  • PQL PROCEDURES /Overview /Common keywords
  • SQL /Control Commands /CONNECT TABFILE
  • SQL /Tabfiles and Tables /CREATE TABFILE
• filename function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• filename;output
  • SQL /SET, SHOW and CLEAR /Parameter List
• FILEOUT function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• files
  • ENVIRONMENT /Menus /File Attributes
  • ENVIRONMENT /Menus /Files
• files in directory
  • VISUALPQL /Functions /Alphabetic List of All Functions
• files;closing
  • VISUALPQL /Reading and Writing Files /CLOSE
• files;formats
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• files;introduction
  • VISUALPQL /Introduction /File I/O
• files;opening
  • VISUALPQL /Reading and Writing Files /OPEN
• files;reading
  • VISUALPQL /Reading and Writing Files /READ
• FILESTAT function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILETIME function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FILL
  • FORMS /AT, DRAW and TEXT /DRAW
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
• FILL function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FINAL
  • FORMS /Field /FINAL
  • FORMS /Screens /FINAL
• FINAL COMPUTE;CALL
  • FORMS /CALL /FINAL
• FIND
  • FORMS /CALL /
  • FORMS /General Clauses /ACTIVITIES
• find command
  • FORMS /Using Forms /Status Area
• FIND ITEM function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• find mode
  • FORMS /Using Forms /Status Area
• FINISH
  • ENVIRONMENT /Commands /FINISH
• FIRST
  • FORMS /CALL /ONRETURN
  • SQL /SELECT /Aggregation
  • VISUALPQL /PQLForms /ABUTTON
• FIRST function
  • SQL /SQL Functions /Aggregation functions
• FIRST modifier
  • PQL PROCEDURES /Tabulate /Variable Modifiers
• first record key
  • FORMS /Using Forms /Accessing Records and Rows
• FIRST;PQLForms
  • VISUALPQL /PQLForms /Using PQLForms
• FIX function
  • FORMS /COMPUTE /Functions
• FIXED
  • SQL /Tabfiles and Tables /Column Options
• FLOATING POINT
  • SQL /Tabfiles and Tables /Column Data types
  • VISUALPQL /Variables /REAL
• floating point compare
  • VISUALPQL /Functions /Alphabetic List of All Functions
• floating point variables
  • DATABASE /Introduction /Defining Variables
• FLOOR function
  • FORMS /COMPUTE /Functions
• FMT
  • SQL /Control Commands /Execution Statement
• FOCUS
  • VISUALPQL /Graphical User Interface /Dialog Message Processing
• FOCUS ITEM
  • VISUALPQL /Graphical User Interface /Dialog Control Commands
• FONT;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• FOOTING
  • FORMS /Compiler Directives /Compiler Directives
  • PQL PROCEDURES /Full Report /FOOTING
  • SQL /DISPLAY /Headings and Footings
• FOOTING BLOCK
  • PQL PROCEDURES /Full Report /FOOTING BLOCK
• FOOTNOTES
  • PQL PROCEDURES /Tabulate /Other Options
  • PQL PROCEDURES /Tabulate /Other Options
• FOR
  • FORMS /AT, DRAW and TEXT /DRAW
  • VISUALPQL /Control Flow /FOR
• FORM
  • FORMS /Running FORMS /Running FORMS
  • VISUALPQL /PQLForms /FORM
• FORM command
  • FORMS /FORM /FORM
• form painter
  • ENVIRONMENT /Menus /PQLForms Painter
• format
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
  • PQL PROCEDURES /SAS Save File /SAS Save File
  • PQL PROCEDURES /SAS Save File /SAS Save File
  • PQL PROCEDURES /WRITE RECORDS /WRITE RECORDS
  • SQL /Tabfiles and Tables /CREATE TABLE
• format expression
  • PQL PROCEDURES /CSV Save File /CSV Save File
  • PQL PROCEDURES /Quick Report /Syntax
• format error in tabulate
  • PQL PROCEDURES /Tabulate /Error Processing
• FORMAT function
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Functions /Alphabetic List of All Functions
• format specification
  • DATABASE /Schema /INPUT FORMAT
• format,date
  • DATABASE /Introduction /Defining Variables
• FORMAT;DATE
  • SQL /SELECT /Column Formats
• FORMAT;DPLACES
  • SQL /SELECT /Column Formats
• FORMAT;EXPONENT
  • SQL /SELECT /Column Formats
• FORMAT;LABEL
  • SQL /SELECT /Column Formats
• FORMAT;MISSCHAR
  • SQL /SELECT /Column Formats
• FORMAT;NAME
  • SQL /SELECT /Column Formats
• FORMAT;NULL
  • SQL /SELECT /Column Formats
• FORMAT;SELECT
  • SQL /SELECT /FORMAT
• FORMAT;SEPARATOR
  • SQL /SELECT /Column Formats
• format;time
  • DATABASE /Introduction /Defining Variables
  • SQL /SELECT /Column Formats
• FORMAT;VALLAB
  • SQL /SELECT /Column Formats
• FORMAT;WIDTH
  • SQL /SELECT /Column Formats
• FORMAT;ZEROS
  • SQL /SELECT /Column Formats
• formats;I/O
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Input Specification
• FORMS
  • DATABASE /Schema /WRITE SCHEMA
  • ENVIRONMENT /Menus /Forms & Data Entry
• forward/call key
  • FORMS /Using Forms /Flow of Control
• FORWARDS
  • FORMS /Field /LOOKUP
  • FORMS /LOOKUP /Syntax
• fraction
  • VISUALPQL /Database Access /PROCESS CASE
• free space
  • DATABASE /Tuning and Efficiency /Disk Space
• FREQUENCIES
  • PQL PROCEDURES /Descriptive /Descriptive
  • PQL PROCEDURES /Frequencies /Frequencies
• FRM
  • FORMS /Running FORMS /Running FORMS
• FROM
  • SQL /Paths and Views /CREATE PATH
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /Accessing Tables /PROCESS ROWS
• FROM update level
  • DATABASE /Backup /JOURNAL RESTORE
• FROM;CREATE VIEW
  • SQL /Paths and Views /CREATE VIEW
• FROM;multiple records
  • SQL /SELECT /FROM
• FROM;path
  • SQL /SELECT /PATHS
• FROM;SELECT
  • SQL /SELECT /FROM
• FST function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• FSTR function
  • VISUALPQL /Functions /Alphabetic List of All Functions
• function;ABS
  • SQL /SQL Functions /Standard Functions
• function;aggregation
  • SQL /SQL Functions /Aggregation functions
• function;ALL
  • SQL /SQL Functions /Standard Functions
• function;ANY
  • SQL /SQL Functions /Standard Functions
• function;AVG
  • SQL /SQL Functions /Aggregation functions
• function;COUNT
  • SQL /SQL Functions /Aggregation functions
• function;CTIME
  • SQL /SQL Functions /Standard Functions
• function;DATE
  • SQL /SQL Functions /Standard Functions
• function;DATEC
  • SQL /SQL Functions /Standard Functions
• function;EXISTS
  • SQL /SQL Functions /Standard Functions
• function;FIRST
  • SQL /SQL Functions /Aggregation functions
• function;INT
  • SQL /SQL Functions /Standard Functions
• function;LAST
  • SQL /SQL Functions /Aggregation functions
• function;LEN
  • SQL /SQL Functions /Standard Functions
• function;LOWER
  • SQL /SQL Functions /Standard Functions
• function;MAX
  • SQL /SQL Functions /Aggregation functions
• function;MAXIMUM
  • SQL /SQL Functions /Standard Functions
• function;MIN
  • SQL /SQL Functions /Aggregation functions
• function;MINIMUM
  • SQL /SQL Functions /Standard Functions
• function;MISS
  • SQL /SQL Functions /Standard Functions
• function;MOD
  • SQL /SQL Functions /Standard Functions
• function;NOW
  • SQL /SQL Functions /Standard Functions
• function;NUM
  • SQL /SQL Functions /Standard Functions
• function;RECOUNT
  • SQL /SQL Functions /Standard Functions
• function;RND
  • SQL /SQL Functions /Standard Functions
• function;SBST
  • SQL /SQL Functions /Standard Functions
• function;SIGN
  • SQL /SQL Functions /Standard Functions
• function;standard
  • SQL /SQL Functions /Standard Functions
• function;STD
  • SQL /SQL Functions /Aggregation functions
• function;SUM
  • SQL /SQL Functions /Aggregation functions
• function;TIMEC
  • SQL /SQL Functions /Standard Functions
• function;TODAY
  • SQL /SQL Functions /Standard Functions
• function;TRIM
  • SQL /SQL Functions /Standard Functions
• function;UPPER
  • SQL /SQL Functions /Standard Functions
• function;VALLAB
  • SQL /SQL Functions /Standard Functions
• functions
  • FORMS /COMPUTE /Functions
  • VISUALPQL /Variables /Expressions
• functions;mathematical
  • VISUALPQL /Functions /Mathematical Functions
• functions;missing values
  • SQL /SELECT /GROUP BY
• functions;trigonometric
  • VISUALPQL /Functions /Trigonometric Functions