Functions, Globals and Defines

Convert a string value to a hexadecimal string.

Write information to the Debug Terminal Program

Return a pointer to the command line used to invoke the application.

Return a constant specifying how the application window is shown.

Return the instance handle of an application or DLL.

NOTE: This is not supported in 32 bit applications. The function is kept for backward compatibility, but always returns a NULL_PTR.
Return the previous instance handle of an application or DLL.

Determine if a string matches a wildcard pattern (like the wildcard pattern for the DIR command in the OS).

Terminate application processing, close all open files, and return control to the operating system.

Convert a string containing a numeric value to a numeric data type.

Return the absolute value of a strongly typed numeric expression, regardless of its sign.

Return the absolute value of a strongly typed numeric expression, regardless of its sign.

Return the absolute value of a strongly typed numeric expression, regardless of its sign.

Return the absolute value of a strongly typed numeric expression, regardless of its sign.

Return the absolute value of a strongly typed numeric expression, regardless of its sign.

Remove spaces from a file name specified as a string.

Remove spaces from a file name specified as a string, changing the contents of the original file name as well as the returned file name.

Remove leading and trailing spaces from a string.

Programmatically define a breakpoint in an application.

Programmatically define a breakpoint in an application.

Convert a 24-hour military time to a 12-hour clock time.

Convert an array of bytes from ANSI to OEM.

Convert a string of ANSI characters to OEM characters.

Convert an array of bytes from ANSI to OEM.

Convert an array of ANSI characters to OEM characters, changing the contents of the argument as well as the return value.

Convert a string of ANSI characters to OEM characters, changing the contents of the original string as well as the returned string.

Convert a specified number of ANSI characters in a source buffer to a buffer of corresponding OEM characters.

Convert a character to its ASCII value.

Convert a character to its ASCII value.

Convert a character to its Unicode ASCII value.

Return the position of the first occurrence of a substring within a string.

Return the position of the first occurrence of a substring within a string.

Return the position of the first occurrence of a substring within a string, starting at a specified position.

Return the position of the first occurrence of a substring within a string, without regard for case.

Return the position of the first occurrence of a substring within a string, without regard for case.

Return the line number of the first occurrence of a substring within a multiple line string, without regard for case.

Return the line number of the first occurrence of a substring within a multiple line string, without regard for case.

Return the line number of the first occurrence of a substring within a multiple line string.

Return the line number of the first occurrence of a substring within a multiple line string.

This function is not implemented yet

This function is not implemented yet

Convert a string containing a 32-bit unsigned integer to a double word.

Convert a string containing a 16-bit signed integer to a short integer.

Convert a string containing a 32-bit signed integer to a long integer.

Convert a string containing a 32-bit signed integer to a long integer.

Convert a string containing an 8-bit logical into a logical value.

Convert a string containing a 32-bit floating point number to a Real4 value.

Convert a string containing a 32-bit floating point number to a Real8 value.

Convert a string containing a 16-bit unsigned integer to a word.

Return an uninitialized string of a specified size.

Convert a string value to a hexadecimal string.

Return the even-numbered characters in a string.

Return a string whose odd-numbered characters and even-numbered characters are from 2 different strings.

Return the odd-numbered characters in a string.

Return a character based on its position in a string.

Convert an ASCII code to a character value.

Convert an ASCII code to a character value, always using the Ansi codepage, ignoring the SetAnsi() setting.

Convert an ASCII code to a character value.

Format a set of numbers representing a year, month, and day as a Date.

Return the timestring from a DateTime structure

Format a set of numbers representing an hour, minute, and second as a time string.

Convert a Date string to DateTime.

Convert an ANSI date string to DateTime

Convert a string value to a logic.

Return the current Windows directory.

Return the current Windows directory.

Return the current Windows drive.

Returns the current date and time as a DateTime value, or creates a year 2000-compliant DateTime value.

Returns the current date and time as a DateTime value, or creates a year 2000-compliant DateTime value.

Returns the current date and time as a DateTime value, or creates a year 2000-compliant DateTime value.

