SIR Index		F

F

• F data type
  • DATABASE /Schema /DATA LIST
• F format
  • DATABASE /Introduction /Variable Formats
  • 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
• F parameter
  • ENVIRONMENT /Appendix /Login Procedures
• FAILFLD
  • VISUALPQL /PQLForms /10PQLForms
• FAILMESS
  • VISUALPQL /PQLForms /10PQLForms
• FAILSCR
  • VISUALPQL /PQLForms /10PQLForms
• family
  • ENVIRONMENT /Menus /Program Members
• FAMILY
  • ENVIRONMENT /Commands /SCREEN OFF
  • VISUALPQL /Execution Window /MENU
  • SQL /SET, SHOW and CLEAR /Parameter List
• FAMILY NAME function
  • VISUALPQL /Functions /List of Functions from A to Z
• FBUTTON
  • VISUALPQL /PQLForms /FBUTTON
• FDISPLAY
  • VISUALPQL /PQLForms /FDISPLAY
• FEQ function
  • VISUALPQL /Functions /List of Functions from A to Z
• Field Elements;PQLForms
  • VISUALPQL /PQLForms /PQLForms General Clauses
• field help key
  • FORMS /Using Forms /Entering Data
• FIELD INPUT
  • VISUALPQL /Execution Window /FIELD INPUT
• FIELD;command
  • VISUALPQL /PQLForms /FIELD
  • FORMS /Field /8Field
• FIELDIN
  • VISUALPQL /PQLForms /10PQLForms
• FIELDOUT
  • VISUALPQL /PQLForms /10PQLForms
• File Browse
  • VISUALPQL /Graphical User Interface /Other GUI Commands
• file browse
  • VISUALPQL /Functions /List of Functions from A to Z
• file details
  • VISUALPQL /Functions /List of Functions from A to Z
  • VISUALPQL /Functions /List of Functions from A to Z
• file dump
  • DATABASE /Data /SIR FILE DUMP
• file exists
  • VISUALPQL /Functions /List of Functions from A to Z
• File I/O Overview
  • VISUALPQL /Reading and Writing Files /5Reading and Writing Files
• file list
  • DATABASE /Data /SIR FILE LIST
• file name
  • VISUALPQL /Functions /List of Functions from A to Z
• file number
  • DATABASE /Backup /RELOAD FILE
• file ordinal
  • DATABASE /Backup /ITEMIZE FILE
• file output
  • VISUALPQL /Functions /List of Functions from A to Z
• FILECNT function
  • VISUALPQL /Functions /List of Functions from A to Z
• fileid
  • VISUALPQL /Reading and Writing Files /OPEN
  • VISUALPQL /Reading and Writing Files /READ
  • VISUALPQL /Reading and Writing Files /WRITE
• FILEIN function
  • VISUALPQL /Functions /List of Functions from A to Z
• FILEIS function
  • VISUALPQL /Functions /List of Functions from A to Z
• FILEN function
  • VISUALPQL /Functions /List of Functions from A to Z
• FILENAME
  • DATABASE /Schema /SIR SCHEMA LIST
  • VISUALPQL PROCEDURES /Overview /Common keywords
  • SQL /Control Commands /CONNECT TABFILE
  • SQL /Tabfiles and Tables /CREATE TABFILE
  • FORMS /FORM /TABFILE
• filename function
  • VISUALPQL /Functions /List of Functions from A to Z
• filename;output
  • SQL /SET, SHOW and CLEAR /Parameter List
• FILEOUT function
  • VISUALPQL /Functions /List of Functions from A to Z
• files
  • ENVIRONMENT /Menus /Run SIRSQL
• files in directory
  • VISUALPQL /Functions /List of Functions from A to Z
• 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 /List of Functions from A to Z
• FILETIME function
  • VISUALPQL /Functions /List of Functions from A to Z
• FILL
  • VISUALPQL /Execution Window /FILL
  • VISUALPQL /Execution Window /MENU
  • FORMS /Field /DSPEDIT
  • FORMS /Field /PMTEDIT
  • FORMS /AT, DRAW and TEXT /DRAW
• FILL function
  • VISUALPQL /Functions /List of Functions from A to Z
• FILLCHAR
  • VISUALPQL /Execution Window /SCROLL TEMPLATE
• FILLSTRING
  • VISUALPQL /Execution Window /SCROLL TEMPLATE
• FINAL
  • FORMS /Screens /FINAL
  • FORMS /Field /FINAL
• FINAL COMPUTE;CALL
  • FORMS /CALL /FINAL
• FIND
  • FORMS /General Clauses /ACTIVITIES
  • FORMS /CALL /MODE
• find command
  • FORMS /Using Forms /Status Area
