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
D
D
D data type
DATABASE /Schema /DATA LIST
D dollar sign
PQL PROCEDURES /CSV Save File /CSV Save File
PQL PROCEDURES /Quick Report /Syntax
D 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
d picture
VISUALPQL /Reading and Writing Files /I/O List - Input Specification
DATA
FORMS /Field /DATA
VISUALPQL /PQLForms /PQLForms General Clauses
data area
FORMS /Using Forms /Entering Data
data block
DATABASE /Tuning and Efficiency /Disk Space
DATABASE /Tuning and Efficiency /Block Organisation
data dump
ENVIRONMENT /Menus /SIR File Dump
Data Entry
ENVIRONMENT /Menus /Forms & Data Entry
SQL /Data Entry and Modification /Data Entry and Modification
DATA FILES
DATABASE /Schema /DATA FILES
ENVIRONMENT /Menus /DATA FILES
data format function
VISUALPQL /Functions /Alphabetic List of All Functions
data input
ENVIRONMENT /Menus /File Input
DATA LIST
DATABASE /Schema /DATA LIST
Data Sources ODBC
ENVIRONMENT /ODBC /ODBC
data storage
DATABASE /Tuning and Efficiency /Disk Space
data type change;number to stri
FORMS /COMPUTE /Functions
data type change;string to numb
FORMS /COMPUTE /Functions
data type function
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Alphabetic List of All Functions
data types
DATABASE /Introduction /Defining Variables
data width
FORMS /General Clauses /PAD
DATA;CALL
FORMS /CALL /DATA
Data;PQLForms
VISUALPQL /PQLForms /PQLForms General Clauses
DATABASE
FORMS /FORM /DATABASE
PQL PROCEDURES /SIR Save File /SIR Save File
database access
VISUALPQL /Introduction /Database Access
Database Access Overview
VISUALPQL /Database Access /Database Access
Database Definition
DATABASE /Schema /Schema
database functions
VISUALPQL /Functions /Schema & Database Functions
DATABASE IS
VISUALPQL /Database Access /DATABASE IS
DATABASE LABEL
DATABASE /Schema /DATABASE LABEL
database name function
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Alphabetic List of All Functions
database password
DATABASE /Schema /CREATE DATABASE
database password specification
DATABASE /Schema /CONNECT DATABASE
database prefix
DATABASE /Schema /CREATE DATABASE
DATABASE /Schema /CONNECT DATABASE
database schema
ENVIRONMENT /Menus /Database Settings
database settings
ENVIRONMENT /Menus /Database Settings
database statistics
DATABASE /Backup /LIST STATS
database subset
PQL PROCEDURES /SIR Save File /SIR Save File
database type function
VISUALPQL /Functions /Alphabetic List of All Functions
Database Variables
VISUALPQL /Variables /Database Variables
DATABASE, PQL CONNECT
VISUALPQL /Database Access /PQL CONNECT DATABASE
DATABASE, PQL DISCONNECT
VISUALPQL /Database Access /PQL DISCONNECT DATABASE
database;CONNECT
SQL /Control Commands /CONNECT DATABASE
database;index
DATABASE /Tuning and Efficiency /Disk Space
database;loading factor
DATABASE /Tuning and Efficiency /Disk Space
database;read-only access
FORMS /FORM /DATABASE
database;subset
DATABASE /Tuning and Efficiency /Disk Space
database;write access
FORMS /FORM /DATABASE
databases;defining records
DATABASE /Schema /RECORD SCHEMA
databases;estimating size
DATABASE /Tuning and Efficiency /Size Estimating
databases;maximum number of rec
DATABASE /Schema /N OF RECORDS
databases;maximum records
DATABASE /Schema /MAX REC COUNT
databases;read security passwor
DATABASE /Schema /READ SECURITY
databases;record security
DATABASE /Schema /REC SECURITY
databases;records per case
DATABASE /Schema /RECS PER CASE
databases;restructuring
DATABASE /Schema Modification /Database Restructure
databases;security
DATABASE /Schema /SYSTEM SECURITY
databases;statistics
DATABASE /Tuning and Efficiency /Block Organisation
DATABASE /Tuning and Efficiency /Size Estimating
databases;structure
DATABASE /Tuning and Efficiency /Database Internal Structure
databases;write security
DATABASE /Schema /WRITE SECURITY
DATAVARS
FORMS /GENERATE /Syntax
date
ENVIRONMENT /Commands /System Globals
FORMS /Field /TYPE
FORMS /Field /DSPTYPE
PQL PROCEDURES /CSV Save File /CSV Save File
PQL PROCEDURES /Quick Report /Syntax
PQL PROCEDURES /Quick Report /Syntax
SQL /SET, SHOW and CLEAR /Parameter List
SQL /Tabfiles and Tables /Column Data types
VISUALPQL /Reading and Writing Files /I/O List - Input Specification
VISUALPQL /Reading and Writing Files /I/O List - Output Specification
VISUALPQL /Introduction /Variables
VISUALPQL /Variables /DATE
DATE data type
DATABASE /Schema /DATA LIST
date format
DATABASE /Introduction /Variable Formats
date functions
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Alphabetic List of All Functions
VISUALPQL /Functions /Date and Time Functions
date functions;JULN
VISUALPQL /Functions /Alphabetic List of All Functions
date map;system default
SQL /SET, SHOW and CLEAR /Parameter List
date variables
DATABASE /Introduction /Defining Variables
DATABASE /Schema /DATE VARS
VISUALPQL /Variables /DATE
DATE VARS
DATABASE /Schema /DATE VARS
DATE;FORMAT
SQL /SELECT /Column Formats
DATE;function
FORMS /COMPUTE /Functions
DATE;in headings
SQL /DISPLAY /Headings and Footings
DATEC function
FORMS /COMPUTE /Functions
SQL /SQL Functions /Standard Functions
VISUALPQL /Functions /Alphabetic List of All Functions
DATEMAP function
VISUALPQL /Functions /Alphabetic List of All Functions
dates;missing values
DATABASE /Schema /MISSING VALUES
DATET function
FORMS /COMPUTE /Functions
VISUALPQL /Functions /Alphabetic List of All Functions
DB
SQL /Control Commands /Database Parameters
DB parameter
ENVIRONMENT /Appendix /Execution Parameters
DBA
DATABASE /Schema /READ SECURITY
DBASE SAVE FILE
PQL PROCEDURES /DBASE Save File /DBASE Save File
DBDEF
DATABASE /Schema /WRITE SCHEMA
DBINDN function
VISUALPQL /Functions /Alphabetic List of All Functions
DBINDR function
VISUALPQL /Functions /Alphabetic List of All Functions
DBINDS function
VISUALPQL /Functions /Alphabetic List of All Functions
DBINDT function
VISUALPQL /Functions /Alphabetic List of All Functions
DBINDU function
VISUALPQL /Functions /Alphabetic List of All Functions
DBINDV function
VISUALPQL /Functions /Alphabetic List of All Functions
DBMS Command
ENVIRONMENT /Menus /DBMS Command
DBMS;on SELECT
SQL /SELECT /Keywords
DBNAME function
VISUALPQL /Functions /Alphabetic List of All Functions
DBTYPE function
VISUALPQL /Functions /Alphabetic List of All Functions
DEBUG
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
debugger
ENVIRONMENT /Menus /PQL Debugger
VISUALPQL /The VisualPQL Debugger /The VisualPQL Debugger
DECIMAL
SQL /Tabfiles and Tables /Column Data types
decimal points
DATABASE /Introduction /Variable Label
DATABASE /Introduction /Variable Label
DECLARE
FORMS /FORM /
DECRYPT function
VISUALPQL /Functions /Alphabetic List of All Functions
DEDIT
VISUALPQL /Graphical User Interface /DEDIT
DEDIT MESSAGE
VISUALPQL /Graphical User Interface /DEDIT
DEFAULT
FORMS /Field /DEFAULT
Default Family name
VISUALPQL /Functions /Alphabetic List of All Functions
default form
FORMS /Introduction /Default form
Default member name
VISUALPQL /Functions /Alphabetic List of All Functions
Default tabfile name
VISUALPQL /Functions /Alphabetic List of All Functions
default;family
SQL /SET, SHOW and CLEAR /Parameter List
default;member
SQL /SET, SHOW and CLEAR /Parameter List
default;tabfile
SQL /SET, SHOW and CLEAR /Parameter List
default;time map
SQL /SET, SHOW and CLEAR /Parameter List
default;workspace
SQL /SET, SHOW and CLEAR /Parameter List
DEFFAM function
VISUALPQL /Functions /Alphabetic List of All Functions
DEFINDEX
ENVIRONMENT /Commands /SETCLEAR
DEFINE TABFILE
DATABASE /Tabfiles and Tables /CREATE TABFILE
DEFINE PROCEDURE VARIABLES
VISUALPQL /Variables /DEFINE PROCEDURE VARIABLES
DEFINE_SECURITY
SQL /SET, SHOW and CLEAR /Parameter List
SQL /Tabfiles and Tables /REVOKE
DEFMEM function
VISUALPQL /Functions /Alphabetic List of All Functions
DEFTABLE
ENVIRONMENT /Commands /SETCLEAR
DEFTFN function
VISUALPQL /Functions /Alphabetic List of All Functions
DELDIR function
VISUALPQL /Functions /Alphabetic List of All Functions
DELETE
FORMS /General Clauses /ACTIVITIES
VISUALPQL /Reading and Writing Files /OPEN
VISUALPQL /Reading and Writing Files /CLOSE
VISUALPQL /PQLForms /SCREEN
VISUALPQL /PQLForms /ABUTTON
DELETE BUFFER
VISUALPQL /Buffers /DELETE BUFFER
DELETE CASE
VISUALPQL /Database Access /DELETE CASE
delete character key
FORMS /Using Forms /Entering Data
Delete Client
VISUALPQL /Functions /Alphabetic List of All Functions
delete command
FORMS /Using Forms /Accessing Records and Rows
delete database
ENVIRONMENT /Menus /Delete Database
Delete directory
VISUALPQL /Functions /Alphabetic List of All Functions
DELETE FAMILY
ENVIRONMENT /Commands /DELETE FAMILY
Delete file
VISUALPQL /Functions /Alphabetic List of All Functions
DELETE FROM
SQL /Data Entry and Modification /DELETE FROM
DELETE LINE IN BUFFER
VISUALPQL /Buffers /DELETE LINE IN BUFFER
DELETE MEMBER
ENVIRONMENT /Commands /DELETE MEMBER
DELETE PROCEDURE FILE MEMBER
VISUALPQL /Reading and Writing Files /DELETE PROCEDURE FILE MEMBER
DELETE RECORD
VISUALPQL /Database Access /DELETE RECORD
DELETE ROW
VISUALPQL /Accessing Tables /DELETE ROW
DELETE SCHEMA
DATABASE /Schema /DELETE SCHEMA
DATABASE /Schema Modification /DELETE SCHEMA
DELETE STANDARD SCHEMA
DATABASE /Schema /DELETE SCHEMA
DELETE VARS
DATABASE /Schema /Modifying Database Definitions
DELETE;CALL AUTO
FORMS /CALL /AUTO
DELETE;PQLForms
VISUALPQL /PQLForms /Using PQLForms
DELETEMISSING
PQL PROCEDURES /Tabulate /Other Options
PQL PROCEDURES /Tabulate /Other Options
deleting a database
DATABASE /Schema /PURGE SIR FILE
deleting records
FORMS /Using Forms /Accessing Records and Rows
deleting records automatically
FORMS /CALL /AUTO
DELFILE function
VISUALPQL /Functions /Alphabetic List of All Functions
delineating fields
FORMS /General Clauses /CLEAR
DELMCLID function
VISUALPQL /Functions /Alphabetic List of All Functions
DESCRIPTIVE
PQL PROCEDURES /Descriptive /Descriptive
DETAIL
PQL PROCEDURES /Quick Report /Syntax
SQL /SET, SHOW and CLEAR /Parameter List
DETAIL BLOCK
PQL PROCEDURES /Full Report /DETAIL BLOCK
detail line
PQL PROCEDURES /Quick Report /Quick Report
detail lines
SQL /SET, SHOW and CLEAR /Parameter List
DETAILED
DATABASE /Schema /SIR SCHEMA LIST
DGLOBAL function
VISUALPQL /Functions /Alphabetic List of All Functions
DIALOG
VISUALPQL /Graphical User Interface /DIALOG
Dialog Design
VISUALPQL /Graphical User Interface /Other GUI Commands
dialog painter
ENVIRONMENT /Menus /Dialog Painter
DIF SAVE FILE
PQL PROCEDURES /DIF Save File /DIF Save File
Difference File Copy function
VISUALPQL /Functions /Alphabetic List of All Functions
DIM
FORMS /General Clauses /video_options
dimension
VISUALPQL /Variables /Arrays
dimensions
VISUALPQL /Introduction /Variables
directory
FORMS /Concurrency /Concurrency
FORMS /Using Forms /Using Forms
DISABLE ITEM
VISUALPQL /Graphical User Interface /Dialog Control Commands
DISABLE MENUITEM
VISUALPQL /Graphical User Interface /ENABLE MENUITEMDISABLE MENUITEM
DISABLE TIMER
VISUALPQL /Graphical User Interface /Dialog Message Processing
DISCONNECT
SQL /Control Commands /DISCONNECT
DISCONNECT DATABASE
DATABASE /Schema /DISCONNECT DATABASE
DISCONNECT DATABASE, PQL
VISUALPQL /Database Access /PQL DISCONNECT DATABASE
DISCONNECT ODBC
VISUALPQL /ODBC Client /CONNECT
disk space
DATABASE /Tuning and Efficiency /Disk Space
PQL PROCEDURES /Overview /Procedure Table
DISPLAY
FORMS /Field /DISPLAY
SQL /DISPLAY /DISPLAY
display area size
FORMS /General Clauses /
Display Error box
VISUALPQL /Graphical User Interface /Other GUI Commands
Display Info box
VISUALPQL /Graphical User Interface /Other GUI Commands
DISPLAY JOURNAL
SQL /Tabfiles and Tables /DISPLAY JOURNAL
Display OK/Cancel box
VISUALPQL /Graphical User Interface /Other GUI Commands
Display Open box
VISUALPQL /Graphical User Interface /Other GUI Commands
DISPLAY POPUP LIST
VISUALPQL /Graphical User Interface /DISPLAY POPUP LIST
Display SAVE box
VISUALPQL /Graphical User Interface /Other GUI Commands
Display Text box
VISUALPQL /Graphical User Interface /Other GUI Commands
DISPLAY WDL
VISUALPQL /Buffers /DISPLAY WDL
Display Yes/No box
VISUALPQL /Graphical User Interface /Other GUI Commands
Display Yes/No/Cancel box
VISUALPQL /Graphical User Interface /Other GUI Commands
DISPLAY;automatic execution
SQL /SET, SHOW and CLEAR /Parameter List
DISPLAY;BREAK
SQL /DISPLAY /Grouping and Totalling
DISPLAY;COLUMN
SQL /DISPLAY /Formatting Commands
DISPLAY;GROUP
SQL /DISPLAY /Grouping and Totalling
DISPLAY;INCLUDE
SQL /DISPLAY /EXCLUDE and INCLUDE
DISPLAY;OFF
SQL /DISPLAY /Grouping and Totalling
DISPLAY;ON
SQL /DISPLAY /Grouping and Totalling
DISPLAY;OUTLINE
SQL /DISPLAY /Grouping and Totalling
DISTINCT
SQL /SELECT /Output
DITEM function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMCOL function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMH function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMID function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMROW function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMS function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMSEL function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMSID function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMTXT function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMTYP function
VISUALPQL /Functions /Alphabetic List of All Functions
DITEMW function
VISUALPQL /Functions /Alphabetic List of All Functions
DO REPEAT
ENVIRONMENT /Commands /DO REPEAT
DOCUMENT
DATABASE /Schema /DOCUMENT
DATABASE /Schema /DOCUMENT
documentation
DATABASE /Schema /VAR DOC
DOLLAR
FORMS /Field /DSPEDIT
FORMS /Field /DSPEDIT
PQL PROCEDURES /Tabulate /Print Formatting
dollar sign
PQL PROCEDURES /CSV Save File /CSV Save File
PQL PROCEDURES /Quick Report /Syntax
DOUBLE
PQL PROCEDURES /Quick Report /Syntax
SQL /SET, SHOW and CLEAR /Parameter List
DOUBLE PRECISION
SQL /Tabfiles and Tables /Column Data types
DOWNLOAD
DATABASE /Backup /DOWNLOAD
download journal
ENVIRONMENT /Menus /Download Journal
DPLACES
SQL /SET, SHOW and CLEAR /Parameter List
DPLACES;FORMAT
SQL /SELECT /Column Formats
DPOINT
DATABASE /Data /SIR FILE DUMP
Drag and Drop
VISUALPQL /Graphical User Interface /MESSAGE
DRAW
FORMS /AT, DRAW and TEXT /DRAW
DRAW CHARACTER
FORMS /AT, DRAW and TEXT /DRAW
DROP
SQL /Control Commands /DROP
DROP DBINDEX
DATABASE /Schema /CREATE DBINDEX
DROPFILE
VISUALPQL /Graphical User Interface /MESSAGE
DSN
VISUALPQL /Reading and Writing Files /OPEN
DSN function
VISUALPQL /Functions /Alphabetic List of All Functions
DSPEDIT
FORMS /Field /DSPEDIT
DSPTYPE
FORMS /Field /DSPTYPE
DTD
PQL PROCEDURES /XML SAVE FILE /XML SAVE FILE
DTTOTS function
VISUALPQL /Functions /Alphabetic List of All Functions
DUMMY
PQL PROCEDURES /Tabulate /Other Options
PQL PROCEDURES /Tabulate /Other Options
dummy columns
PQL PROCEDURES /DBASE Save File /DBASE Save File
dump file
ENVIRONMENT /Menus /SIR File Dump
dumping data
DATABASE /Data /SIR FILE DUMP
DYNAMIC
VISUALPQL /Reading and Writing Files /OPEN
VISUALPQL /Reading and Writing Files /READ
VISUALPQL /Reading and Writing Files /WRITE
VISUALPQL /VisualPQL Programs and Routines /RETRIEVAL, PROGRAM, SUBROUTINE
VISUALPQL /VisualPQL Programs and Routines /EXECUTE SUBROUTINE