List of Globals and Defines

Directs screen or printer output created with ?, ??, DISPLAY, or LIST to a text file.

Output filename for the Alternate file.

A string representing the morning extension for time strings in 12-hour format.

The setting that determines whether time strings are in 12-hour or 24-hour format.

The setting that determines whether database files are created using ANSI or OEM format and whether certain text file operations convert between the two character sets.

Specifies whether to pad a shorter string with spaces when making a SQL string comparison or binary expression with zero (0) bytes when making a binary expression comparison in SQL commands using the equal sign operator (=).

Specifies whether attempts to update or insert values in a field with automatically incrementing values generate errors.

Determines if production CDX files should be automatically opened. Defaults to TRUE

Determines if the first index in the production CDX should be selected. Defaults to 0 for the FoxPro dialect and 1 for the other dialects.

Turns the computer bell on or off and sets the bell attributes.

--- not used ---

Determines whether the century portion of date expressions is displaid.

Specifies a collation sequence for character fields in subsequent indexing and sorting operations. Defaults to MACHINE

Determines the current Collation mode (Windows, Clipper, Ordinal, Unicode, XPP)

Sets the colors used on the console output

Specifies whether the user can exit a text box by typing past the last character in the text box.

Enables or disables output to the console output window or to the active user-defined window from within programs.

--- not used ---

Determines whether the insertion point is displayed when Visual FoxPro waits for input.

Sets an open database as the current database or sets no current database.

Specifies the format for the display of Date and DateTime expressions.

Specifies the format for the display of Date and DateTime expressions.

--- not used ---

Directs debugging output to a file.

Specifies the number of decimal places displayed in numeric expressions.

Determines the decimal point character used in the display of numeric and currency expressions.

Specifies the default drive and directory.

Determines the current Default RDD. This is DBFVFP for the FoxPro dialect and DBFNTX for the other dialects.

Specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use with other commands.

--- not used ---

--- not used ---

Determines the name of the current Delim RDD.

Directs output from @ ... SAY to the screen, a printer, or a file.

The setting that fixes the number of digits used to display numeric output.

The setting that determines the number of digits that will be shown to the left of the decimal point when a number is displayed.

Determines the current DOS/OEM CodePage number

Change the setting that determines how dates without century digits are interpreted.

Determines whether pressing the ESC key interrupts program and command execution.

Specifies rules that Visual FoxPro uses when comparing two strings of different lengths.

Specifies whether Visual FoxPro opens table files for exclusive or shared use on a network.

--- not used ---

Determines the current field delimiter for Delim RDDs

The setting that determines whether assignments are made to fields or to memory variables.

Specifies if the number of decimal places used in the display of numeric data is fixed.

The setting that determines the point at which 2 floating point numbers would be considered equal even though they are different.

Should the FoxPro locking scheme be used for DBFCDX and DBFVFP files.

FoxPro: Should CDX(),DBF() and similar functions return full paths

Should High Performance NTX Locking be used for DBFNTX files.

Should High Performance NTX Locking be used for DBFNTX files.

--- not used ---

--- not used ---

Enables or disables automatic file locking in certain commands.

The number of times certain lock operations are retried

Sets the left printer margin and affects all output directed to the printer.

--- not used ---

--- not used ---

Specifies how X# allocates disk space for the storage of memo fields. This is 64 for the FoxPro dialect and 32 for other dialects.

Determines the current default Memofile extension.

Specifies the displayed width of memo fields and character expressions.Default is 50

--- not used ---

Determines whether you can lock multiple records using LOCK( ) or RLOCK( ). Default is OFF

Should the New Index Locking Scheme be used for DBFNTX files.

Determines how null values are supported by the ALTER TABLE, CREATE TABLE and INSERT - SQL commands.

Enables or disables Query Optimization.

Specifies a path for file searches.

A string representing the evening extension for time strings in 12-hour format.

Determines the decimal point character used in the display of numeric and currency expressions.

Enables or disables output to the printer or routes output to a file, port, or network printer.

Output filename for printer output.

Determines the current record delimiter for Delim RDDs

Determines whether to and how frequently to update local memory buffers with changes from other users on the network.

Specifies how many times and for how long Visual FoxPro attempts to lock a file or record after an unsuccessful locking attempt.

Determines whether Visual FoxPro displays a dialog box before overwriting an existing file.

The setting that controls if numbers are displaid in scientific notation.

--- not used ---

--- not used ---

Specifies the character that separates each group of three digits to the left of the decimal point when displaying a formatted numeric or currency value.