• FIND ITEM function
  • VISUALPQL /Functions /List of Functions from A to Z
• find mode
  • FORMS /Using Forms /Status Area
• FINISH
  • ENVIRONMENT /Commands /INCLUDE BUFFER | FILE | MEMBER
• FIRST
  • VISUALPQL /PQLForms /ABUTTON
  • SQL /SELECT /Aggregation
  • FORMS /CALL /ONRETURN
• FIRST function
  • SQL /SQL Functions /Aggregation functions
• FIRST modifier
  • VISUALPQL 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
  • VISUALPQL /Variables /REAL
• FLOATING POINT
  • SQL /Tabfiles and Tables /Column Data types
• floating point compare
  • VISUALPQL /Functions /List of Functions from A to Z
• 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
• FOOTING
  • VISUALPQL PROCEDURES /Full Report /FOOTING
  • SQL /DISPLAY /Headings and Footings
  • FORMS /Compiler Directives /4Compiler Directives
• FOOTING BLOCK
  • VISUALPQL PROCEDURES /Full Report /FOOTING BLOCK
• FOOTNOTES
  • VISUALPQL PROCEDURES /Tabulate /Other Options
  • VISUALPQL PROCEDURES /Tabulate /Other Options
• FOR
  • VISUALPQL /Control Flow /FOR
  • FORMS /AT, DRAW and TEXT /DRAW
• FORM
  • VISUALPQL /PQLForms /FORM
  • FORMS /Running FORMS /15Running FORMS
• FORM command
  • FORMS /FORM /5FORM
• FORMAT
  • ENVIRONMENT /Commands /ERROR LIMIT
• format
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• FORMAT
  • VISUALPQL PROCEDURES /WRITE RECORDS /21WRITE RECORDS
• format
  • VISUALPQL PROCEDURES /WRITE RECORDS /21WRITE RECORDS
• FORMAT
  • SQL /Tabfiles and Tables /CREATE TABLE
• format expression
  • VISUALPQL PROCEDURES /CSV Save File /4CSV Save File
  • VISUALPQL PROCEDURES /Quick Report /Syntax
• format error in tabulate
  • VISUALPQL PROCEDURES /Tabulate /Error Processing
• FORMAT function
  • VISUALPQL /Functions /List of Functions from A to Z
  • FORMS /COMPUTE /Functions
• format specification
  • DATABASE /Schema /INPUT FORMAT
• format,date
  • VISUALPQL /Variables /DATE
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• format,time
  • VISUALPQL /Variables /TIME
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• 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;PRINTBACK
  • ENVIRONMENT /Appendix /Login Procedures
• FORMAT;SELECT
  • SQL /SELECT /FORMAT
• FORMAT;SEPARATOR
  • SQL /SELECT /Column Formats
• format;time
  • DATABASE /Schema /TIME VARS
• FORMAT;TIME
  • 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 - Input Specification
  • VISUALPQL /Reading and Writing Files /I/O List - Output Specification
• FORMS
  • DATABASE /Schema /WRITE SCHEMA
• forward/call key
  • FORMS /Using Forms /Flow of Control
• FORWARDS
  • FORMS /Field /LOOKUP
  • FORMS /LOOKUP /Syntax
• FP parameter
  • ENVIRONMENT /Appendix /Login Procedures
• fraction
  • VISUALPQL /Database Access /PROCESS CASE
  • VISUALPQL PROCEDURES /Overview /Common keywords
• free space
  • DATABASE /Tuning and Efficiency /Disk Space
• FREQUENCIES
  • VISUALPQL PROCEDURES /Descriptive /6Descriptive
  • VISUALPQL PROCEDURES /Frequencies /8Frequencies
• FRM
  • FORMS /Running FORMS /15Running FORMS
• FROM
  • VISUALPQL /Database Access /PROCESS REC
  • VISUALPQL /Accessing Tables /PROCESS ROWS
  • SQL /Paths and Views /CREATE PATH
• 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 /List of Functions from A to Z
• FSTR function
  • VISUALPQL /Functions /List of Functions from A to Z
• full screen debugger
  • VISUALPQL /The VisualPQL Debuggers /The Full Screen Debug Monitor
• FULLMONITOR
  • VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
• 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;MOD
  • SQL /SQL Functions /Standard Functions
• function;NOW
  • SQL /SQL Functions /Standard Functions
• function;NUM
  • SQL /SQL Functions /Standard Functions
• function;NVL
  • 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
  • VISUALPQL /Variables /Expressions
  • FORMS /COMPUTE /Functions
• functions;mathematical
  • VISUALPQL /Functions /Mathematical Functions
• functions;missing values
  • SQL /SELECT /GROUP BY
• functions;trigonometric
  • VISUALPQL /Functions /Trigonometric Functions