Click or drag to resize

List of Functions

X#

The Functions type exposes the following members.

Functions
  NameDescription
Public methodStatic memberCode exampleAClass
-- todo --
Public methodStatic memberCode exampleADatabases
Places the names of all open databases and their paths into a variable array.
Public methodStatic memberCode exampleADBObjects
-- todo --
Public methodStatic memberAddBs
Adds a backslash (if needed) to a path expression.
Public methodStatic memberAddProperty
Adds a new property to an object at run time.
You can use AddProperty( ) to add properties and their values to valid X# objects, including those created from X# classes, COM classes, and the SCATTER...NAME command.
Public methodStatic memberCode exampleADel(Array, Long, Long)
Deletes an element from a one-dimensional array, or a row or column from a two-dimensional array.
Public methodStatic memberCode exampleADel(FoxArray, Long, Long)
Deletes an element from a one-dimensional array, or a row or column from a two-dimensional array.
Public methodStatic memberADLLS Obsolete.
Public methodStatic memberADOCKSTATE Obsolete.
Public methodStatic memberAElement(FoxArray, DWord)
Returns the number of an array element from the element's subscripts.
Public methodStatic memberAElement(FoxArray, DWord, DWord)
Returns the number of an array element from the element's subscripts.
Public methodStatic memberAERROR Obsolete.
Public methodStatic memberAEVENTS Obsolete.
Public methodStatic memberAFONT Obsolete.
Public methodStatic memberAGETCLASS Obsolete.
Public methodStatic memberAGetFileVersion
-- todo --
Public methodStatic memberCode exampleAIns(Array, DWord, DWord)
Inserts an element into a one-dimensional array, or a row or column into a two-dimensional array.
Public methodStatic memberCode exampleAIns(FoxArray, DWord, DWord)
Inserts an element into a one-dimensional array, or a row or column into a two-dimensional array.
Public methodStatic memberAINSTANCE Obsolete.
Public methodStatic memberALANGUAGE Obsolete.
Public methodStatic memberCode exampleALen(FoxArray)
Returns the number of elements, rows, or columns in an array.
Public methodStatic memberCode exampleALen(FoxArray, Long)
Returns the number of elements, rows, or columns in an array.
Public methodStatic memberCode exampleALines
-- todo --
Public methodStatic memberCode exampleAllTrim
Remove leading and trailing spaces from a string.
Public methodStatic memberCode exampleAMembers
-- todo --
Public methodStatic memberAMOUSEOBJ Obsolete.
Public methodStatic memberANetResources
-- todo --
Public methodStatic memberCode exampleAPrinters
Stores information about currently-available printers into an array.
The behavior of this function is OS (operating system) - specific. X# may or may not check to see if the printers are actually connected to your computer when it prepares this list, and the list may include all printers installed as printer setups, or only those available on the current network.
Public methodStatic memberAPROCINFO Obsolete.
Public methodStatic memberASELOBJ Obsolete.
Public methodStatic memberASessions
-- todo --
Public methodStatic memberASize
Public methodStatic memberASqlHandles
Stores numeric references to all active SQL connection statement handles in an array.
Public methodStatic memberCode exampleAStackInfo
-- todo --
Public methodStatic memberASubScript
Returns the row or column subscript of an element from the element's number.
Public methodStatic memberAt
Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character.
Public methodStatic memberAt_C
Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character.
Public methodStatic memberATagInfo
-- todo --
Public methodStatic memberAtC
Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, without regard for the case of these two expressions.
Public methodStatic memberAtCC
Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, without regard for the case of these two expressions.
Public methodStatic memberCode exampleAUsed
-- todo --
Public methodStatic memberAVCXCLASSES Obsolete.
Public methodStatic memberBagCount
Returns the number of open .cdx files.
Public methodStatic memberBAR Obsolete.
Public methodStatic memberBARCOUNT Obsolete.
Public methodStatic memberBARPROMPT Obsolete.
Public methodStatic memberBINDEVENT Obsolete.
Public methodStatic memberBinToc
Public methodStatic memberCode exampleBitAnd(Long, Long)
Performs a bitwise AND operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitAnd(Binary, Binary)
Performs a bitwise AND operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitAnd(Usual, Usual)
Performs a bitwise AND operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitClear(Binary)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Usual)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Long, Long)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Binary, Long)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Usual, Usual)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Binary, Long, Long)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitClear(Usual, Usual, Usual)
Clears the specified bit in a Numeric, Varbinary, or Blob value by setting it to 0 and returns the resulting value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitLShift(Long, Long)
Moves bits in a numeric value to the left by the specified number of positions and returns the resulting value. If the specified expressions are not integers, they are converted to integers before performing the operation.
Public methodStatic memberCode exampleBitLShift(Usual, Usual)
Moves bits in a numeric value to the left by the specified number of positions and returns the resulting value. If the specified expressions are not integers, they are converted to integers before performing the operation.
Public methodStatic memberCode exampleBitNot(Long)
Performs a bitwise NOT operation on a value of Numeric, Varbinary, or Blob type and returns the bitwise complement on the specified value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitNot(Binary)
Performs a bitwise NOT operation on a value of Numeric, Varbinary, or Blob type and returns the bitwise complement on the specified value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitNot(Usual)
Performs a bitwise NOT operation on a value of Numeric, Varbinary, or Blob type and returns the bitwise complement on the specified value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitNot(Binary, Long, Long)
Performs a bitwise NOT operation on a value of Numeric, Varbinary, or Blob type and returns the bitwise complement on the specified value. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitOr(Long, Long)
Perform a bitwise inclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitOr(Binary, Binary)
Perform a bitwise inclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitOr(Usual, Usual)
Perform a bitwise inclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitRShift
Moves bits in a numeric value to the right by the specified number of positions and returns the resulting value. If the specified expressions are not integers, they are converted to integers before performing the operation.
Public methodStatic memberCode exampleBitSet(Binary)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Usual)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Long, Long)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Binary, Long)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Usual, Usual)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Binary, Long, Long)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitSet(Usual, Usual, Usual)
Sets a bit to 1 in a value of Numeric, Varbinary, or Blob type and returns the resulting value. There is a numeric and a binary version of the syntax.
If the specified expression is not an integer, it is converted to an integer before setting the bit.
Public methodStatic memberCode exampleBitTest(Long, Long)
Determines whether a specific bit in a Numeric, Varbinary, or Blob value is set to 1. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitTest(Binary, Long)
Determines whether a specific bit in a Numeric, Varbinary, or Blob value is set to 1. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitTest(Usual, Usual)
Determines whether a specific bit in a Numeric, Varbinary, or Blob value is set to 1. There is a numeric and a binary version of the syntax. If the specified expression is not an integer, it is converted to an integer before performing the operation.
Public methodStatic memberCode exampleBitXor(Long, Long)
Perform a bitwise exclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitXor(Binary, Binary)
Perform a bitwise exclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCode exampleBitXor(Usual, Usual)
Perform a bitwise exclusive OR operation on two or more values of Numeric, Varbinary, or Blob type and returns the result. There is a numeric and a binary version of the syntax.
Public methodStatic memberCandidate
Public methodStatic memberCode exampleCapsLock
Returns the current mode of the CAPS Lock key or sets the CAPS Lock key mode on or off.
Public methodStatic memberCode exampleCapsLock(Logic)
Returns the current mode of the CAPS Lock key or sets the CAPS Lock key mode on or off.
Public methodStatic memberCode exampleCdx
Returns the names of the open compound index (.cdx) file that has the specified index position number.
Public methodStatic memberCode exampleCeiling
-- todo --
Public methodStatic memberCode exampleChrTran
Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression.
Public methodStatic memberChrTranC
Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression.
Public methodStatic memberCOMARRAY Obsolete.
Public methodStatic memberCOMCLASSINFO Obsolete.
Public methodStatic memberCode exampleCompObj
-- todo --
Public methodStatic memberCOMPROP Obsolete.
Public methodStatic memberCOMRETURNERROR Obsolete.
Public methodStatic memberCpConvert
-- todo --
Public methodStatic memberCpCurrent Obsolete.
-- todo --
Public methodStatic memberCpDbf
Returns the code page with which an open table has been marked.
Public methodStatic memberCREATEBINARY Obsolete.
-- todo --
Public methodStatic memberCreateObject
Creates an object from a class definition or an Automation-enabled application.
Public methodStatic memberCode exampleCreateObjectEx
Creates an instance of a registered COM object (such as a X# Automation server) on a remote computer.
Public methodStatic memberCreateOffline
-- todo --
Public methodStatic memberCToBin
-- todo --
Public methodStatic memberCToT
-- todo --
Public methodStatic memberCode exampleCursorGetProp
-- todo --
Public methodStatic memberCode exampleCursorSetProp
-- todo --
Public methodStatic memberCursorToXML
-- todo --
Public methodStatic memberCode exampleCurVal
-- todo --
Public methodStatic memberCode exampleDbAlias
Returns database alias of currently set database.
Public methodStatic memberDbAppDelimFox
Public methodStatic memberDbAppendFromArray
Public methodStatic memberDbAppFox
Public methodStatic memberCode exampleDbc
Returns the name and path of the current database.
Public methodStatic memberDbCopyDelimFox
Public methodStatic memberDbCopyFox
Public methodStatic memberDbCopyStructFox
Public methodStatic memberDbCopyToArray
Public methodStatic memberDbCopyXStructFox
Public methodStatic memberCode exampleDbGetProp
Retrieves the value of a property for the current database or for fields, named connections, tables, or views in the current database.
Note Note
You must open the database before you can retrieve its properties or those of its connections, tables, views, or fields. However, you do not need to open a table or view before retrieving its properties.
Public methodStatic memberDbSeekFox
Public methodStatic memberCode exampleDbSetProp
Sets a property for the current database or for fields, named connections, tables, or views in the current database.
Public methodStatic memberCode exampleDbSortFox
Copy records to a database file in sorted order.
Public methodStatic memberDbUseAreaFox
Open a database file.
Public methodStatic memberCode exampleDbUsed
Returns true (.T.) if the specified database is open.
Public methodStatic memberDDEAbortTrans Obsolete.
Public methodStatic memberDDEAdvise Obsolete.
Public methodStatic memberDDEEnabled Obsolete.
Public methodStatic memberDDEExecute Obsolete.
Public methodStatic memberDDEInitiate Obsolete.
Public methodStatic memberDDELastError Obsolete.
Public methodStatic memberDDEPoke Obsolete.
Public methodStatic memberDDERequest Obsolete.
Public methodStatic memberDDESetOption Obsolete.
Public methodStatic memberDDESetService Obsolete.
Public methodStatic memberDDESetTopic Obsolete.
Public methodStatic memberDDETerminate Obsolete.
Public methodStatic memberDefaultExt
-- todo --
Public methodStatic memberCode exampleDescending
Returns a logical value that indicates whether an index tag was created with the Descending keyword or whether the Descending keyword was included in Use, Set Index, or Set Order.
Public methodStatic memberCode exampleDifference
-- todo --
Public methodStatic memberDisplayPath
-- todo --
Public methodStatic memberCode exampleDMY(DateTime)
Returns a character expression in day-month-year format (for example, 31 May 1998) from a Date or DateTime expression. The month name isn't abbreviated.
Public methodStatic memberCode exampleDMY(Date)
Returns a character expression in day-month-year format (for example, 31 May 1998) from a Date or DateTime expression. The month name isn't abbreviated.
Public methodStatic memberDriveType
-- todo --
Public methodStatic memberDropOffLine
-- todo --
Public methodStatic memberCode exampleDToT
Returns a DateTime value from a Date expression.
Public methodStatic memberEDITSOURCE Obsolete.
Public methodStatic memberERROR Obsolete.
Public methodStatic memberEVENTHANDLER Obsolete.
Public methodStatic memberCode exampleEVL
Returns a non-empty value from two expressions.
You can use the EVL( ) function to return an appropriate substitute value instead of an empty value, such as False (.F.) or 0, from two expressions. You can also use this functionality to remove empty values from calculations or operations where empty values are not supported or relevant.
The X# Logical value, False (.F.), and the Numeric value of 0 also evaluate to empty.
Public methodStatic memberCode exampleField
Returns the name of a field, referenced by number, in a table.
Public methodStatic memberCode exampleFileToStr(String)
Returns the contents of a file as a character string.
Public methodStatic memberCode exampleFileToStr(String, Long)
Returns the contents of a file as a character string.
Public methodStatic memberCode exampleFilter
Returns the table filter expression specified in Set Filter.
Public methodStatic memberFKLABEL Obsolete.
Public methodStatic memberFKMAX Obsolete.
Public methodStatic memberFldCount
This function is a synonym to FCount() Function.
Public methodStatic memberFldList
-- todo --
Public methodStatic memberFontMetric
-- todo --
Public methodStatic memberFor
Returns the index filter expression, in uppercase, of an open single-entry index (.idx) file or an index tag.
Public methodStatic memberForceExt(String, String)
Returns a string with the old file name extension replaced by a new extension.
Public methodStatic memberForceExt(String, String, Logic)
Returns a string with the old file name extension replaced by a new extension.
Public methodStatic memberForcePath
Returns a file name with a new path name substituted for the old one.
Public methodStatic memberFullPath
-- todo --
Public methodStatic memberCode exampleFV
Returns the future value of a financial investment.
Public methodStatic memberGetAutoIncValue
Public methodStatic memberGETBAR Obsolete.
Public methodStatic memberCode exampleGetColor
Displays the Windows Color dialog box and returns the color number of the chosen color.
Public methodStatic memberCode exampleGetCp
-- todo --
Public methodStatic memberGetCursorAdapter
-- todo --
Public methodStatic memberGetDir
-- todo --
Public methodStatic memberCode exampleGetFile
-- todo --
Public methodStatic memberGetFldState
-- todo --
Public methodStatic memberCode exampleGetFont
Displays the Font dialog box and returns information about the font you choose.
Public methodStatic memberGETINTERFACE Obsolete.
Public methodStatic memberCode exampleGetNextModified
-- todo --
Public methodStatic memberCode exampleGetObject
-- todo --
Public methodStatic memberGETPAD Obsolete.
Public methodStatic memberGETPEM Obsolete.
Public methodStatic memberGetPict
-- todo --
Public methodStatic memberCode exampleGetPrinter
-- todo --
Public methodStatic memberGetResultSet
-- todo --
Public methodStatic memberGetWordCount(String)
Counts the words in a string.
Public methodStatic memberGetWordCount(String, String)
Counts the words in a string.
Public methodStatic memberGetWordNum(String, Long)
Returns a specified word from a string.
Public methodStatic memberGetWordNum(String, Long, String)
Returns a specified word from a string.
Public methodStatic memberCode exampleGoMonth(DateTime, Long)
Returns the date that is a specified number of months before or after a given Date or Date/Time expression.
Public methodStatic memberCode exampleGoMonth(Date, Long)
Returns the date that is a specified number of months before or after a given Date or Date/Time expression.
Public methodStatic memberHOME Obsolete.
Public methodStatic memberCode exampleHour
Returns the hour portion from a DateTime expression.
Public methodStatic memberCode exampleICase
Evaluates the results from a list of conditions (upto 100 pairs are supported).
Public methodStatic memberId
-- todo --
Public methodStatic memberCode exampleIdxCollate
Returns the collating sequence for an index or index tag.
Public methodStatic memberImeStatus
-- todo --
Public methodStatic memberCode exampleInDbc
-- todo --
Public methodStatic memberIndexSeek
-- todo --
Public methodStatic memberINKEY Obsolete.
Public methodStatic memberInputBox
-- todo --
Public methodStatic memberCode exampleInsMode
Returns the current insert mode, or sets the insert mode on or off.
Public methodStatic memberCode exampleInsMode(Logic)
Returns the current insert mode, or sets the insert mode on or off.
Public methodStatic memberCode exampleIsBlank
-- todo --
Public methodStatic memberIsColor
Determines whether a computer can display color.
Public methodStatic memberCode exampleIsExclusive
-- todo --
Public methodStatic memberIsFlocked
Returns the table lock status.
Public methodStatic memberISLEADBYTE Obsolete.
Public methodStatic memberIsMemoFetched
-- todo --
Public methodStatic memberCode exampleIsMouse
Returns true (.T.) if mouse hardware is present.
Public methodStatic memberCode exampleIsNull
-- todo --
Public methodStatic memberIsPen
-- todo --
Public methodStatic memberCode exampleIsReadOnly
Determines whether a table or database is opened read-only.
Public methodStatic memberIsRlocked
Returns the record lock status.
Public methodStatic memberIsTransactable
-- todo --
Public methodStatic memberCode exampleJustDrive
Returns the drive letter from a complete path.
Public methodStatic memberCode exampleJustExt(String)
Returns the characters of a file extension from a complete path.
Public methodStatic memberCode exampleJustExt(String, Logic)
Returns the drive letter from a complete path.
Public methodStatic memberCode exampleJustFName
Returns the file name portion of a complete path and file name.
Public methodStatic memberCode exampleJustPath
Returns the path portion of a complete path and file name.
Public methodStatic memberCode exampleJustStem
Returns the stem name (the file name before the extension) from a complete path and file name.
Public methodStatic memberCode exampleKey
Returns the index key expression for an index tag or index file.
Public methodStatic memberKeyMatch
-- todo --
Public methodStatic memberLASTKEY Obsolete.
Public methodStatic memberLeftC
Returns a specified number of characters from a character expression, starting with the leftmost character.
Public methodStatic memberLenC
Returns the number of characters in a character expression or memo field.
Public methodStatic memberLikeC
Determines whether a character expression matches another character expression.
Public methodStatic memberCode exampleLineNo
-- todo --
Public methodStatic memberCode exampleLoadPicture
-- todo --
Public methodStatic memberLocFile
-- todo --
Public methodStatic memberCode exampleLock
Attempts to lock one or more records in a table.
Public methodStatic memberCode exampleLookup
-- todo --
Public methodStatic memberCode exampleLTrim
Remove leading spaces from a string.
Public methodStatic memberMakeTransactable
-- todo --
Public methodStatic memberMdx
Returns the name of the open .cdx compound index file that has the specified index position number.
Public methodStatic memberCode exampleMDY(DateTime)
Returns a character expression in day-month-year format (for example, 31 May 1998) from a Date or DateTime expression. The month name isn't abbreviated.
Public methodStatic memberCode exampleMDY(Date)
Returns the specified date or datetime expression in month-day-year format with the name of the month spelled out.
Public methodStatic memberMEMORY Obsolete.
Public methodStatic memberMENU Obsolete.
Public methodStatic memberMESSAGE Obsolete.
Public methodStatic memberCode exampleMessageBox
Displays a user-defined dialog box.
Public methodStatic memberCode exampleMinute
Returns the minute portion from a DateTime expression.
Public methodStatic memberMkDir
Public methodStatic memberMRKBAR Obsolete.
Public methodStatic memberMRKPAD Obsolete.
Public methodStatic memberMROW Obsolete.
Public methodStatic memberCode exampleMToN
Returns a Numeric value from a Currency expression.
Public methodStatic memberMWINDOW Obsolete.
Public methodStatic memberNdx
Returns the name of an open index (.IDX) file for the current or specified table.
Public methodStatic memberNewObject
-- todo --
Public methodStatic memberNormalize
-- todo --
Public methodStatic memberCode exampleNToM
Returns a Currency value from a Numeric expression.
Public methodStatic memberCode exampleNumLock
Returns the current mode of the Num Lock key or sets the mode of the Num Lock key on or off.
Public methodStatic memberCode exampleNumLock(Logic)
Returns the current mode of the Num Lock key or sets the mode of the Num Lock key on or off.
Public methodStatic memberCode exampleNVL
Returns a non-null value from two expressions.
Public methodStatic memberOBJTOCLIENT Obsolete.
Public methodStatic memberCode exampleOldVal
-- todo --
Public methodStatic memberON Obsolete.
Public methodStatic memberCode exampleOrder
Returns the name of the controlling index file or tag for the current or specified table.
Public methodStatic memberPAD Obsolete.
Public methodStatic memberPADPROMPT Obsolete.
Public methodStatic memberPARAMETERS Obsolete.
Public methodStatic memberCode examplePayment
Returns the amount of each periodic payment on a fixed-interest loan.
Public methodStatic memberCode examplePCol
-- todo --
Public methodStatic memberPEMSTATUS Obsolete.
Public methodStatic memberPOPUP Obsolete.
Public methodStatic memberCode examplePrimary
-- todo --
Public methodStatic memberPRINTSTATUS Obsolete.
Public methodStatic memberPRMBAR Obsolete.
Public methodStatic memberPRMPAD Obsolete.
Public methodStatic memberCode exampleProgram
Returns the name of the program at a specified program level, the name of the currently executing program, the current program level, or the name of the program executing when an error occurred.
Public methodStatic memberPROMPT Obsolete.
Public methodStatic memberCode examplePRow
-- todo --
Public methodStatic memberPrtInfo
-- todo --
Public methodStatic memberCode examplePutFile
-- todo --
Public methodStatic memberCode examplePV
Returns the present value of an investment.
Public methodStatic memberQuarter(DateTime, Long)
Returns the quarter of the year in which a date or datetime expression occurs.
Public methodStatic memberQuarter(Date, Long)
Returns the quarter of the year in which a date or datetime expression occurs.
Public methodStatic memberCode exampleRaiseEvent
-- todo --
Public methodStatic memberRAt
Returns the numeric position of the last occurrence of a character expression or memo field within another character expression or memo field.
Public methodStatic memberRAtC
Returns the numeric position of the last occurrence of a character expression or memo field within another character expression or memo field.
Public methodStatic memberRDLEVEL Obsolete.
Public methodStatic memberREADKEY Obsolete.
Public methodStatic memberRefresh
-- todo --
Public methodStatic memberRegisterFoxMemVarSupport
Public methodStatic memberCode exampleRelation
Returns a specified relational expression for a table that is open in a specific work area.
Public methodStatic memberRemoveProperty
Removes a property from an object at run time.
Public methodStatic memberRequery
-- todo --
Public methodStatic memberCode exampleRgbScheme
-- todo --
Public methodStatic memberRightC
Returns the specified number of rightmost characters from a character string.
Public methodStatic memberCode exampleRTrim
Remove trailing spaces from a string.
Public methodStatic memberSavePicture
-- todo --
Public methodStatic memberCode exampleScheme
-- todo --
Public methodStatic memberSCOLS Obsolete.
Public methodStatic memberCode exampleSec
Returns the seconds portion from a DateTime expression.
Public methodStatic memberCode exampleSeek
-- todo --
Public methodStatic memberCode exampleSetFldState
-- todo --
Public methodStatic memberSetFoxCollation
Public methodStatic memberSetResultSet
-- todo --
Public methodStatic memberSetTextFile
Open/Close the file to which TEXT .. ENDTEXT values are written
Public methodStatic memberSetTextMerge
Retrieve the setting that determines if TextMerge is active
Public methodStatic memberSetTextMerge(Logic)
Change the setting that determines if TextMerge is active
Public methodStatic memberSetTextMergeDelimiters
Read the TextMerge delimiters
Public methodStatic memberSetTextMergeDelimiters(String, String)
Change the TextMerge delimiters
Public methodStatic memberShowFoxArray
Dump the contents of an array to the terminal window
Public methodStatic memberCode exampleSign
Returns a numeric value of 1, –1, or 0 if the specified numeric expression evaluates to a positive, negative, or 0 value.
Public methodStatic memberSKPBAR Obsolete.
Public methodStatic memberSKPPAD Obsolete.
Public methodStatic memberCode exampleSqlCancel
Requests cancellation of an executing SQL statement.
Public methodStatic memberCode exampleSqlColumns
Stores a list of column names and information about each column for the specified data source table to a X# cursor.
Public methodStatic memberCode exampleSqlCommit
Commits a transaction.
Public methodStatic memberCode exampleSqlConnect(Long)
Establishes a connection to a data source.
Public methodStatic memberCode exampleSqlConnect(String, Usual, Usual, Usual)
Establishes a connection to a data source.
Public methodStatic memberCode exampleSqlDisconnect
Terminates a connection to a data source.
Public methodStatic memberCode exampleSqlExec
Sends a SQL statement to the data source, where the statement is processed.
Public methodStatic memberCode exampleSqlGetProp(Long, Long)
Retrieves the current or default settings for an active connection.
Public methodStatic memberCode exampleSqlGetProp(Long, String)
Retrieves the current or default settings for an active connection.
Public methodStatic memberSqlIdleDisconnect
-- todo --
Public methodStatic memberCode exampleSqlMoreResults
Copies another result set to a X# cursor if more result sets are available.
Public methodStatic memberSqlParameters
Public methodStatic memberCode exampleSqlPrepare
Prepares a SQL statement for remote execution by SqlExec( ).
Public methodStatic memberCode exampleSqlRollBack
Cancels any changes made during the current transaction.
Public methodStatic memberSqlSetFactory
This function allows you to choose the Ado.Net provider that is used for the subsequent SqlConnect() or SqlStringConnect() calls.
Public methodStatic memberSqlSetFactory(String)
This function allows you to choose the Ado.Net provider that is used for the subsequent SqlConnect() or SqlStringConnect() calls.
Public methodStatic memberSqlSetFactory(ISqlFactory)
This function allows you to choose the Ado.Net provider that is used for the subsequent SqlConnect() or SqlStringConnect() calls.
Public methodStatic memberCode exampleSqlSetProp(Long, Long, Usual)
Specifies settings for an active connection. You can use SqlSetProp( ) to specify settings at the connection level. To specify application default settings at the environment level, include 0 as the statement handle.
Public methodStatic memberCode exampleSqlSetProp(Long, String, Usual)
Specifies settings for an active connection. You can use SqlSetProp( ) to specify settings at the connection level. To specify application default settings at the environment level, include 0 as the statement handle.
Public methodStatic memberCode exampleSqlStringConnect(Logic)
Establishes a connection to a data source using a connection string.
Public methodStatic memberCode exampleSqlStringConnect(String)
Establishes a connection to a data source using a connection string.
Public methodStatic memberCode exampleSqlStringConnect(String, Logic)
Establishes a connection to a data source using a connection string.
Public methodStatic memberCode exampleSqlTables
Stores the names of tables in a data source to a X# cursor.
Public methodStatic memberSROWS Obsolete.
Public methodStatic memberStr
Public methodStatic memberStrConv
-- todo --
Public methodStatic memberCode exampleStrExtract
-- todo --
Public methodStatic memberStrToFile(String, String)
Writes the contents of a character string to a file.
Public methodStatic memberStrToFile(String, String, Logic)
Writes the contents of a character string to a file.
Public methodStatic memberStrToFile(String, String, Long)
Writes the contents of a character string to a file.
Public methodStatic memberStuffC
Returns a character string created by replacing a specified number of characters in a character expression with another character expression.
Public methodStatic memberSubStrC
Returns a character string from the given character expression or memo field.
Public methodStatic memberSys
-- todo --
Public methodStatic memberSysMetric
-- todo --
Public methodStatic memberCode exampleTableRevert
-- todo --
Public methodStatic memberCode exampleTableUpdate
-- todo --
Public methodStatic memberCode exampleTag
Returns a tag name from an open compound index (.cdx) file or the name of an open single-entry (.idx) index file.
Public methodStatic memberTagCount
Returns the number of .cdx compound index file tags and open .idx single-entry index files.
Public methodStatic memberTagNo
Returns the index position for .cdx compound index file tags and open .idx single-entry index files.
Public methodStatic memberCode exampleTarget
Returns the alias of a table that is the target for a relation as specified in the Into clause of Set RELATION.
Public methodStatic memberCode exampleTextMerge
Provides evaluation of a character expression.
Public methodStatic memberTransform
Public methodStatic memberCode exampleTrim
Remove trailing spaces from a string.
Public methodStatic memberCode exampleTToC
-- todo --
Public methodStatic memberCode exampleTToD
Returns a Date value from a DateTime expression.
Public methodStatic memberCode exampleTxnLevel
-- todo --
Public methodStatic memberTxtWidth
-- todo --
Public methodStatic memberUNBINDEVENTS Obsolete.
Public methodStatic memberUnique
Included for compatibility with dBASE.
Public methodStatic memberUPDATED Obsolete.
Public methodStatic memberVARREAD Obsolete.
Public methodStatic memberVarType(Usual)
Returns the data type of an expression.
Note Note
VARTYPE( ) is similar to the TYPE( ) function, but VARTYPE( ) is faster and does not require quotation marks to enclose the expression for which the data type is returned.
Public methodStatic memberVarType(Usual, Logic)
Returns the data type of an expression.
Note Note
VARTYPE( ) is similar to the TYPE( ) function, but VARTYPE( ) is faster and does not require quotation marks to enclose the expression for which the data type is returned.
Public methodStatic memberWBORDER Obsolete.
Public methodStatic memberWCHILD Obsolete.
Public methodStatic memberWCOLS Obsolete.
Public methodStatic memberWDOCKABLE Obsolete.
Public methodStatic memberCode exampleWeek(DateTime, Long, Long)
Returns a number representing the week of the year from a Date or DateTime expression.
Public methodStatic memberCode exampleWeek(Date, Long, Long)
Returns a number representing the week of the year from a Date or DateTime expression.
Public methodStatic memberWEXIST Obsolete.
Public methodStatic memberWFONT Obsolete.
Public methodStatic memberWLAST Obsolete.
Public methodStatic memberWLCOL Obsolete.
Public methodStatic memberWLROW Obsolete.
Public methodStatic memberWMAXIMUM Obsolete.
Public methodStatic memberWMINIMUM Obsolete.
Public methodStatic memberWONTOP Obsolete.
Public methodStatic memberWOUTPUT Obsolete.
Public methodStatic memberWPARENT Obsolete.
Public methodStatic memberWREAD Obsolete.
Public methodStatic memberWROWS Obsolete.
Public methodStatic memberWTITLE Obsolete.
Public methodStatic memberWVISIBLE Obsolete.
Public methodStatic memberXmlToCursor
-- todo --
Public methodStatic memberXmlUpdatefram
-- todo --
Top
See Also