Determines where the record pointer is positioned after FIND or SEEK unsuccessfully searches for a record.

FoxPro: Add Space between ? and ?? field expressions

Specifies whether to pad a shorter string with spaces when making a SQL string comparison or binary expression with zero (0) bytes when making a binary expression comparison in SQL commands using the equal sign operator (=).

Specifies if data in a SQL - SELECT statement is based on buffered data or data written to disk.

FoxPro: Is Textmerge enabled.

Specifies the character that separates each group of three digits to the left of the decimal point when displaying a formatted numeric or currency value.

The current separation character used in time strings.

--- not used ---

Specifies whether records with duplicate index key values are maintained in an index file.

Start of User Defines Settings.

Determines the current Windows CodePage number

--- not used ---

mm/dd/yy mm/dd/yyyy

yy.mm.dd yyyy.mm.dd

BLOB Import/Export define.

BLOB Import/Export define.

BLOB Import/Export define.

BLOB Import/Export define.

dd/mm/yy dd/mm/yyyy

This define consists of a Carriage Return and a Line Feed. Unfortunately this is not properly shown in the help file, because the help file generator strips CRLF characters...

Standard table

FoxPro table

default Clipper locking scheme

extended Clipper locking scheme NTXLOCK2.OBJ

COMIX and CL53 DBFCDX hyper locking scheme

Default Harbour Locking scheme

Harbour hyper locking scheme for 32bit file API

Harbour hyper locking scheme for 64bit file API

[V]FP, CL52 DBFCDX, SIx3 SIXCDX, CDXLOCK.OBJ

DBT Memo

FPT Memo

No Memo

SMT Memo

String: Alias

Flag for automatically opening structural indexes

Should the order be set to the first index when a structural index is opened

When a network is detected, open the index shared, otherwise open exclusively

Intptr: The memo file's handle

Logic: Same as Bof()

Logical: Does the RDD support the PutRec mechanism ?

Number: Number of child relations set

Number: The Windows Codepage

Harbour extension: Codepage used also memberd by VO and Vulcan

String: Current Filter setting

Harbour extension: Decrypt table

Harbour extension: Get/Set index dirty read flag

Number: The DOS Codepage

Harbour extension: Encrypt table

Logic: Same as Eof()

Number: Number of fields per record

IntPtr: The data file's handle

Stream: The RDDs stream object

Logic: Same as Found()

String: Full path to data file

String: Get default FIELD delimiter

Numeric: Get header size of the file ?

Array: Get array of locked records

Numeric: Get record size

Object: The ScopeInfo

Logic: Is the file ansi encoded

Logical: Is the RDD DBF based ?

Harbour extension: The database is encrypted

Logic: Is there a file lock active?

Harbour extension: Was the file opened readonly?

Harbour extension: Is the table a temporary one?

Date: Last date RDD file updated

Number: Number of record locks

Number: Lock offset

Harbour extension: record / file lock test

Number: The memo block size

String: Memo file extension

Intptr: The memo file's handle

Harbour extension: Pack memo file

Stream: The memo file name

Stream: The memo file's stream

Harbour extension: Type of MEMO file: DBT, SMT, FPT

Harbour extension: sub version of memo file

Logic: Use new index lock mechanism

Harbour extension: DBOPENINFO structure pointer

Flag for whether to use query optimization

Harbour extension: orkarea password

Harbour extension: Is cursor positioned to valid record

if area represents result of a query, obtain expression of this query

Returns RDD Object.

Logic: is the file opened readonly

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Recordlist extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Recordlist extension:

Clipmore extension:

Clipmore extension:

Recordlist extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Clipmore extension:

Harbour record map extension: add record to work area record map

Harbour record map extension: remove all records from WA record map

Harbour record map extension: number of records set in record map

Harbour record map extension: create new empty work area record map

Harbour record map extension: remove record from work area record map

Harbour record map extension: add all records to WA record map

Harbour record map extension: get/set record map filter handle

Harbour record map extension: remove active work area record map

Harbour record map extension: test if record is set in WA record map

Harbour extension: Rollback changes made to current record

Harbour extension: Is given relation scoped

Harbour extension: The record separator (as a string)

String: Set default FIELD delimiter

Harbour extension: DBF header updating modes

Logic: is the file opened shared

Flag for avoiding RDD hierarchy and using a bigger buffer when indexing

String: Get table file extension

Harbour extension: Type of table file

Harbour extension: Is it destination table of currently processed COPY TO or APPEND FROM operation?

Harbour extension: Get/Set trigger function

