To locate information about this keyword, please select one of the subentries in the list.

$define INTL_LANG .DBF files need to be accessed from Windows Only .NTX index [* *] 1800 error Abs AccessMethod Active AddDudenCollation AddEtecCollation ALIAS Aliases Aliases  AS  and IN    AS: and IN ALL ALLTRIM ALTER TABLE AND Apollo File Formats Apollo Limits Apollo Run Time Errors Apollo SQL - Aggregate Functions Apollo SQL - Arithmetic Functions Apollo SQL - Conditional Expressions Apollo SQL - Date and Time Functions Apollo SQL - String Functions Apollo SQL Notes Apollo Tutorial ApolloBof ApolloConnection ApolloDataSet  Installation Directories and Files ApolloDelete ApolloEof ApolloFieldCount ApolloGetRecord ApolloLocate Apollo's support of FoxPro "G" (General) fields ApolloSQL7.DLL APPEND AppendBlank AppendFrom Appending Records ApplyTo ArcTan AS ASC AT AUTOINC Automatic OEM and ANSI Conversion Automatic table referencing in SQL with TApolloQuery automatically parses the tables AutoRefresh available functions AVG BadWayToThread.dpr BaseDate BaseName BETWEEN BLOB BlobToFile Bof boolean BOTH buffering buffers BY CA-Clipper .DBF/.DBT files CASE case sensitive case-sensitive CAST Cause of 1800 File Open Error when I running applications from within the Delphi / C++Builder IDE Caveats CD CD-based Apollo applications CD-ROM Century CHAR CheckTableType CHR Clause List clFull Client/Server or Enterprise Edition of Delphi/C+Builder Clipper Clipper with Apollo - German Clipper with Apollo - International Clipper with Apollo - Non-International clNoCommit clNone clNormal Close CloseDataSets CloseIndexes Collation and TApolloQuery Collation and TApolloTable Collation Sample Collation Support Summary Comma Delimited Commit CommitLevel Connect Connected Connecting to Apollo Database Server Connecting to Local Tables Converting existing dBASE or Paradox tables    and indexes into formats that Apollo can use Copy CopyFile CopyFileText CopyStructure CopyStructureExtended Cos COUNT CREATE Create a TApolloTable object in the Server DLL CREATE TABLE CREATE TABLE Example CreateExec CreateField CreateFrom CreateNew Creating a new table in code Creating Fixed Column Headers with the IN() Predicate Creating Server DLLs Creating Stored Procedures cross-tab queries    creating cross-tab query CTOD Data Definition Language Data Definition Language DDL Data Manipulation Language DML Data types DatabaseName DataPath DataPathAlias DATE Date and Time Functions DateFormat DATETIME DAY DBF files need to be accessed from a DOS and Windows DBF files need to be accessed from Windows Only DbfDecrypt DbfEncrypt DBFilter DDL DDL and DML Debugging a Stored Procedure Decrypt Defined DELETE DELETE [WHERE] DELETED DeleteFile Deploying Apollo SQL Applications DESC DESCEND diacritical marks Differences in ApolloSQL from TQuery Direct Calls To SDE API Functions Disabling Data-Aware Controls Disconnect DISTINCT Distributing ApolloDataSet  Applications DIV DML Don t Display Deleted Records Don t Display Error Dialogs DOS-like collation and Apollo DROP DROP INDEX DROP TABLE DTOC DTOS Duden Duden and Spanish Defines Duden Collation Support Duden support and Apollo DUDN_LANG Eliminating 6240 Errors ELSE EMPTY emulated Encrypt Eof EOFAction Epoch Error 1000 Error 1100 Error 1200 Error 1300 Error 1400 Error 1500 Error 1600 Error 1700 Error 1800 Error 1900 Error 2000 Error 2100 Error 2102 Error 2200 Error 2300 Error 2400 Error 2500 Error 2600 Error 2700 Error 2800 Error 2900 Error 2950 Error 2980 Error 3000 Error 3100 Error 3200 Error 3300 Error 3400 Error 3500 Error 3600 Error 3700 Error 3800 Error 3900 Error 400 Error 4100 Error 4200 Error 4300 Error 4400 Error 4500 Error 4600 Error 4650 Error 4700 Error 4750 Error 4800 Error 4900 Error 500 Error 5000 Error 5050 Error 5100 Error 5200 Error 5300 Error 5400 Error 5500 Error 5600 Error 5700 Error 5800 Error 5900 Error 600 Error 6000 Error 6100 Error 6200 Error 6215 Error 6240 Error 6250 Error 6300 Error 6400 Error 6500 Error 6600 Error 6700 Error 6800 Error 6900 Error 700 Error 7000 Error 7100 Error 7200 Error 7300 Error 7400 Error 750 Error 7500 Error 7600 Error 7700 Error 775 Error 7800 Error 7900 Error 800 Error 900 Error Handling ErrorLevel ESCAPE EvalLogical EvalNumeric EvalString EvalTest Exact ExecProc ExecSQL Exists Exp Extract ExtraIndexes FALSE Fast Text Search - Error Codes Features FetchCount FieldCount FieldDecimals FieldName FieldNum FieldOffset FieldType FieldWidth FileExists FileIsInUse FileLength FileReceive FileSend FilterAlias FilterDlg Filtering  SetScope  SetRange and Query Filtering  SetScope and Query FindParam fixed-column headers    creating FLOAT FLock Flushes FOR Format FormatDateTime FormatFloat Found Frac Frequently Asked Questions FROM FTS Error Codes FULL General Performance Tips German Duden collation support German speaking GetBinary GetBlob GetBlobLength GetByte GetConnectionID GetDatabaseNames GetDatabaseNamesList GetDate GetDateJulian GetDateString GetDouble GetInteger GetLogical GetLong GetMemo GetQueryBit GetRecord GetScope GetServerDateTime GetString GetStringEx GetSystemLocale GetTableNames GetTableNamesList GetTableType Getting Started GetTrimString GetUserNamesList Go GoBottom GoTop GROUP GROUP BY GROUP BY [HAVING GROUP BY [HAVING] Handle Handling Deleted Records HAVING Host HOUR IF IIF IN IN predicate incompatible Index IndexClose IndexCondition indexes IndexExt IndexFileName IndexFlip indexing INDEXKEY IndexKeyField IndexOpen IndexOrd IndexTag IndexType Inline Table Definitions INNER INNER JOIN INSERT INSERT INTO [WHERE] VALUES Installing ApolloDataSet Int INTEGER International International Users INTL_LANG INTO Introduction Invalid index expression  Error IS [NOT] NULL IS NOT NULL IS NULL IsEncrypted JOIN KEY KeyAdd KeyData KeyDrop LEADING Left LEN Length LIKE Ln LoadDLL local mode Locate    TApolloQuery    TApolloTable LocateIndexOrd LockCount Locked LockList LockTimeout Login Logout Lower MachSIx query optimizer many-to-many relationship master/detail MAX MAXOF MemDealloc MemoBlockSize MERGE Method65025.dpr Migrating from previous versions of Apollo MIN MIN Date and Time MINOF MOD MONEY MONTH Moving from local mode to client/server Moving To Client/Server MSEC Multiple record locking Native Record and File Locking Native Record/File Locking Nested Select New in Apollo SQL 7 new record New TSDEEngine Class New TSDEEngine Class SDE7.PAS non-English versions of Windows NOT Notes For International Users Now NTX NULL NUMERIC OEMTranslate ON OnError OnLogin OnLogout OnlyWayToWork.dpr OnReadProgress OnServerProgress OnStatus OnWriteProgress Open OpenDataSets Operators in expressions Optimistic Buffering OptimisticBuffer OptimisticCommit optimization OptimizeJoin OptimizeWhere Optimizing Performance Optimizing Performance under Client/Server OR ORDER ORDER BY OrderPosGet OrderPosSet OrderRecNo ORDKEY Other SQL References OUTER OUTER JOIN Overview Overview of Demo Programs Pack PADC PADL PADR Parameterized queries Parameters Params Password peer-to-peer Permanently convert OEM table to ANSI Pi Ping PIVOT Port Pos Power Prepare PRIMARY ProcName ProcParams Properties PutBinary PutBlob PutRecord QKEYVAL Query Query Optimization Tips QueryRecCount QueryTest RAT Reading data on a CD-ROM Recall RECCOUNT RECNO record-level encrypting RecSize Referencing Sub-Directories Refresh RefreshDataSets Reindex REINDEX TABLE Replace Reserved Words Reserved Words in Apollo SQL Right RLock Round RoundDec Rushmore technology RYOFilterActivate RYOFilterCopy RYOFilterCreate RYOFilterDestroy RYOFilterRestore RYOFilterSave RYOFilterSetBit RYOKeyAdd RYOKeyDrop Sample Data Files ScopeBegin Scoped ScopeEnd SDE API Functions SDE Collation Sample application SDE_SP_GETADDQUERY SDE_SP_GETCHRCOLLATE SDE_SP_GETDELETED SDE_SP_GETDESCENDING SDE_SP_GETDISABLEAUTO SDE_SP_GETDRIVER SDE_SP_GETDUDENCOLLATE SDE_SP_GETEMPTY SDE_SP_GETEXACT SDE_SP_GETINDEXCOUNT SDE_SP_GETLANGUAGECOLLATE SDE_SP_GETLGTRCOLLATE SDE_SP_GETLIMITCASECONV SDE_SP_GETOBUFFER SDE_SP_GETOEMCOLLATE# SDE_SP_GETQUERYRELAXFLAG SDE_SP_GETSECURITY SDE_SP_GETSOFTSEEK SDE_SP_GETSPECIALCOLLATE SDE_SP_GETSTRINGTYPE SDE_SP_GETUSECONDITIONAL SDE_SP_PUTOBUFFER SDE_SP_SETADDQUERY SDE_SP_SETCHRCOLLATE SDE_SP_SETDBTNSX SDE_SP_SETDEFAPPEND SDE_SP_SETDISABLEAUTO SDE_SP_SETDUDENCOLLATE SDE_SP_SETEXACT SDE_SP_SETLGTRCOLLATE SDE_SP_SETLIMITCASECONV SDE_SP_SETOBUFFER SDE_SP_SETOEMCOLLATE SDE_SP_SETQUERYRELAXFLAG SDE_SP_SETSECURITY SDE_SP_SETSOFTSEEK SDE_SP_SETSPECIALCOLLATE SDE_SP_SETSTRDEFDEC SDE_SP_SETSTRDEFLEN SDE_SP_SETSTRINGTYPE SDE_SP_SETUSECONDITIONAL SDE_SP_SETWRITEBLOBHDR SDE7 SDE7.DLL SDE7.PAS SDECDX7.DLL SDENSX7.DLL SDENTX7.DLL Searching for a key in an index that was created on two fields SEC Seek SeekBin SELECT Sequenced SequencedCount Server DLL format Server DLL template ServerName server-side DLL procedures SET SetCentury SetDateFormat SetDeleted SetEpoch SetErrorFunc SetExact SetFilter SetGaugeHook SetLockTimeout SetMachineCollation SetMemoBlockSize SetOrder SetPassword SetQueryBit SetRelation SetScope SetScope Example SetSoftSeek SetSystemCollation Setting relations between tables with Apollo SetTranslate SetTurboRead share data with your DOS applications Shared Mode versus Exclusive Mode sharing files on a network or file server SHL SHR Sin Skip SMALLINT SoftSeek Sort Order Sorting and Ordering Explained SOUNDEX SPACE SPAN_LANG Spanish collation support Spanish speaking Spanish support and Apollo Specifying a BDE Alias in the TTable.DatabaseName property with an Apollo table type SpeedMode SQL SQL Optimization Tips Sqr Sqrt STDEV Step-By-Step Client/Server Tutorial Steps to Client/Server STOD STR STRZERO stub Sub-Query Sub-Select SUBSTR SubString SUM summary data Summary Data Created by the GROUP BY Clause SX_VFGET sxChar SysProp System Data Format System Requirements TABLE TableNames TableType TAccessMethod TagArea TagName TApollo TApollo (Stub) TApolloConnection TApolloDatabase TApolloDataSet TApolloEngine TApolloEnv TApolloQuery TApolloQuery_Version TApolloServerDLL TApolloSessionData TApolloStoredProc TApolloTable TApolloTable Methods TApolloTable Methods By Category TApolloTableDateFrmt TApolloTableType template THEN thread Threading TIME TO TQuery TQuery differences TRAILING TRANSFORM TRANSFORM. . . PIVOT Trim TRUE Trunc TruncDec TSDEEngine TSDEEngine class TSessionData ttSXFOX ttSXNSX ttSXNSX_DBT ttSXNTX TurboRead TVerifyType UDF Unable to open data files from a CD UNIQUE Unlock Unprepare UPDATE UPDATE  [SET] [WHERE] Updating Records Upgrading From Apollo 4/5 to Apollo 6 Upper Use TApolloTable Like TTable User User-Defined Functions Using Apollo VCL with Apollo SQL Using Apollo VCL with ApolloSQL Using BLOB Fields Using Clipper .NTX index files in Delphi projects Using Cross-tab Queries to Present Summary Data Using Server DLLs Using SpeedMode Using Stored Procedures Using TApolloQuery to Connect to Apollo Database Server Using TApolloQuery to Connect to Local Tables Using TRANSFORM and PIVOT to Create Cross-tab Queries Using User-Defined Functions (UDFs) Using Xbase commands and functions in Delphi code VAL VALUES Version ViewSystemCharOrder Visual Steps to Conversion What's New WHEN WHERE Windows sort order WorkArea WriteBlobHeader XBase and Delphi C++Builder Behaviour xBase Expression Engine xBase Functions Supported Xbase-Like Syntax YEAR Year 2000 Support Zap