Returns the current date and time as a DateTime value, or creates a year 2000-compliant DateTime value.

Returns the current date and time as a DateTime value, or creates a year 2000-compliant DateTime value.

Convert a specified number of seconds to days.

Register an object that will receive notification messages for Workarea events.

Unregister an object that receives notification messages for Workarea events.

Write information to the Debug Terminal Program

Decode a file from an e-mail transfer.

Change the current Windows directory.

Create a directory.

Remove a directory.

Change the current disk drive.

Return the space available on a specified disk.

Return the space available on a specified disk.

Return the space available on a specified disk.

Return the current Windows drive.

Return the capacity of the specified disk.

Return the capacity of the specified disk.

Return the capacity of the specified disk.

Return the last DOS error code associated with an activation of the runtime error block.

Return the last DOS error code associated with an activation of the runtime error block.

Return a description string for a DOS error number.

Convert a DateTime to a string.

Convert a DateTime value to a string formatted as string in ANSI format

Convert a double word to a string containing a 32-bit unsigned integer.

Return the difference between two time strings.

Encode a file for e-mail transfer.

Create an error object from an exception.

Retrieve and optionally set the X# return code.

Retrieve and optionally set the X# return code.

Return the error stack as a string.

Return the error stack as a string.

Return an error message associated with a system-generated error code.

Display file attributes as a string.

Determine the attributes of the file found after FFCount(), FFirst(), or FNext().

Change the size of a file opened with a low-level file function.

Close an open file and write the buffers to disk.

Flush file buffers.

Copy a file to a new file or to a device.

Copy a file to a new file or to a device.

Create a file or open and truncate an existing file.

Create a file or open and truncate an existing file.

Create a file or open and truncate an existing file, specifying two strongly typed arguments.

Return the date stamp of the file found by FFCount(), FFirst(), or FNext().

Determine if the file pointer is positioned at the end-of-file.

Delete a file from disk.

Get the error code for a file operation.

Set the error code for a file operation.

Get the last exception for a file operation.

Return the number of files that match a given file specification and attribute.

Find the first file that matches a given file specification or attribute.

Lock a portion of an open file.

Lock a portion of an open file.

Flush to disk a file opened with a low-level file function.

Flush to disk a file opened with a low-level file function.

UnLock a portion of an opened file.

UnLock a portion of an opened file.

Access or allocate the File I/O Buffer used by the X# Runtime for Low Level File Access for a file.

Return the filename for a file handle

Read a line from an open file.

Read a line from an open file.

Read a line from an open file, specifying two strongly typed arguments.

Access the FileStream object used by the X# Runtime for Low Level File Access

Determine if any file matches a given file specification.

Return the name of the file found by FFCount(), FFirst(), or FNext().

Find the next file that matches the file previously found by FFirst().

Open a file.

Open a file.

Open a file, specifying two strongly-typed arguments.

Return the name and path of the file that was used by File().

Write a string, a carriage-return character, and a linefeed character to an open file.

Write a string, a carriage-return character, and a linefeed character to an open file.

Write a string, a carriage-return character, and a linefeed character to an open file, specifying three strongly-typed arguments.

Read characters from a file into a buffer variable that is passed by reference.

Read characters from a file into an allocated buffer.

Read characters from a file into an allocated buffer.

Read a line from an open file.

Read a line from an open file, specifying two strongly-typed arguments.

Read characters from a file.

Read characters from a file into a buffer variable that is passed by reference.

Read characters from a file into an allocated buffer, with possible OEM to ANSI conversion, based on the current SetAnsi() setting.

Change the name of a file.

Set the file pointer at the top of an open file.

Set the file pointer to a new position, specifying three strongly-typed arguments.

Return the size of the file found by FFCount(), FFirst(), or FNext().

Returns the size in bytes of a specified file.

Returns the size in bytes of a specified file.

Return the current position of the file pointer.

Return the current position of the file pointer.

Return the time stamp of the file found by FFCount(), FFirst(), or FNext().

Write a string to an open file.

Write the contents of a buffer to an open file.