Start of user defined DBI values

Logic: Is the buffer Valid

String: The extension of the file containing this order

String: The name of the file containing this order

FoxPro CDX Index collation

String: The order's conditional expression

Logic: Is this a Custom Index?

String: The defauly index extension

Dump the current order to a text file in the folder of the index.

String: The order's key expression

IntPtr: The handle of the index

FileStream: The stream object of the index

String: The full path to the index file (Bag)

Logic : Using High Performance locking for this order?

Alias for DBOI_BAGEXT

Alias for DBOI_BAGNAME

Logic : Does the order have a FOR condition?

Logic : Is the order DESCENDing?

Logic: Custom Index: Add key

Number: The count of keys in scope and filter

Number: The key count disregarding filter

Number: The # of decimals in a numeric key

Logic: Custom Index: Delete key

Number: The current key position in scope and filter

Number: The key number disregarding filters

Number: The current key position in scope and filter

Number: The key number disregarding filters

Number: Number of keys in the index order

Number: The length of the order's key

The type of the order's key (usualType value)

Object: The value of the current key

Number: The offset used for logical locking

String: The name of the order

Number: The numeric position in the list of orders

DBOI_OPTLEVEL define.

DBOI_OPTLEVEL define.

DBOI_OPTLEVEL define.

Number: Optimization level for current query

Number: The count of ORDERS contained in an index file or in total

Number: The current key position in scope and filter

Number: The current key position disregarding filters

Object: Get or Set the scope bottom

Void: Clear Bottom scope

Object: Get or Set the scope top

Void: Clear top scope

Block : The codeblock that produces the key

Logic: Was a skip to adjacent unique Key successful?

The following numbers are reserved but not implemented yet.

Logic : Does the order have the UNIQUE attribute?

Start of user defined values

Logic: Validate the current order. Errors are written to a text file in the folder of the index. Only supported by DBFCDX

Gets the buffer used by the RDD system for the record data. This is an array of bytes in X#.

Gets the deleted flag for the record.

Harbour: Is the current record encrypted?

Gets the locked state for the record. You may specify a specific record.

Harbour extension: Return the current record and all the memos in the current record as one string.

Harbour extension: Return all the memos in the current record as one string.

Harbour extension: Return the current record as one string.

Gets the record number.

Gets the record size. You may specify a specific record.

Gets/Sets a boolean indicating if the current record is updated.

Offset of user defined values.

Returns the length of the FieldInfo array.

Returns and optionally changes an alternate name (or alias) by which a field can be referenced (by default, same as DBS_NAME).

X# Extension: returns a blank value for the field.

Returns the length of data in a BLOB as an unsigned long integer, without referencing a particular memo field. With this constant, you must specify the BLOB using a numeric pointer obtained from BLOBDirectPut(), BLOBDirectImport(), or DBFieldInfo(DBS_BLOB_POINTER, <nFieldPos>).

Returns the type of data in a BLOB as an unsigned long integer, without referencing a particular memo field. With this constant, you must specify the BLOB using a numeric pointer obtained from BLOBDirectPut(), BLOBDirectImport(), or DBFieldInfo(DBS_BLOB_POINTER, <nFieldPos>).

Gets a BLOB value.

Returns the length of the BLOB data in a memo field as an unsigned long integer.

Returns a numeric pointer to the BLOB data associated with a memo field.

Unlike memo fields maintained in .DBT files, BLOB files allow you to store many different types of data in memo fields. This returns type type of the BLOB as a single character string.

Foxpro extension: Returns the field caption.

VFP / SQL extension: Returns the object with the complete column information.

Harbour extension: Returns the next available value for autoincrement fields.

Returns the number of decimal places for the field.

VFP / SQL extension: Returns a string describing the object (the comment).

Returns the field flags for a field (a value from the DBFFieldFlags enum)

Harbour extension: Returns the flag that indicates if a field is Nullable.

Returns the length of the field.

Returns the name of the field.

Returns the number of properties defined for a field.

Harbour extension: Returns the step value for autoincrement fields.

Return the RDD FieldInfo structure

Returns the data type of the field. This is a single character string such as 'C' or 'N'.

Start of user defined FieldInfo values.

Default DBT BlockSize

dd/mm/yy dd/mm/yyyy

mm/dd/yy mm/dd/yyyy

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

RDD Error Number.

Position in Directory() sub-array for last access date(as a date).

Position in Directory() sub-array for last access time(as a string).

Position in Directory() sub-array for file attributes(as a number).

Position in Directory() sub-array for creation date(as a date).

