• Apollo VCL Components
    • Introduction
    • Features
    • Getting Started
      • Getting Started
      • Installed Files
      • Apollo VCL Tutorial
      • Samples
      • Upgrading to Apollo 9
      • Steps to Client/Server
    • Installing and Using Apollo VCL
      • Installing into IDE
      • Deployment
      • XBase and Delphi C++ Builder Behaviour
      • Filtering, SetScope, SetRange and Query
      • Searching for a key in an index that was created on two fields
      • Sort Order
      • Sorting and Ordering Explained
      • International Users
      • Collation Support Summary
      • New TApolloEngine Class
      • DBF files: Mixing DOS and Windows access
      • DBF files: Windows Only access
      • Automatic OEM and ANSI Conversion
      • Using Apollo SQL
      • Using TApolloQuery to Connect to Local Tables
      • Using TApolloQuery to Connect to Apollo Server
      • Moving to Client/Server
      • Steps to Client/Server
      • Step-By-Step Client/Server Tutorial
      • Apollo SQL Notes
      • Using Clipper .NTX index files in Delphi projects
      • Converting dBASE and Paradox files into Apollo formats
      • Setting relations between tables with Apollo
      • Using Xbase commands and functions in Delphi code
      • Updating Records
      • Using Clipper .NTX index files in Delphi projects
    • Technical Information
      • System Requirements
      • File Formats Supported
      • File and Engine Specifications
      • HiPer-SIx File Formats
      • FoxPro "G" (General) fields
      • Xbase-Like Syntax
      • Automatic OEM and ANSI Conversion
      • Using Memo/BLOB Fields
      • Using User-Defined Functions (UDFs)
      • Native Record and File Locking
      • BDE Differences
      • Error Handling
    • Optimizing Performance
      • Overview
      • Appending Records
      • Direct Calls To Apollo API Functions
      • Disabling Data-Aware Controls
      • Handling Deleted Records
      • Optimistic Buffering
      • Optimizing Performance under Client/Server
      • Query Optimization Tips
      • Shared Mode versus Exclusive Mode
      • SQL Optimization Tips
      • Updating Records
      • Using SpeedMode
    • Apollo VCL Component Reference
      • TApollo (Stub)
      • TApolloDateFrmt
      • TApolloTableType
      • TAccessMethod
      • TApolloConnection
        • Overview
        • TApolloConnection Properties
          • Active
          • DatabaseName
          • Host
          • Password
          • Port
          • User
          • Version
        • TApolloConnection Methods
          • CloseDataSets
          • Connect
          • Connected
          • DeleteFile
          • Disconnect
          • FileExists
          • FileIsInUse
          • FileLength
          • FileReceive
          • FileSend
          • GetConnectionID
          • GetDatabaseNames
          • GetDatabaseNamesList
          • GetTableNames
          • GetTableNamesList
          • GetUserNamesList
          • GetServerDateTime
          • Login
          • Logout
          • OpenDataSets
          • Ping
          • ServerName
        • TApolloConnection Events
          • OnError
          • OnLogin
          • OnLogout
          • OnReadProgress
          • OnServerProgress
          • OnStatus
          • OnWriteProgress
      • TApolloDatabase
        • Overview
        • TApolloDatabase Properties
          • DataPath
          • DataPathAlias
        • TApolloDatabase Methods
          • CloseDataSets
          • OpenDataSets
          • RefreshDataSets
      • TApolloDataSet (Legacy)
        • Overview
      • TApolloEngine
        • Overview
        • AddDudenCollation
        • AddEtecCollation
        • GetSystemLocale
        • SetMachineCollation
        • SetSystemCollation
        • ViewSystemCharOrder
      • TApolloEnv
        • Overview
        • TApolloEnv Properties
          • ApplyTo
          • ApolloConnection
          • AutoRefresh
          • Century
          • DateFormat
          • Deleted
          • Epoch
          • Exact
          • LockTimeOut
          • MemoBlockSize
          • OptimisticBuffer
          • SoftSeek
        • TApolloEnv Methods
          • CloseDataSets
          • ErrorLevel
          • OpenDataSets
          • RefreshDataSets
          • SetCentury
          • SetDateFormat
          • SetDeleted
          • SetEpoch
          • SetErrorFunc
          • SetExact
          • SetLockTimeOut
          • SetMemoBlockSize
          • SetSoftSeek
      • TApolloQuery
        • Overview
        • Automatic table referencing in SQL with TApolloQuery
        • TApolloQuery Properties
          • AccessMethod
          • Active
          • ApolloConnection
          • DatabaseName
          • FetchCount
          • OEMTranslate
          • Params
          • Password
          • RecCount
          • RecNo
          • SQL
          • TableNames
          • TableType
          • Version
        • TApolloQuery Methods
          • Close
          • ExecSQL
          • Locate
          • Open
          • Prepare
          • Refresh
          • Unprepare
      • TApolloServerDLL
        • Overview
        • Using Server DLLs
        • Debugging a Server DLL
        • TApolloServerDLL Properties
          • Active
          • ApolloConnection
          • DatabaseName
          • ProcName
          • ProcParams
        • TApolloServerDLL Methods
          • ExecProc
      • TApolloTable
        • Overview
        • Properties
        • TApolloTable Methods (Alphabetical)
        • TApolloTable Methods (By Category)
        • Query Tips
        • TApolloTable Properties
          • AccessMethod
          • ApolloBof
          • ApolloConnection
          • ApolloEof
          • DatabaseName
          • DataPath
          • Deleted
          • EOFAction
          • Exists
          • ExtraIndexes
          • Handle
          • IndexExt
          • LocateIndexOrd
          • LockCount
          • LockList
          • OEMTranslate
          • OptimisticCommit
          • Password
          • RecCount
          • RecNo
          • ScopeBegin
          • Scoped
          • ScopeEnd
          • SpeedMode
          • Sequenced
          • SequencedCount
          • TableType
          • TurboRead
          • Version
          • WorkArea
          • WriteBlobHeader
        • TApolloTable Methods
          • Alias
          • Append
          • AppendBlank
          • AppendFrom
          • ApolloDelete
          • ApolloFieldCount
          • ApolloGetRecord
          • ApolloLocate
          • BaseDate
          • BaseName
          • BlobToFile
          • CloseIndexes
          • Commit
          • CopyFile
          • CopyFileText
          • CopyStructure
          • CopyStructureExtended
          • Count
          • CreateExec
          • CreateField
          • CreateFrom
          • CreateNew
          • DBFDecrypt
          • DBFEncrypt
          • DBFilter
          • Decrypt
          • Delete
          • Descend
          • Empty
          • Encrypt
          • EvalLogical
          • EvalNumeric
          • EvalString
          • EvalTest
          • FetchCount
          • FieldDecimals
          • FieldName
          • FieldNum
          • FieldOffset
          • FieldType
          • FieldWidth
          • FilterAlias
          • FilterDlg
          • FLock
          • Found
          • GetBinary
          • GetBlob
          • GetBlobLength
          • GetByte
          • GetDate
          • GetDateJulian
          • GetDateString
          • GetDouble
          • GetInteger
          • GetLogical
          • GetLong
          • GetMemo
          • GetQueryBit
          • GetScope
          • GetString
          • GetStringEx
          • GetTableType
          • GetTrimString
          • Go
          • GoBottom
          • GoTop
          • Index
          • IndexClose
          • IndexCondition
          • IndexFileName
          • IndexFlip
          • IndexKey
          • IndexKeyField
          • IndexOpen
          • IndexOrd
          • IndexTag
          • IndexType
          • IsEncrypted
          • KeyAdd
          • KeyData
          • KeyDrop
          • Locate
          • Locked
          • MemDealloc
          • OrderPosGet
          • OrderPosSet
          • OrderRecNo
          • Pack
          • PutBinary
          • PutBlob
          • PutRecord
          • Query
          • QueryRecCount
          • QueryTest
          • Recall
          • RecSize
          • Reindex
          • Replace
          • RLock
          • RYOFilterActivate
          • RYOFilterCopy
          • RYOFilterCreate
          • RYOFilterDestroy
          • RYOFilterRestore
          • RYOFilterSave
          • RYOFilterSetBit
          • RYOKeyAdd
          • RYOKeyDrop
          • Seek
          • SeekBin
          • SetFilter
          • SetGaugeHook
          • SetOrder
          • SetPassword
          • SetQueryBit
          • SetRelation
          • SetScope
          • SetTurboRead
          • Skip
          • SysProp
          • TagArea
          • TagName
          • Unlock
          • Zap
      • TSessionData
        • Overview
    • xBase Expressions/Functions
      • Using Xbase commands and functions in Delphi code
      • xBase Expression Engine
      • xBase Functions Supported
    • FAQ
      • Frequently Asked Questions
      • XBase and Delphi C++ Builder TDataSet Behavior
      • Don't Display Deleted Records
      • Don't Display Error Dialogs
      • Debugging a Server DLL
      • Creating new DBF file from Code
      • SpeedMode Explained
      • Eliminating 6240 Errors
      • 1800 File Open Error in Delphi / C++Builder IDE
      • Mixing BDE and Apollo settings
      • Setting relations between tables with Apollo
      • Using Xbase commands and functions in Delphi code
      • Searching for a key in an index that was created on two fields
      • Reading data on a CD-ROM
    • Run-Time Errors
      • 1800 File Open Error when running IDE
      • Error Handling
      • Unable to open data files from a CD
      • Eliminating 6240 Errors
      • "Invalid index expression" Error
      • Apollo Run-Time Errors
      • FTS Run-Time Error Codes
  • Apollo SQL
    • Introduction
    • Features
    • Using Apollo SQL
      • Overview
      • New in Apollo SQL
      • Deployment
      • Inline Table Definitions
      • Reserved Words
      • Data Types
      • Using Cross-tab Queries to Present Summary Data
      • Using TRANSFORM and PIVOT to Create Cross-tab Queries
      • Creating Fixed Column Headers with the IN() Predicate
      • Summary Data Created by the GROUP BY Clause
      • Other SQL References
    • DDL & DML Statements
      • Aliases, AS, and IN
      • ALTER TABLE
      • CREATE INDEX
      • CREATE TABLE
      • DDL and DML
      • DELETE [WHERE]
      • DISTINCT
      • DROP INDEX
      • DROP TABLE
      • GROUP BY [HAVING]
      • INSERT INTO [WHERE] VALUES
      • INTO
      • IS [NOT] NULL
      • JOIN
      • LIKE
      • MERGE
      • ORDER BY
      • SELECT
      • Subqueries (or Subselects)
      • TRANSFORM. . . PIVOT
      • UPDATE  [SET] [WHERE]
      • WHERE
    • Aggregate Functions
      • Overview
      • AVG
      • COUNT
      • MAX
      • MIN
      • SUM
    • Arithmetic Functions
      • Overview
      • Abs
      • ArcTan
      • Cos
      • Exp
      • Frac
      • Int
      • Ln
      • MINOF
      • MAXOF
      • Pi
      • Power
      • Round
      • RoundDec
      • Sin
      • Sqr
      • Sqrt
      • STDEV
      • Trunc
      • TruncDec
    • Conditional Functions
      • Overview
      • IF
    • Date and Time Functions
      • Overview
      • DAY
      • HOUR
      • MIN (Date and Time)
      • MONTH
      • MSEC
      • Now
      • SEC
      • YEAR
    • String Functions
      • Overview
      • Copy
      • Extract
      • Format
      • FormatDateTime
      • FormatFloat
      • Left
      • Length
      • Lower
      • Pos
      • Right
      • SubString
      • Trim
      • Upper