Write the contents of a buffer to an open file, with an ANSI to OEM conversion option.

Write a string, a carriage-return character, and a linefeed character to an open file.

Write a string, a carriage-return character, and a linefeed character to an open file.

Write a string, a carriage-return character, and a linefeed character to an open file, specifying two strongly-typed arguments.

Write the contents of a buffer to an open file, with SetAnsi() dependency.

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

Return and optionally change the setting that determines whether time strings are in 12-hour or 24-hour format.

Return and optionally change 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.

Get the current X# search path for opening file.

Return the current date format.

Return the X# default drive and directory.

Return the current SetDefault() setting.

Return the DOS error code from any application.

Retrieve the contents of a DOS environment variable.

Convert file attributes to numbers.

Convert file attributes to numbers.

Prepare a file specification for wildcard searching.

Get the type of the class that is used to compile macros

This function is not implemented yet

Get the current DLL for nation-dependent operations and messages.

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

Return the current separation character used in time strings.

Returns TimeZone difference for current timezone in Hours

Replace all soft carriage returns (Chr(141)) in a string with hard carriage returns (Chr(13)).

Return the high-order (leftmost) byte in a number.

Return the high-order (leftmost) word in a number.

Convert a short integer to a string containing a 16-bit signed integer.

Convert a long integer to a string containing a 32-bit signed integer.

Indicate whether a substring is contained in a string.

Determine if the leftmost character in a string is alphanumeric.

Determine if the leftmost character in a string is alphabetic.

Determine if the leftmost character in a string is alphanumeric..

Determine if the leftmost character in a string is a binary digit (0 or 1).

Determine if the leftmost character in a string is a digit (that is, a numeric digit between 0 and 9).

Determine if the leftmost character in a string is a lowercase letter.

Determine if the leftmost character in a string is a blank (that is, Chr(9) through Chr(13) or Chr(32)).

Determine if the leftmost character in a string is uppercase.

Determine if the leftmost character in a string is a hex character (that is, digits from 1 through 9 and letters from A through F).

Convert a long integer to a string containing a 32-bit signed integer.

Extract a substring beginning with the first character in a string.

Determine if a string matches a wildcard pattern (like the wildcard pattern for the DIR command in the OS).

Return the low-order (rightmost) byte in a number.

Convert a logical value to a string containing an 8-bit logical value.

Convert the uppercase and mixed case characters in a string to lowercase.

Convert the uppercase and mixed case characters in a string to lowercase, changing the contents of the argument as well as the return value.

Return the low-order (rightmost) word in a number.

Convert a logical value to a string.

Remove leading spaces from a string.

Create a DWORD from two words

Create a long from two words

Create a Short from two bytes

Create a Short from two bytes

Count the number of lines in a string or memo field.

Extract a line of text from a string.

Return the contents of a text file as a string.

Return the contents of a binary file as an array of bytes. Use this function in stead of MemoRead() to read the contents of a binary file.

Write a string to a disk file.

Write a string to a disk file.

Write binary data o a disk file. Use this function for binary files instead of MemoWrit(). This day may be read with MemoReadBinary().

Count the number of lines in a string.

Return the position of a character in a formatted string.

Extract a line of text from a string, specifying an optional offset argument.

Extract a line of text from a string, specifying an optional offset argument.

Extract a line of text from a string, specifying an optional offset argument.

Extract a line of text from a string, specifying a required offset argument.

Determine the position of a line in a string.

Return the remainder of one number divided by another number.

Return the remainder of one number divided by another number.

Return the remainder of one number divided by another number.

Detect a concurrency conflict.

Detect a concurrency conflict.

Identify the current workstation.

Convert the number that identifies a day into the name of the day.

Convert the number that identifies a month into the name of the month.

Return the number of times a substring occurs in a string.

Return the number of times a substring occurs in a string.

Return the number of times a substring occurs in a string, starting at a specified position.

Convert an array of OEM characters to ANSI characters.

Convert a string of OEM characters to ANSI characters.

Convert an array of OEM characters to ANSI characters.