Position in Directory() sub-array for creation time(as a string).

Position in Directory() sub-array for last file write date(as a date).

Position in Directory() sub-array for Size of extended attributes(as a string).

Length of Directory() sub-array.

Position in Directory() sub-array for fileName (as a string).

Position in Directory() sub-array for filesize(as a numeric).

Position in Directory() sub-array for last file write time(as a string).

Position in Directory() sub-array for last file write date(as a date).

Position in Directory() sub-array for last file write time(as a string).

FCreate() attribute mode: archived

FCreate() attribute mode: hidden file

FCreate() attribute mode: normal read/write file (default for create)

FCreate() attribute mode: read-only file

FCreate() attribute mode: system file

FOpen() Sharing Mode: Compatibility mode (default)

FOpen() Sharing Mode: (same as FO_SHARED)

FOpen() Sharing Mode: Prevent other processes from reading

FOpen() Sharing Mode: Prevent other processes from writing

FOpen() Sharing Mode: Exclusive

FOpen() Open Mode: Open for reading (default)

FOpen() Open Mode: Open for reading or writing

FOpen() Sharing Mode: Allow other processes to read or write

FOpen() Open Mode: UnBuffered. Added to FO_READ, FO_WRITE and FO_READWRITE

FOpen() Open Mode: Open for writing

Default FPT BlockSize

dd/mm/yy dd/mm/yyyy

FSeek() Seek Offset: Seek from end of file

FSeek() Seek Offset: Seek from current file position

FSeek() Seek Offset: Seek from beginning of file

dd.mm.yy dd.mm.yyyy

mm/dd/yy mm/dd/yyyy

yy/mm/dd yyyy/mm/dd

mm/dd/yy mm/dd/yyyy

number of affected rows after UPDATE

automatic locking on update

Flag for automatically opening structural indexes

When a structural index is opened, the order to be set

When a network is detected, open the index shared, otherwise open exclusively

can support BLOB files directly

Can this RDD Put Records?

connect to database

Get/Set default connection

Get/Set default number of decimal places for numeric fields if it's undefined

The field delimiter (as a string)

Get/Set index dirty read flag

disconnect from database

Does RDD support encryption

error number

error description

execute SQL statement

Flag for forcing linear optimization

Get/Set default index page size

last auto insert ID

Does this RDD support DBFs?

Is large file size (>=4GB) supported

Local file access?

Get/Set record and file lock timeout value

Locking scheme used by RDD

Does this RDD support DBFs?

Default memo file's file extension

type of garbage collector used by GC

use read lock in memo file access

reuse free space on write

Type of MEMO file DB_MEMO_*: DBT, SMT, FPT(FP,SIX3,FLEXIII)

sub version of memo file

Does custom orders support repeated keys?

Does RDD support multi tag in index file

Flag for whether to use query optimization

Default multi tag index's file extension

default single tag index's file extension

default single tag index's file extension

Get/Set default password

set pending password for next open operation

set pending trigger for next open operation

last executed query

Does RDD support record map functionality?

Remote table access?

The record separator (as a string)

DBF header updating modes

Is record number part of key in sorting

Flag for avoiding RDD hierarchy and using a bigger buffer when indexing

Flag for strict structural order checking

Are structural indexes supported

Default data file's file extension

Type of table file

Get/Set default trigger function

String ID for the literal for credit

String ID for the long literal for currency

String ID for the day Sunday

String ID for the day Monday

String ID for the day Tuesday

String ID for the day Wednesday

String ID for the day Thursday

String ID for the day Friday

String ID for the day Saturday

String ID for the literal for Debit

String ID for the description of the Nation Table

String ID for the long literal for FALSE

String ID for the long literal for NO

String ID for the long literal for TRUE

String ID for the long literal for YES

String ID for the month January

String ID for the month October

String ID for the month November

String ID for the month December

String ID for the month February

String ID for the month March

String ID for the month April

String ID for the month May

String ID for the month June

String ID for the month July

String ID for the month August

String ID for the month September

String ID for the short literal for FALSE

String ID for the short literal for NO

String ID for the short literal for TRUE

String ID for the short literal for YES

String ID for the literal for Yes/No

Scope value for DbScope(), DbSetScope() and DbClearScope().

Scope value for DbScope(), DbSetScope() and DbClearScope().

Scope value for DbScope(), DbSetScope() and DbClearScope().

Default SMT Blocksize

yy/mm/dd yyyy/mm/dd

mm-dd-yy mm-dd-yyyy

yy/mm/dd yyyy/mm/dd