Represents text as a sequence of UTF-16 code units.

Convert a string of OEM characters to ANSI characters, changing the contents of the argument as well as the return value.

Convert a specified number of OEM characters in a source buffer to a buffer of corresponding, if any, ANSI characters.

Return the operating system name.

Return the operating system name.

Return the name of the activated module.

Return the name of the activated module.

Return the name of the activated module.

Return the source line number of the last line executed in an activated entity.

Return the source line number of the last line executed in an activated entity.

Return the source line number of the last line executed in an activated entity.

Return the name of an activated entity.

Return the name of an activated entity.

Change the first character of each word to uppercase

Capitalize a proper name correctly, changing the contents of the argument as well as the return value.

Convert a intptr to a string

Return the position of the last occurrence of a substring within a string.

Return the position of the last occurrence of a substring within a string.

Return the position of the last occurrence of a substring within a string.

Return the line number of the last occurrence of a substring within a multiline string.

Return the line number of the last occurrence of a substring within a multiline string.

Convert a Real4 value to a string containing a 32-bit floating point number.

Convert a Real8 value to a string containing an 8-byte floating point number.

Register Worker function for File Search API.

Repeat a string a specified number of times.

Repeat a string a specified number of times.

Get a particular Windows color.

Return a substring beginning with the rightmost character.

Remove trailing spaces from a string.

Return the number of seconds that have elapsed since midnight.

Return a time as the number of seconds that have elapsed since midnight.

Set the morning extension for time strings in 12-hour format.

Set the morning extension for time strings in 12-hour format.

Return and optionally change the setting that determines whether time strings are in 12-hour or 24-hour format.

Return and optionally change the setting that determines whether time strings are in 12-hour or 24-hour format.

Return and optionally change 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.

Return and optionally change 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.

Return and optionally change the setting that determines whether a beep is sounded by the error system when an error occurs.

Return and optionally change the setting that determines whether a beep is sounded by the error system when an error occurs.

Return and optionally change the setting that determines whether to include or omit century digits in the date format.

Return and optionally change the setting that determines whether to include or omit century digits in the date format.

Return and optionally change the setting that determines the internal collation routine used for string comparisons.

Return and optionally change the setting that determines the internal collation routine used for string comparisons.

Return and optionally change the setting that determines the type of central processor you have.

Return and optionally change the setting that determines the type of central processor you have.

Return and optionally change the setting that determines the X# date format by selecting from a list of constants with corresponding date formats.

Return and optionally change the setting that determines the X# date format by selecting from a list of constants with corresponding date formats.

Change the setting that determines the X# date format.

Return and optionally change the setting that determines the number of decimal places used to display numbers.

Return and optionally change the setting that determines the number of decimal places used to display numbers.

Return and optionally change the setting that determines the decimal separation character to be used in numeric-to-string conversion functions.

Return and optionally change the setting that determines the decimal separation character to be used in numeric-to-string conversion functions.

Change the setting that determines the X# default drive and directory.

Change the setting that determines the X# default drive and directory.

Change the setting that determines the location of the error log file.

Change the setting that determines the location of the error log file.

Return and optionally change the setting that determines whether to ignore or include records that are marked for deletion.

Return and optionally change the setting that determines whether to ignore or include records that are marked for deletion.

Return and optionally change the setting that determines the number of digits that will be shown to the left of the decimal point when a number is displayed.

Return and optionally change the setting that determines the number of digits that will be shown to the left of the decimal point when a number is displayed.

Return and optionally change the setting that fixes the number of digits used to display numeric output.

Return and optionally change the setting that fixes the number of digits used to display numeric output.

Update or replace the contents of a DOS environment variable.

Update or replace the contents of a DOS environment variable.

Return and optionally change the setting that determines how dates without century digits are interpreted.

Return and optionally change the setting that determines how dates without century digits are interpreted.

Return and optionally change the setting that determines whether error information is written to the error log file by the default runtime error handler.

Return and optionally change the setting that determines whether error information is written to the error log file by the default runtime error handler.

Get the name of the current errorlog file

Set the name of the current errorlog file

This function allows you to enable or disable the VO compatible Errorstack format.

Toggles an exact match for character string comparisons.

Toggles an exact match for character string comparisons.

Return and optionally change the setting that determines whether to open database files in exclusive or shared mode.

Return and optionally change the setting that determines whether to open database files in exclusive or shared mode.

Return and optionally change the setting that determines whether assignments are made to fields or to memory variables.

Return and optionally change the setting that determines whether assignments are made to fields or to memory variables.

Return and optionally change the setting that fixes the number of decimal digits used to display numbers.

Return and optionally change the setting that fixes the number of decimal digits used to display numbers.

Return and optionally change the setting that determines the international mode for the application.

Return and optionally change the setting that determines the international mode for the application.

Set the type of the class that must be used to compile macros

Set the class that must be used to compile macros

Set the delegate that may be used to decide which symbol to call for ambiguous symbols

Return and optionally change the setting that determines the internal operational characteristics of the underlying floating-point system.

Return and optionally change the setting that determines the internal operational characteristics of the underlying floating-point system.

Activate a new DLL for nation-dependent operations and messages.

Change the setting that determines the X# search path for opening files.

Change the setting that determines the X# search path for opening files.

Return the Path array that is used by the File() function to locate files outside of the current directory. This is a combination of the SetDefault() and SetPath() variables. This may be null if the file function has never been called or never been called for files outside of the current directory.

Set the Path array that is used by the File() function to locate files outside of the current directory. This is a combination of the SetDefault() and SetPath() variables. This array gets cleared when SetPath() or SetDefault() is called and is initialized the first time File() or a related function

Set the evening extension for time strings in 12-hour format.

Set the evening extension for time strings in 12-hour format.

Retrieve and optionally set the time for which the RDD system caches data.

Retrieve and optionally set the time for which the RDD system caches data.

Return and optionally change the setting that displays numbers in scientific notation.

Return and optionally change the setting that displays numbers in scientific notation.

Return and optionally change the setting that determines whether a seek operation will find a close match when no exact match is found.

Return and optionally change the setting that determines whether a seek operation will find a close match when no exact match is found.

Return the setting that determines whether a space is displayed between fields or expressions when you use the ? or ?? command.

Change the setting that determines whether a space is displayed between fields or expressions when you use the ? or ?? command.

Return and optionally change the setting that determines the thousands separation character to be used in numeric-to-string conversion functions.

Return and optionally change the setting that determines the thousands separation character to be used in numeric-to-string conversion functions.

Change the setting that determines the separation character to be used in time strings.

Change the setting that determines the separation character to be used in time strings.

Return and optionally change the setting that determines whether to include unique record keys in an order.

Return and optionally change the setting that determines whether to include unique record keys in an order.

Return the length of a strongly typed string.

Convert a string to Soundex form.

Create a string of spaces.

Convert an Date string to DateTime

Delete and insert characters in a string.

Extract a substring from a string, using strong typing and only two arguments.

Extract a substring from a string, using strong typing and three required arguments.

Exchange the right and left halves of a byte.

Exchange the right and left halves of a double word.

Exchange the right and left halves of an integer.

Exchange the right and left halves of a Int64

Exchange the right and left halves of a long integer.

Exchange the right and left halves of a short integer.

Exchange the right and left halves of a word.

Calculate the Usual Type for a System Type

Return the system time in a format determined by various international settings.

Return the system time in 24-hour format.

Remove trailing spaces from a string.

Convert a specified number of seconds to a time string.

Convert a specified number of seconds to a time string.

Return a descriptive name (in upper case) for a X# (Usual) Type

Convert the lowercase and mixed case characters in a string to uppercase.

Convert the lowercase and mixed case characters in a string to uppercase, changing the contents of the argument as well as the return value.

Retrieve the buffered File IO setting for the runtime

Control the buffered File IO setting for the runtime

This function is not implemented yet

This function is not implemented yet

This function is not implemented yet

Convert a word to a string containing a 16-bit unsigned integer.

Return the currently selected working directory.

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