|
- -
Database Server discovery for Windows
- . -
.NET Data Provider
class summary
code portability
connection pooling
data types
distributing
Entity Framework
installing
multi-threading
name space
product overview
quick start
referencing
registering
system requirements
- : -
::conn.TransactionCount
- _ -
_errclass
system variables
_errcode
system variables
_errtext
system variables
- “ -
“Key Generating” tables
- 0 -
0-based
Advantage SQL date/time functions
- 1 -
1001 Open Error
1002 Open Error (FPT or DBT)
1003 Open Error (NTX IDX or CDX)
1004 Create Error
10047 Winsock
caused by Internet IP address
caused by LAN IP address
1005 Create Error (creating FPT or DBT)
1006 Create Error (creating NTX IDX or CDX)
1010 Read Error
1011 Write Error
1012 Corruption Detected
1020 Data Type Error
1021 Data Width Error
1022 Lock Required
1023 Exclusive Required
1024 Append Lock Failed
1025 Write Not Allowed
1026 Data Width Error
1027 Limit Exceeded
1050 Invalid Order
1201 Work Area not Indexed
12-hour time
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
15xx Error Codes
160-bit e
160-bit encryption
clients uses
general encryption information
160-bit keys
16-bit
callback functionality
consisting
I2BIN expression engine function
NLM screen
number of connections
semaphore connection file path
use semaphores files
16-bit client
16MODMAN.EXE
1-based
Advantage SQL string functions
1xxx Error Codes
- 2 -
2008 ISAM memory allocation failure
2009 ISAM path or file name too long
2010 ISAM table already exists
2011 ISAM index expression not valid
2012 ISAM column name too long
2013 Stack limit exceeded due to recursion
2014 Invalid ROWID
2015 ISAM path or file name is not valid
2101 Memory allocation failure
2102 Data truncated
2103 Functionality not supported
2104 Invalid cursor name
2105 Cursor name in use
2106 Connection in use
2107 Invalid Cursor State
2108 Invalid column id
2109 Conversion error
2110 Driver not capable
2111 Out of range
2112 Assignment error
2113 Unexpected end of statement
2114 Element too big
2115 Expected lexical element not found
2116 Malformed number
2117 Unexpected extra token
2118 Malformed escape clause
2119 Internal error
2120 ISAM error
2121 Column not found
2122 Table not found
2123 Data type of parameter cannot be determined
2124 Invalid operand for operator
2125 Invalid table name
2126 ORDER BY ordinal greater than select list count
2127 Too many ORDER BY items
2128 Cannot ORDER BY an expression
2129 Unequal number of insert columns and insert values
2130 Insert value was not valid
2131 Value in an IN expression must be a simple value
2132 Table alias used multiple times
2133 Column on list multiple times
2134 Invalid column name
2135 No such type
2136 Invalid number of parameters for type
2137 Column found in multiple tables
2138 No data found
2139 Invalid connection string
2140 Unable to connect
2141 Parameter missing
2142 - 2144 Internal Error
2145 Unable to ORDER BY this column
2146 Unable to perform sort for ORDER BY or DISTINCT
2147 GROUP BY contains too many columns
2148 Unable to GROUP BY this column
2149 Aggregate function not allowed in this context
2150 SELECT * not allowed if there is a GROUP BY
2151 Unable to do sort for GROUP BY
2152 HAVING specified without a GROUP BY
2153 Division by zero
2154 The data type of a parameter cannot be determined
2155 String concatenation overflow
2156 Invalid index name
2157 Too many key columns for index
2158 Scalar function not found
2159 Invalid argument to scalar function
2160 - 2165 Internal Error
2166 SELECT sub-query returns more than one column
2167 SELECT sub-query returned more than one row
2168 - 2188 Internal Error
2189 Inconsistent number of columns in the result sets participating in the UNION statement
2190 Incompatible column data types in the result sets participating in the UNION statement
2191 Invalid Data Type
2192 GROUP BY and HAVING are not supported in UNION statement
2194 Unable to perform DISTINCT operation on some of the columns
2195 Column in the ORDER BY clause is not in the result set
2196 Column not found in GROUP BY clause
2197 Illegal VIEW operation
2198 Invalid PROCEDURE name
2199 This version of Advantage Database Server does not support stored procedures
2200 Error removing temporary input file
2201 Invalid Ordinal
2202 Invalid use of constant value
2203 Error encountered while reading an intermediate file
2204 The key specified as the primary key is too large
2205 A column specified in the index is of an invalid type
2206 Update statement is ambiguous
2207 Error creating input or output table temp filename
2208 A stored procedure s input value was truncated
2209 Table not unique
2210 Invalid index option
2211 CONTAINS * not allowed in GROUP BY statement
2212 Aggregate cannot be nested
2213 Invalid Collation
2214 Invalid Coercion
2215 Invalid options in CREATE TABLE statement
2216 Unexpected end of the SQL script
2217 A declaration statement in the SQL script is not valid
2218 Variable not found
2219 General SQL script error
2220 Cursor not open
2221 Cursor already open
2222 Invalid cursor column reference
2223 Cursor is not on a valid row
2224 An exception was raised in the SQL script
2225 Assignment error in the SQL script
2226 Invalid usage of a subquery
2227 Assignment out of range in the SQL script
2228 Invalid view definition
2229 Ambiguous reference in the SQL script
2230 Bad Function Definition
2231 Numeric Result Out Of Range
2232 Numeric Overflow
2233 Invalid DEBUG command
2234 Invalid Use of Parameter
2235 Select From Stored Procedure with No Output
2236 Conversion Error
2239 Invalid Procedure Arguments
24-hour
SQL literals
2xxx Error Codes
- 3 -
3000 General Advantage Expression Engine parser Error Code. Refer to the associated specific Error Code for more information.
3001 Incomplete index key expression
3002 Incorrect parameter count within a function call in index key expression
3003 Missing string delimiter in index key expression
3004 Literal value too long in index key expression
3005 Unsupported data type value in index key expression
3006 Unsupported operator found in index key expression
3007 Unsupported function found in index key expression
3008 Invalid delimiter in function parameter in index key expression
3009 Unsupported data type in function parameter in index key expression
3010 Unknown alias name used with field name in index key expression
3011 Unknown identifier found in index key expression
3014 Advantage Expression Engine memory allocation failed
3015 Invalid field type found in index key expression
3016 Advantage Expression Engine operator stack overflow
3017 Number of index key expression parameters exceed the capability of the parser
3018 Mismatched number of parentheses in the index key expression
3019 Parser working stack is about to overflow
3021 Advantage Expression Engine is not being used
3022 Advantage server thread s working stack about to overflow
3024 String collation error
3025 Unknown collation
3026 Unicode Conversion Error
30xx Error Codes
3101 Incomplete record filter expression
3102 Incorrect parameter count within a function call in record filter expression
3103 Missing string delimiter in record filter expression
3104 Literal value too long in record filter expression
3105 Unsupported data type value in record filter expression
3106 Unsupported operator found in record filter expression
3107 Unsupported function found in the record filter expression
3108 Invalid delimiter in function parameter in the record filter expression
3109 Unsupported data type in function parameter in the record filter expression
3110 Unknown alias name used with field name in the record filter expression
3111 Unknown identifier found in the record filter expression
3114 Advantage Expression Engine memory allocation failed
3115 Invalid field type found in the record filter expression
3116 Advantage Expression Engine operator stack overflow
3117 Number of record filter expression parameters exceed the capability of the parser
3118 Mismatched number of parentheses in the record filter expression
3119 Parser working stack is about to overflow
3121 Advantage Expression Engine is not being used
3122 Advantage server thread s working stack about to overflow
3124 String collation error
3126 Unicode Conversion Error
31xx Error Codes
3201 Incomplete conditional index expression
3202 Incorrect parameter count within a function call in conditional index expression
3203 Missing string delimiter in conditional index expression
3204 Literal value too long in conditional index expression
3205 Unsupported data type value in conditional index expression
3206 Unsupported operator found in conditional index expression
3207 Unsupported function found in conditional index expression
3208 Invalid delimiter in function parameter in conditional index expression
3209 Unsupported data type in function parameter in conditional index expression
3210 Unknown alias name used with field name in conditional index expression
3211 Unknown identifier found in conditional index expression
3214 Advantage Expression Engine memory allocation failed
3215 Invalid field type found in conditional index expression
3216 Advantage Expression Engine operator stack overflow
3217 Number of conditional index expression parameters exceed the capability of the parser
3218 Mismatched number of parentheses in the conditional index expression
3219 Parser working stack is about to overflow
3222 Advantage server thread s working stack about to overflow
3226 Unicode Conversion Error
32-bit
ads.ini file support
Advantage management utility
communication issues with NetWare
L2BIN expression engine function
NLM screen
number of connections
32MODMAN.EXE
32xx Error Codes
3301 Incomplete index while expression
3302 Incorrect parameter count within a function call in index while expression
3303 Missing string delimiter in index while expression
3304 Literal value too long in index while expression
3305 Unsupported data type value in index while expression
3306 Unsupported operator found in index while expression
3307 Unsupported function found in index while expression
3308 Invalid delimiter in function parameter in index while expression
3309 Unsupported data type in function parameter in index while expression
3310 Unknown alias name used with field name in index while expression
3311 Unknown identifier found in index while expression
3314 Advantage Expression Engine memory allocation failed
3315 Invalid field type found in index while expression
3316 Advantage Expression Engine operator stack overflow
3317 Number of index while expression parameters exceed the capability of the parser
3318 Mismatched number of parentheses in the index while expression
3319 Parser working stack is about to overflow
3322 Advantage server thread s working stack about to overflow
3323 Missing index while expression string
3326 Unicode Conversion Error
33xx Error Codes
3401 Incomplete is expression valid function expression
3402 Incorrect parameter count within a function call in is expression valid function expression
3403 Missing string delimiter in is expression valid function expression
3404 Literal value too long in is expression valid function expression
3405 Unsupported data type value in is expression valid function expression
3406 Unsupported operator found in is expression valid function expression
3407 Unsupported function found in is expression valid function expression
3408 Invalid delimiter in function parameter in is expression valid function expression
3409 Unsupported data type in function parameter in is expression valid function expression
3410 Unknown alias name used with field name in is expression valid function expression
3411 Unknown identifier found in is expression valid function expression
3414 Advantage Expression Engine memory allocation failed
3415 Invalid field type found in is expression valid function expression
3416 Advantage Expression Engine operator stack overflow
3417 Number of "is expression valid" function expression parameters exceed the capability of the parser
3418 Mismatched number of parentheses in the is expression valid function expression
3419 Parser working stack is about to overflow
3422 Advantage server threads working stack about to overflow
3426 Unicode Conversion Error
34xx Error Codes
3501 Incomplete expression
3502 Incorrect parameter count within a function call in expression
3503 Missing string delimiter in expression
3504 Literal value too long in expression
3505 Unsupported data type value in expression
3506 Unsupported operator found in expression
3507 Unsupported function found in expression
3508 Invalid delimiter in function parameter in expression
3509 Unsupported data type in function parameter in expression
3510 Unknown alias name used with field name in expression
3511 Unknown identifier found in expression
3514 Advantage Expression Engine memory allocation failed
3515 Invalid field type found in expression
3516 Advantage Expression Engine operator stack overflow
3517 Number of expression parameters exceed the capability of the parser
3518 Mismatched number of parentheses in the expression
3519 Parser working stack is about to overflow
3521 Advantage Expression Engine is not being used
3522 Advantage server thread s working stack about to overflow
3526 Unicode Conversion Error
35xx Error Codes
3x26 Unicode Conversion Error
- 4 -
4 GB
4000 General Advantage Expression Engine evaluator error code. Refer to associated specific Error Code for more information.
4004 Advantage Expression Engine evaluator stack overflow
4009 Unsupported data type in evaluated index key expression
4012 Invalid date evaluated in index key expression
4013 Invalid Julian date evaluated in index key expression
4017 Number of index key expression parameters exceed the capability of the evaluator
4019 Evaluator working stack is about to overflow
4020 Division by zero in index key expression
4025 Unknown collation
40-bit encryption
4104 Advantage Expression Engine evaluator stack overflow
4109 Unsupported data type in evaluated record filter expression
4112 Invalid date evaluated in record filter expression
4113 Invalid Julian date evaluated in record filter expression
4117 Number of record filter expression parameters exceed the capability of the evaluator
4119 Evaluator working stack is about to overflow
4120 Division by zero in record filter expression
4124 String Collation Error
4204 Advantage Expression Engine evaluator stack overflow
4209 Unsupported data type in evaluated conditional index expression
4212 Invalid date evaluated in conditional index expression
4213 Invalid Julian date evaluated in the conditional index expression
4217 Number of conditional index expression parameters exceed the capability of the evaluator
4219 Evaluator working stack is about to overflow
4220 Division by zero in conditional index expression
4304 Advantage Expression Engine evaluator stack overflow
4309 Unsupported data type in evaluated index while expression
4312 Invalid date evaluated in index while expression
4313 Invalid Julian date evaluated in index while expression
4317 Number of index while expression parameters exceed the capability of the evaluator
4319 Evaluator working stack is about to overflow
4320 Division by zero in index while expression
4xxx Error Codes
- 5 -
5001 AE_ALLOCATION_FAILED
5002 AE_COMM_MISMATCH
5003 AE_DATA_TOO_LONG
5004 AE_FILE_NOT_FOUND
5005 AE_INSUFFICIENT_BUFFER
5006 AE_INVALID_BOOKMARK
5007 AE_INVALID_CALLBACK
5008 AE_INVALID_CENTURY
5009 AE_INVALID_DATEFORMAT
5010 AE_INVALID_DECIMALS
5011 AE_INVALID_EXPRESSION
5012 AE_INVALID_FIELDDEF
5013 AE_INVALID_FILTER_OPTION
5014 AE_INVALID_INDEX_HANDLE
5015 AE_INVALID_INDEX_NAME
5016 AE_INVALID_INDEX_ORDER_NAME
5017 AE_INVALID_INDEX_TYPE
5018 AE_INVALID_HANDLE
5019 AE_INVALID_OPTION
5020 AE_INVALID_PATH
5021 AE_INVALID_POINTER
5022 AE_INVALID_RECORD_NUMBER
5023 AE_INVALID_TABLE_HANDLE
5024 AE_INVALID_CONNECTION_HANDLE
5025 AE_INVALID_TABLETYPE
5026 AE_INVALID_WORKAREA
5027 AE_INVALID_CHARSETTYPE
5028 AE_INVALID_LOCKTYPE
5029 AE_INVALID_RIGHTSOPTION
5030 AE_INVALID_FIELDNUMBER
5031 AE_INVALID_KEY_LENGTH
5032 AE_INVALID_FIELDNAME
5033 AE_NO_DRIVE_CONNECTION
5034 AE_FILE_NOT_ON_SERVER
5035 AE_LOCK_FAILED
5036 AE_NO_CONNECTION
5037 AE_NO_FILTER
5038 AE_NO_SCOPE
5039 AE_NO_TABLE
5040 AE_NO_WORKAREA
5041 AE_NOT_FOUND
5042 AE_NOT_IMPLEMENTED
5043 AE_MAX_THREADS_EXCEEDED
5044 AE_START_THREAD_FAIL
5045 AE_TOO_MANY_INDEXES
5046 AE_TOO_MANY_TAGS
5047 AE_TRANS_OUT_OF_SEQUENCE
5048 AE_UNKNOWN_ERRCODE
5049 AE_UNSUPPORTED_LANGUAGE
5050 AE_NAME_TOO_LONG
5051 AE_DUPLICATE_ALIAS
5053 AE_TABLE_CLOSED_IN_TRANSACTION
5054 AE_PERMISSION_DENIED
5055 AE_STRING_NOT_FOUND
5056 AE_UNKNOWN_CHAR_SET
5057 AE_INVALID_OEM_CHAR_FILE
5058 AE_INVALID_MEMO_BLOCK_SIZE
5059 AE_NO_FILE_FOUND
5060 AE_NO_INF_LOCK
5061 AE_INF_FILE_ERROR
5062 AE_RECORD_NOT_LOCKED
5063 AE_ILLEGAL_COMMAND_DURING_TRANS
5064 AE_TABLE_NOT_SHARED
5065 AE_INDEX_ALREADY_OPEN
5066 AE_INVALID_FIELD_TYPE
5067 AE_TABLE_NOT_EXCLUSIVE
5068 AE_NO_CURRENT_RECORD
5069 AE_PRECISION_LOST
5070 AE_INVALID_DATA_TYPE
5071 AE_DATA_TRUNCATED
5072 AE_TABLE_READONLY
5073 AE_INVALID_RECORD_LENGTH
5074 AE_NO_ERROR_MESSAGE
5075 AE_INDEX_SHARED
5076 AE_INDEX_EXISTS
5077 AE_CYCLIC_RELATION
5078 AE_INVALID_RELATION
5079 AE_INVALID_DAY
5080 AE_INVALID_MONTH
5081 AE_CORRUPT_TABLE
5082 AE_INVALID_BINARY_OFFSET
5083 AE_BINARY_FILE_ERROR
5084 AE_INVALID_DELETED_BYTE_VALUE
5085 AE_NO_PENDING_UPDATE
5086 AE_PENDING_UPDATE
5087 AE_TABLE_NOT_LOCKED
5088 AE_CORRUPT_INDEX
5089 AE_AUTOOPEN_INDEX
5090 AE_SAME_TABLE
5091 AE_INVALID_IMAGE
5092 AE_COLLATION_SEQUENCE_MISMATCH
5093 AE_INVALID_INDEX_ORDER
5094 AE_TABLE_CACHED
5095 AE_INVALID_DATE
5096 AE_ENCRYPTION_NOT_ENABLED
5097 AE_INVALID_PASSWORD
5098 AE_TABLE_ENCRYPTED
5099 AE_SERVER_MISMATCH
5100 AE_INVALID_USERNAME
5101 AE_INVALID_VALUE
5102 AE_INVALID_CONTINUE
5103 AE_UNRECOGNIZED_VERSION
5104 AE_RECORD_ENCRYPTED
5105 AE_UNRECOGNIZED_ENCRYPTION
5106 AE_INVALID_SQLSTATEMENT_HANDLE
5107 AE_INVALID_SQLCURSOR_HANDLE
5108 AE_NOT_PREPARED
5109 AE_CURSOR_NOT_CLOSED
5110 AE_INVALID_SQL_PARAM_NUMBER
5111 AE_INVALID_SQL_PARAM_NAME
5112 AE_INVALID_COLUMN_NUMBER
5113 AE_INVALID_COLUMN_NAME
5114 AE_INVALID_READONLY_OPTION
5115 AE_IS_CURSOR_HANDLE
5116 AE_INDEX_EXPR_NOT_FOUND
5117 AE_NOT_DML
5118 AE_INVALID_CONSTRAIN_TYPE
5119 AE_INVALID_CURSORHANDLE
5120 AE_OBSOLETE_FUNCTION
5121 AE_TADSDATASET_GENERAL
5122 AE_UDF_OVERWROTE_BUFFER
5123 AE_INDEX_UDF_NOT_SET
5124 AE_CONCURRENT_PROBLEM
5125 AE_INVALID_DICTIONARY_HANDLE
5126 AE_INVALID_PROPERTY_ID
5127 AE_INVALID_PROPERTY
5128 AE_DICTIONARY_ALREADY_EXISTS
5129 AE_INVALID_FIND_HANDLE
512-byte
index page size
memo files
reading
5130 AE_DD_REQUEST_NOT_COMPLETED
5131 AE_INVALID_OBJECT_ID
5132 AE_INVALID_OBJECT_NAME
5133 AE_INVALID_PROPERTY_LENGTH
5134 AE_INVALID_KEY_OPTIONS
5135 AE_CONSTRAINT_VALIDATION_ERROR
5136 AE_INVALID_OBJECT_TYPE
5137 AE_NO_OBJECT_FOUND
5138 AE_PROPERTY_NOT_SET
5139 AE_NO_PRIMARY_KEY_EXISTS
5140 AE_LOCAL_CONN_DISABLED
5141 AE_RI_RESTRICT
5142 AE_RI_CASCADE
5143 AE_RI_FAILED
5144 AE_RI_CORRUPTED
5145 AE_RI_UNDO_FAILED
5146 AE_RI_RULE_EXISTS
5147 AE_COLUMN_CANNOT_BE_NULL
5148 AE_MIN_CONSTRAINT_VIOLATION
5149 AE_MAX_CONSTRAINT_VIOLATION
5150 AE_RECORD_CONSTRAINT_VIOLATION
5151 AE_CANNOT_DELETE_TEMP_INDEX
5152 AE_RESTRUCTURE_FAILED
5153 AE_INVALID_STATEMENT
5154 AE_STORED_PROCEDURE_FAILED
5155 AE_INVALID_DICTIONARY_FILE
5156 AE_NOT_MEMBER_OF_GROUP
5157 AE_ALREADY_MEMBER_OF_GROUP
5158 AE_INVALID_OBJECT_RIGHT
5159 AE_CANNOT_OPEN_DATABASE_TABLE
5160 AE_INVALID_CONSTRAINT
5161 AE_NOT_ADMINISTRATOR
5162 AE_NO_TABLE_ENCRYPTION_PASSWORD
5163 AE_TABLE_NOT_ENCRYPTED
5164 AE_INVALID_ENCRYPTION_VERSION
5165 AE_NO_STORED_PROC_EXEC_RIGHTS
5166 AE_DD_UNSUPPORTED_DEPLOYMENT
5168 AE_INFO_AUTO_CREATION_OCCURRED
5169 AE_INFO_COPY_MADE_BY_CLIENT
5170 AE_DATABASE_REQUIRES_NEW_SERVER
5171 AE_COLUMN_PERMISSION_DENIED
5172 AE_DATABASE_REQUIRES_NEW_CLIENT
5173 AE_INVALID_LINK_NUMBER
5174 AE_LINK_ACTIVATION_FAILED
5175 AE_INDEX_COLLATION_MISMATCH
5176 AE_ILLEGAL_USER_OPERATION
5177 AE_TRIGGER_FAILED
5178 AE_NO_ASA_FUNCTION_FOUND
5179 AE_VALUE_OVERFLOW
5180 AE_UNRECOGNIZED_FTS_VERSION
5181 AE_TRIG_CREATION_FAILED
5182 AE_MEMTABLE_SIZE_EXCEEDED
5183 AE_OUTDATED_CLIENT_VERSION
5184 AE_FREE_TABLE
5185 AE_LOCAL_CONN_RESTRICTED
5186 AE_OLD_RECORD
5188 AE_KEY_EXCEEDS_PAGE_SIZE
5189 AE_TABLE_FOUND
5190 AE_TABLE_NOT_FOUND
5192 AE_INVALID_REPLICATION_IDENT
5194 AE_NO_MEMO_FILE
5195 AE_SUBSCRIPTION_QUEUE_NOT_EMPTY
5196 AE_UNABLE_TO_DISABLE_TRIGGERS
5197 AE_UNABLE_TO_ENABLE_TRIGGERS
5200 AE_BLURRY_SNAPSHOT
5201 AE_INVALID_VERTICAL_FILTER
5202 INVALID_USE_OF_HANDLE_IN_AEP
5203 AE_COLLATION_NOT_RECOGNIZED
5204 AE_INVALID_COLLATION
5205 AE_NOT_VFP_NULLABLE_FIELD
5206 AE_NOT_VFP_VARIABLE_FIELD
5208 AE_KEY_CANNOT_BE_NULL
5209 AE_COLLATIONS_DO_NOT_MATCH
5211 AE_UNICODE_CONVERSION
5212 AE_UNICODE_COLLATION
5400 AE_INTERNAL_ERROR
5401 AE_SOCKET_EXCEPTION
5402 AE_SOCKET_TIMEOUT
5403 AE_INCORRECT_RECV_AMOUNT
5404 AE_INCORRECT_SEND_AMOUNT
5405 AE_UNKNOWN_RESPONSE_TYPE
5406 AE_PRNG_NOT_AVAIL
5407 AE_CONNECTION_NOT_OPEN
5408 AE_INVALID_CHARSETTYPE
5409 AE_INVALID_TABLETYPE
5410 AE_INVALID_LOCKTYPE
5411 AE_INVALID_SERVER_NAME_OR_PORT
5412 AE_INVALID_CONNECTION_STRING
5413 AE_ISOLATION_LEVEL_NOT_SUPPORTED
5414 AE_CONNECTION_IS_READONLY
5415 AE_CANNOT_CHANGE_CATALOG
5416 AE_INVALID_RESULT_SET_TYPE
5417 AE_INVALID_CONCUR_TYPE
5418 AE_NOT_SUPPORTED
5419 AE_RESULTSET_EXPECTED
5420 AE_RESULTSET_NOTEXPECTED
5421 AE_INVALID_OPTION
5422 AE_DD_CONNECTION_EXPECTED
5423 AE_CONVERSION_ERROR
5424 AE_BAD_CATALOG
5425 AE_INVALID_VALUE
5426 AE_AFTER_LAST_ROW
5427 AE_BEFORE_FIRST_ROW
5428 AE_RESULTSET_CLOSED
5429 AE_INVALID_COLUMN_INDEX
5430 AE_INVALID_COLUMN_NAME
5431 AE_ROW_DELETED
5432 AE_INVALID_ROW_NUMBER
5433 AE_RESULTSET_NOT_UPDATABLE
5434 AE_NOT_ON_INSERT_ROW
5435 AE_ON_INSERT_ROW
5436 AE_NO_DELETE_PERMISSION
5437 AE_NO_INSERT_PERMISSION
5438 AE_NO_UPDATE_PERMISSION
5439 AE_COLUMN_NOT_NULLABLE
5440 AE_STREAM_IO_ERROR
5441 AE_METADATA_CLOSED
5442 AE_INVALID_PARAMETER_INDEX
5443 AE_UNSUPPORTED_PARAMETER_TYPE
5444 AE_ILLEGAL_OPERATION
5445 AE_STATEMENT_CLOSED
5446 AE_PARAMETER_NOT_SET
5447 AE_UNSUPPORTED_STATEMENT
5xxx Error Codes
- 6 -
6002 Index corruption detected
6010 Bad conditional index expression
6011 Index key is too long
6012 Invalid key length
6015 No Advantage Optimized Filter Exists
6020 No table open in current work area
6021 No index open
6022 Tag does not exist
6023 Bad tag number
6024 No current record
6025 Bad arguments
6026 Invalid data type
6027 Invalid master index
6028 Operation performed on a non-custom index
6030 Memo entry too long
6031 No memo file
6032 Invalid FPT memo block size
6033 Memo field does not exist
6034 Not an Advantage work area
6035 Incorrect client driver
6036 Encryption password does not exist
6037 No memo data exists
6040 Error opening file containing the BLOB
6041 Error creating BLOB file
6042 Illegal BLOB file length
6043 Error during BLOB file positioning
6044 File read error
6045 Memo field does not contain a BLOB
6046 File write error
6060 Advantage Database Server not started/loaded on specified server
6061 Low on memory
6062 Tables on different servers
6063 Local drive specified. Must access a network drive that has the Advantage server started/loaded
6064 Getting the computer name failed
6066 Invalid path specified
6067 Not logged into network
6069 Primary connection to Advantage server failed
6070 Low level network function initialization failed
6071 Connection to Advantage server failed
6072 Advantage client failure during creation of a Microsoft networking mailslot
6073 Advantage client failure during writing to a Microsoft networking mailslot
6074 Advantage client failure during reading to a Microsoft networking mailslot
6075 Request of Microsoft networking software configuration failed
6080 Error loading the Advantage remote communication layer DLL
6081 Error retrieving the function addresses in an Advantage DLL
6082 Error loading the Advantage Local Server DLL
6083 Error loading client expression engine DLL
6084 Error finding task in client expression engine DLL
6087 IPX not installed
6090 No structural index
6091 Index es open on destination table
6093 Table and index file on different servers
6094 Login reject
6095 Too many tags
6096 Not a compound index file
6097 Bad IP address specified in connection path or in ADS.INI file
60xx Error Codes
6101 Transaction command out of sequence
6102 XXXXXX is illegal during a transaction
6103 Failed transaction recovery error
6104 Invalid Password
6105 Password is required for this operation
6106 Non-compound IDX contains FTS index
6107 Index file with FTS indexes was not reindexed
61xx Error Codes
6201 Advantage Optimized Filter error No table open
6202 Advantage Optimized Filter error Not Advantage driver
6203 Advantage Optimized Filter error No indexes open
6204 Advantage Optimized Filter error No records in record filter
6205 Advantage Optimized Filter error Internal value error
6206 Advantage Optimized Filter error Mismatched string delimiters
6207 Advantage Optimized Filter error Mismatched parenthesis
6208 Advantage Optimized Filter error Expression syntax error
6209 Advantage Optimized Filter error Invalid expression data type
6210 Advantage Optimized Filter error Optimized record filter does not exist
6211 Advantage Optimized Filter error Expression string too long
6212 Advantage Optimized Filter error Low memory
6213 Advantage Optimized Filter error Set optimize is set to off
6214 Advantage Optimized Filter error Filter lengths different
6215 Advantage Optimized Filter error Cannot optimize this ORed
6216 Advantage Optimized Filter error Invalid range specified
6217 Advantage Optimized Filter error Locate command not optimized
6218 Advantage Optimized Filter error Real memory error
6219 Advantage Optimized Filter error Virtual memory error
6220 Advantage Optimized Filter error Bad record filter handle
6221 Advantage Optimized Filter error Record beyond record filter limits
6222 Advantage Optimized Filter error Unable to write record filter
6223 Advantage Optimized Filter error Unable to read record filter
6224 Advantage Optimized Filter error Error using index when
6225 Advantage Optimized Filter error Error seeking in index when
6226 Advantage Optimized Filter error Error creating file
6227 Advantage Optimized Filter error Error opening file
6228 Advantage Optimized Filter error Error parsing record filter
6229 Advantage Optimized Filter error Error evaluating record filter
6230 Advantage Optimized Filter error Missing or bad parameter
6231 Advantage Optimized Filter error Seek key not found
6232 AOF error Exceeded maximum number of array elements
62xx Error Codes
6301 Maximum number of local server table entries exhausted
6302 GetConnectionID failure
6303 Maximum Advantage Database Server connections exceeded
6304 ReadPropertyValue failure
6305 ScanBinderyObject failure
6306 IPXGetLocalTarget failure
6309 Bad ECB packets
6312 IPX socket table full
6313 General communication failure
6314 Error opening connection semaphore file
6316 The client driver and Advantage server communication layer versions are mismatched
6317 Advantage communication layer DLL initialized twice
6318 Compression initialization failure
6319 Compression failure
6320 Decompression failure
6321 Compression cleanup failure
6322 Maximum segment size exceeded
63xx Error Codes
6401 Invalid socket handle
6402 No system resources to open socket
6403 Internal SIPX system error
6404 Versions of NWSIPX.DLL and Client32 server are mismatched
6405 Invalid subnetwork handle
6406 No subnets available for IPX
6407 Data overflow in received message
6408 Datagram larger than is supported by WinSock
6409 WinSock version not supported or NetWare DLLs not found
6410 Destination address not available
6411 Network cannot be reached
6412 No buffers available
6413 Timed out
6414 Connection forcefully refused
6415 System not ready for network communication
6416 Requested version of sockets not supported
6417 General NCP request failure
6418 Unable to open service connection
6419 Unable to find server with Advantage started/loaded
6420 Unable to discover the Advantage Database Server
6421 The IP address for the given server was invalid or not found in ADS.INI
6422 The port for the given server was invalid or not found in ADS.INI
6423 Authentication failed
6424 Failed to locate ads.ini file
6425 An Advantage Data Dictionary connection is required for Internet connections
64-bit Notes
64-byte
64xx Error Codes
6602 Client comm layer timed out waiting for receive packet from the Advantage Database Server
6604 Timeout waiting for intermediate burst acknowledgement
6605 Client comm layer received more data from the Advantage Database Server than it was expecting
6606 Amount of client protocol command information to send was greater than the maximum allowed
6607 Protocol command information received by the client was not of the expected size
6609 Client comm layer received data of an unknown origin
6610 The Advantage Database Server did not respond to a database request in a timely manner
6611 Client communications layer timed out when attempting to send a packet
6612 Client comm layer received a packet that was out of sequence and was beyond the acceptable range of sequence numbers
6613 An IPX event was canceled
6614 IPX/SPX not initialized on client
6615 Client comm layer is out of DOS memory
6616 Client comm layer found no free ECBs available
6617 Client comm layer Winlock failed
6618 Maximum tasks reached or NetWare DLLs not found
6619 Client comm layer was already busy with one database operation when a second database operation was requested
6620 Client comm layer did not have the needed Advantage Database Server destination address
6621 Client comm layer attempted to use a send address that was already in use
6622 The winsock connection must be reset in the client comm layer
6623 A winsock virtual circuit was aborted
6624 A winsock virtual circuit was reset remotely
6625 Client comm layer socket is not connected
6626 Client comm layer socket already shut down
6627 Client comm layer winsock system was not properly initialized
6628 Client comm layer did not send all data
6629 Client comm layer received a packet from an incorrect source
6630 An invalid function pointer was found in the client comm layer
6631 An unexpected exception occurred in the client comm layer
6632 Watch dog thread creation failed
6633 The Advantage Database Server did not respond to a database request in a timely manner
6634 The inter-process communications IPC object is no longer valid
6669 Tag list is corrupt
66xx Error Codes
6701 An illegal buffer length was supplied
6703 An illegal command was supplied
6705 The command timed out
6706 A message was incomplete. The application needs to issue another command
6707 The buffer address specified was illegal
6708 The session number specified was out of range
6709 No resource was available
6710 The session was closed. ADSDOSIP shut down communications with the CA-Clipper application
6711 The command was canceled
6713 A duplicate name existed in the local name table
6714 The name table was full
6715 The command finished however the name has active sessions and is no longer registered
6717 The local session table was full
6718 The remote session table was full therefore the request to open a session was rejected
6719 An illegal name number was specified
6720 The system did not find the name that was called
6721 A * is not permitted in the ncb_name member
6722 The name was already in use on the remote adapter
6723 The name was deleted
6724 The session ended abnormally
6725 A name conflict was detected
6733 The interface was busy. IRET before retrying
6734 Too many commands were outstanding. The application can retry the command later
6735 The ncb_lana_num member did not specify a valid network number…
6736 The command finished while a cancel operation was occurring
6738 The NCBCANCEL command was not valid therefore the command was not canceled
6748 The name specified was defined by another local process
6752 The environment was not defined. A reset command must be issued
6753 System resources were exhausted. The application can retry the command later
6754 The maximum number of applications was exceeded
6755 Service access points SAPs were unavailable for NetBIOS
6756 The requested resources were not available
6757 The NCB address was invalid
6759 The NCB DDID was invalid
6760 The attempt to lock the user area failed
6763 An error occurred during an open operation being performed by the device driver
6764 A system error occurred
6770 The read received data that was too large
6771 The packet had a bad header
6772 The packet had bad data
67xx Error Codes
6801 Advantage client newer than Advantage server
6802 Advantage Database Server does not support AIS
6803 Error opening semaphore connection file
6804 Error accessing directory
6805 Error accessing a file
6806 Error accessing file or directory
6807 AIS error accessing file
6808 AIS error allocating resources
6809 AIS error unrecognized operation code
6810 AIS not supported
68xx Error Codes
6xxx Error Codes
- 7 -
7000 General Advantage server Error Code. Refer to the associated specific Error Code for more information
7001 No memory available
7002 Configuration error
7003 Maximum number of users exceeded
7004 Maximum number of work areas exceeded
7005 Maximum number of tables exceeded
7006 Maximum number of index files exceeded
7007 Maximum number of locks exceeded
7008 Advantage server file open failure
7009 Problem with Advantage server file write
7010 Problem with Advantage server file read
7011 Problem with Advantage server file seek
7012 Problem with Advantage server file offset
7013 Advantage server file access error
7014 Invalid DBF table
7015 Corrupt NTX
7016 Corrupt table
7017 Corrupt IDX CDX or ADI index
7017 Corrupt IDX or CDX
7018 Corrupt index empty page
7019 Corrupt memo field
7020 User logged out
7021 Maximum tags exceeded
7022 Maximum index levels
7023 Index expression not supported
7024 Removing ghost connection
7025 Semaphore connection file path too long
7026 Communication packet checksum failed
7027 User not logged in
7028 Invalid open mode
7029 Index Sort Buffer Size too small
7030 Missing Advantage configuration file ADS.CFG or ADSLOCAL.CFG
7031 Could not get Advantage configuration information
7032 Error in Advantage configuration parameter/value/data
7033 Maximum Number of Connections Exceeded
7034 Not a Compound Index File
7035 Record not visible
7036 Failed transaction recovery error
7037 Error with key in custom index
7038 Invalid record number
7039 File already open
7040 File creation error
7041 File not found
7042 Invalid bits set in the TPS semaphore byte
7043 Advantage Database Server for Windows is paused
7044 Advantage Server already on network
7045 Serial number and validation code mismatch
7046 Evaluation period expired
7047 Invalid bits set in the deleted byte
7048 EXTEND.CHR or ANSI.CHR file not found at load time by the Advantage Local Server
7049 Error occurred when the Advantage Local Server attempted to use the EXTEND.CHR or ANSI.CHR file
7050 The user is not connected to the Advantage server
7051 The file is not open on the Advantage server
7052 Cannot operate on the same table as source and destination
7053 VarChar fields are not supported with this operation
7054 Field data type mismatch
7055 Field size mismatch
7056 Invalid Connection Path
7057 Record update failed
7058 Corrupt ADI index
7059 Unique index creation error
7060 Invalid Password
7061 Encryption Version Mismatch
7062 Invalid NetWare Connection Number
7063 Query table full
7064 The IP protocol is not installed on the current machine
7065 Updates to records must meet the conditions of the SQL SELECT statement because the Constrained option has been selected
7066 Old Encryption Version
7067 NetWare Connection Number Not Found
7068 Encryption password is required for this operation
7069 The latest version of the Advantage client software is required with this version of the Advantage Database Server
7071 File is too large to be opened with the given settings
7072 The memo file associated with this table is corrupt
7073 The maximum number of memo blocks has been reached
7074 The table ID stored in the ADT table does not match the ID stored in the Advantage Data Dictionary file
7075 The Advantage Local Server version allows a maximum of 5 users to access a file at one time.
7076 No Primary key was found for the foreign key
7077 The Advantage Data Dictionary cannot be opened
7078 The Advantage Database Server cannot authenticate the user
7079 The user does not have read permission to the table
7080 The user does not have write rights to the table
7081 The encrypted table is using an older encryption method
7082 Internet access disabled
7083 An Advantage Data Dictionary connection is required
7084 Compression not allowed
7085 Invalid UNC server name
7086 Cannot open table directly
7087 Permission not granted for the requested operation
7088 The user could not be disconnected at this time
7089 Index creation aborted by the user
7090 Copy table or alter table operation aborted by user
7091 Collation sequence used to create the index differs from current collation sequence
7092 The index is not Advantage compatible
7093 Maximum number of recursion levels exceeded
7094 The full text search condition has an unclosed phrase
7095 The full text search condition has an unclosed expression
7096 The full text search condition is missing a phrase or word
7097 The full text search condition is not valid
7098 The full text search condition has invalid operands specified for the NEAR operator
7099 The full text search condition has an invalid distance specified for the NEAR operator
7100 Unrecognized full text search index version
7101 Failed Transaction Recovery successful
7102 No full text search indexes found
7103 The full text search condition is empty
7104 Transaction processing is not available on current connection
7105 Full Text Search Index Requires Newer Client
7106 The table is read only and cannot be encrypted
7107 The client s memo data is out of sync with the server
7108 Unrecognized ADI version
7109 Database logins are disabled
7110 Large key size requires newer client
7111 The temporary table is in use
7112 The temporary table cannot be found
7113 Database logins for this user have been disabled
7114 Unable to split index page
7115 Lock failure
7116 Unrecognized ADT table version
7117 Unrecognized ADM version
7118 RI Cascade Operation Failed
7119 Encryption Not Available
7120 Index Requires Dictionary Connection
7121 The client failed to respond while transferring data via inter-process communications
7122 Local server failed to rebuild index
7123 Unreconginzed Field Type
7124 Incorrect Record Count
7126 Backup in-memory table read failed
7127 Backup in-memory table write failed
7128 Backup index file copy failed
7129 Savepoint Not Found
7130 Illegal Operation Inside of Trigger
7131 Table is involved in another active backup command
7132 Subscription Information is Inconsistent
7133 Triggers are not allowed on live views
7134 Non-standard character used in table name or column name for replication
7135 No trigger defined for update type
7136 Serial number and replication code mismatch
7137
Permitted_Rep_Errors
7137 Unexpected number of records modified during a replication update
7138 Record Not Locked
7139 Invalid Packet Data Size
7140 Connection is already a debugger or debuggee
7141 The name is not a valid temporary table name
7142 The maximum number of debuggees was exceeded
7143 Cannot make a connection a debuggee
7144 Collation Repository Not Found
7145 Colation Load Failed
7146 Collation Name Not Unique
7147 Collation Name Not Found
7148 Collation Not Recognized
7149 Invalid Packet
7150 Collation Is Corrupt
7151 Invalid Table Type
7153 Key Cannot Be Null
7154 Index Automatically Rebuilt
7155
7155 Lost Cached Updates
7156 Auto Re-Indexing is Active
7157 Maximum number of active Unicode collators for a connection have been exceeded.
7158 The server cannot determine the default ANSI/OEM Unicode collation locale
7159 Cannot determine the code page for the default ANSI/OEM character set
7200 Advantage SQL Error
7201 The parameter number given exceeds the number of parameters in the SQL statement
7202 Data that resulted from the SQL statement is too long to be returned in a cursor
7203 Data that resulted from the SQL statement has an unknown length
7204 Too many columns exist in the SQL SELECT statement
7205 Cannot establish a connection to the Advantage SQL engine
7206 Cannot convert data from SQL format to Advantage format
7207 Unexpected error from the Advantage Server Agent
7208 One or more columns in the SQL SELECT statement contain a data type not supported by Advantage
7209 SQL query aborted by user
7211 Advantage cannot sort the SQL result set based on the ORDER BY clause because of internal limitation
7213 Server detected possible client communication failure
7600 Advantage Replication Error
7xxx Error Codes
- 8 -
8001 Unable to retrieve task number
8002 Unable to set task number
8003 Creating a thread failed
8004 Error opening or using a socket
8005 Semaphore creation failed
8006 ECB post error
8007 Error advertising service
8008 Screen failure
8009 Unable to disable connection
8010 Unable to set connection
8011 Receiving error
8012 Sending error
8013 Error updating memo file size in the server OS
8014 Error updating table size in the server OS
8015 Error updating index file size in the server OS
8016 Error updating TPS log file size in the server OS
8017 Get effective rights error
8018 Set end of file error
8019 Mutex creation failed
8020 Error when Advantage was reading from a Microsoft networking mailslot
8021 Error when Advantage was writing to a Microsoft networking mailslot
8022 Error when Advantage was closing a Microsoft networking mailslot
8023 Error getting servers computer name
8024 Error when Advantage attempted to create a Microsoft networking mailslot
8025 Error converting strings to/from unicode strings from/to 8-bit strings
8026 Error obtaining server drive information from server and share names
8027 Error creating sockets. No sockets were able to be created
8028 Error when initializing the WinSock DLL
8029 Registration of math function error handler failed
8030 Math function error
8034 Compression initialization failure
8035 Compression Cleanup Failure
8036 Error renaming file
8037 No IP network adapters found
8038 No network adapters found
8039 Registration Failure
8040 Error creating shared memory object
8041 Error creating inter-process communication semaphore
8042 Error creating security descriptor
8043 File copy failure
8044 ERR_UNABLE_TO_LOAD_ACE
8045 ERR_UNABLE_TO_LOAD_ACE_ENTRYPOINT
8046 Time function error
8224 - 8255 Errors returned by the IPX layer
8xxx Error Codes
- 9 -
9000 General Advantage Server Error Code. Refer to the associated specific Error Code for more information.
9001 Illegal memory resource
9002 Invalid UNC path
9003 Illegal user ID
9004 File close error
9005 Maximum work area element exceeded
9006 Maximum table element exceeded
9007 Maximum index table element exceeded
9008 Lock table error
9009 Invalid file handle
9011 Memory pages errors
9012 Illegal work area
9013 Illegal value
9014 Illegal index number
9015 Assertion failure
9016 Illegal flags
9017 No file name
9018 Invalid index type
9019 Illegal tag number
9020 Advantage server file length error
9021 Advantage server record length error
9022 Key not found
9023 Current value negative
9024 Invalid packet type
9025 Source data unreadable during a copy operation
9026 Receive packet out of sequence
9027 Receive request out of sequence
9028 Error retrieving an Advantage Local Server per thread/per task data structure
9029 Semaphore connection file creation error
9030 Illegal SET code
9031 Illegal Advantage Locking mode
9032 Resource list full
9033 Error creating merge file
9034 Too many merge streams
9035 Invalid merge stream
9036 Merge size too small
9037 Hardware key not found
9038 Error reading hardware key
9039 Mismatched hardware key number
9040 Invalid protocol Opcode
9041 Invalid record number
9042 Not exclusive user
9043 File open shared
9044 Locks existed for a table when no locks should exist
9045 Tag operation on IDX index file
9046 Write operation on read-only table
9047 Invalid Index open count
9048 Login User ID in use
9049 Invalid Advantage Local Server connection number
9050 Invalid unlock record number
9051 Invalid unlock work area
9052 Invalid memo block size
9053 TPS Visibility List element not found
9054 TPS Header List element not found
9055 TPS Log File data error
9056 TPS List not empty
9057 TPS Transaction failed
9058 Transaction command out of sequence
9059 Transaction data out of sync
9060 Invalid Control ID index
9061 Illegal memo type
9062 Illegal file offset
9063 Illegal command value
9064 Illegal skip value
9065 Illegal deleted byte value
9066 Illegal command during transaction
9067 Invalid data pointer
9068 File opened exclusively
9069 Illegal lock type
9070 Invalid source size
9071 Null SEEK pointer
9072 Illegal DBF version
9073 TPS commit failed
9074 Illegal BLOB request
9075 Boolean not TRUE or FALSE
9076 Non-compact IDX not supported
9077 Advantage server has suspended
9078 Illegal computer name received from client
9079 User s NetWare connection number not found during connect
9080 NetWare connection number mismatch
9082 Unrecognized data type used in record filter evaluation
9083 Invalid structure size specified in management API
9084 Invalid data size specified in management API
9085 User not specified in data in management API
9086 Indexes open on destination table
9087 Illegal table type
9088 Invalid query table index
9089 Failed to initialize the Advantage SQL engine
9090 Failed to allocate the Advantage SQL engine connection handle
9091 Failed to allocate the Advantage SQL engine statement handle
9092 Failure in the Advantage SQL engine. Check the Advantage error log for more information
9093 Failed to open a read-only cursor
9094 The operation cannot be performed on the statement because the cursor is still active
9095 The query table and work area are out of sync
9096 Error executing query
9097 Failed to obtain SQL error information
9098 Failed to free an AQE handle
9099 Failed to allocate an AQE handle
9100 Error retrieving parameter information from AQE
9101 Error preparing SQL statement
9102 Error binding SQL parameter
9103 Error binding SQL column
9104 Error retrieving row information from AQE
9105 Error retrieving column information from AQE
9106 Error fetching SQL data
9107 Error freeing statement handle
9108 Error disconnecting query handle
9109 Invalid encryption data specified when setting password
9110 Internal AOF error
9111 Memory buffer overwritten
9113 An expected referential integrity index reference was not found when performing an update operation
9114 An internal referential integrity lock map is in an unexpected state
9115 Problem Deamonizing
9116 Functionality is not Implemented
9117 An internal RI graph node was not found
9118 Compression failure
9119 Decompression failure
9120 Local task element index error
9121 Internal encryption password was not set when it should have been
9122 Internal Trigger Error
9123 An internal error was encountered in the full text search engine
9124 An unexpected internal error has occurred
9125 Key not found
9126 An internal error was encountered in the replication engine
9127 An internal error was encountered reading the index path tree data
9128 Temporary index key not found
9xxx Error Codes
- A -
Abend
Advantage TPS features
troubleshooting in NetWare
ABEND.LOG
send
AbEnds
troubleshooting in NetWare
Abnormal End
troubleshooting in NetWare
About
About the Authors
About the Examples
ABS()
Advantage SQL math function
expression engine function
scalar functions in a WHERE clause
SQL scalar functions
Access rights
check rights
ignore rights
limitations using local server
Accessing ADS Data
Accessing Advantage
over the Internet
Accessing Advantage Using
Accessing an ADS Table
Accessing Data Using
ACE
connecting clients through the Internet to Advantage
using referential integrity
ACE.AEF
read-ahead record caching
ACE.AEF file
read-ahead record caching
ACE32.DLL
Acknowledge-less packet
Acknowledgements
active
Active Index Selection
ActiveIndex
Advantage .NET Data Provider
ActiveX
Advantage Extended Procedures VB tutorial
COM and .NET AEP notes
creating an Advantage Extended Procedure
ActiveX Data Objects
ADO specific methods/properties
client-side/server-side cursors
movement operations
ActiveX DLLs
Advantage Extended Procedures VB tutorial
creating an Advantage Extended Procedure
Add AdsParameter
Advantage .NET Data Provider
Add int object
Advantage .NET Data Provider
Add object
Advantage .NET Data Provider
Add string DbType
Advantage .NET Data Provider
Add string DbType int string
Advantage .NET Data Provider
Add string object
Advantage .NET Data Provider
AddDM
Advantage TDataSet Descendant
AddIndex
Advantage TDataSet Descendant
AddIndexEx
Advantage TDataSet Descendant
AddIndexFile
Advantage TDataSet Descendant
Adding
users to groups
Adding Tables
Adding Users
Additional Advantage SQL Topics
Additional Field Data Types
Additional Methods Available to the ADSStatement Object in JDBC
Additional Replication Issues
AddProcedure
Advantage TDataSet Descendant
AddTable
Advantage TDataSet Descendant
AddUser
Advantage TDataSet Descendant
AddUserToGroup
Advantage TDataSet Descendant
AddView
Advantage TDataSet Descendant
ADI
Advantage Expression Engine operators
Advantage file formats overview
Advantage ISAM file types
Advantage Proprietary file format specifications
Advantage proprietary locking
compared to other index file types
conditional indexes
created with the unique property
general index file information
index page size
Number of Index Files configuration parameter
performance information
primary key support
unique indexes
ADM
about ADM memo files
Advantage file formats overview
performance information
storage block size
system requirements
ADM Memo Block Usage Example
Administrative Operations
Administrative Permissions
Advantage Data Dictionary
ADO
ADO specific methods/properties
client-side/server-side cursors
COM and .NET AEP notes
movement operations
Provider-Specific Connection Parameters
read-ahead record caching
reusing prepared queries in SQL
SELECT SQL statement
system requirements
Typical Connection String
ADO Specific Methods/Properties
ADO.NET
ADO.NET Entity Framework
Unsupported Functionality
AdOpenForwardOnly
read-ahead record caching
ADS
configuration utility for Windows
installation information
Internet security levels
open files tab in Advantage configuration utility
overview
setting
uninstalling in Windows NT/2000/2003
ADS daemon
ADS Revision
ADS Service
configuration utility for Windows
uninstalling in Windows NT/2000/2003
ADS Supported Table Types
ADS.CFG
communication issues with ADS and Windows
ignore rights
Internet IP Address configuration parameter
INTERNET_CLIENT_TIMEOUT configuration parameter
LAN IP address configuration parameter
NLM configuration file
Partial Connection Timeout configuration parameter
Semaphore connection file directory
setting the Internet port configuration parameter
Use Clustering configuration parameter
Use Dynamic Cursors configuration parameter
Ads.conf
case sensitive configuration option
INTERNET_CLIENT_TIMEOUT configuration parameter
Linux case sensitivity
overview
setting the Internet port configuration parameter
ADS.EXE
troubleshooting in Windows
ads.ini
Advantage Database Server discovery
database aliases and the ads.ini file
registry settings that affect communication
selecting Advantage server types
setting up your clients using
troubleshooting using Advantage Internet Server
ADS.NLM
changing the configuration
configuration parameters screen
loading the Advantage NLM
NLM screen
troubleshooting
unloading the Advantage NLM
ADS_AIS_SERVER
selecting server types via the ads.ini file
ads_autocommit
function in PHP
ADS_AUTOINC
ADS_CACHE_READS
ADS_CACHE_WRITES
ADS_CFG.REG
ads_close
function in PHP
ads_close_all
function in PHP
ads_commit
function in PHP
ads_connect
function in PHP
ads_cursor
function in PHP
ADS_DD_RI_SETDEFAULT
Advantage SQL grammar
ALTER TABLE SQL statement
CREATE TABLE SQL statement
ADS_DD_TABLE_AUTO_CREATE
ADS_DD_TABLE_CACHING
ADS_DD_TABLE_MEMO_BLOCK_SIZE
ADS_DD_TABLE_TXN_FREE
ads_default_ci
ads_default_cs
ads_do
function in PHP
ADS_ERR.ADT
Error Log File Size configuration parameter
ADS_ERR.DBF
Advantage TPS features
error and assert log path
error and diagnostic logs
Error Log File Size configuration parameter
installation information window
Internet connection errors
NLM screen
troubleshooting in Linux
troubleshooting in NetWare
troubleshooting in Windows
understanding Linux daemons
use in troubleshooting
ads_error
function in PHP
ads_errormsg
function in PHP
ads_exec
function in PHP
ads_execute
function in PHP
ads_fetch_array
function in PHP
ads_fetch_into
function in PHP
ads_fetch_row
function in PHP
ads_field_len
function in PHP
ads_field_nameword
function in PHP
ads_field_num
function in PHP
ads_field_precision
function in PHP
ads_field_scale
function in PHP
ads_field_type
function in PHP
ADS_FORCE_CLIPPER_MEMOS
in ads.ini file
ADS_FORCE_CLIPPER_MEMOS setting
ads_free_result
function in PHP
ADS_IGNORE_RIGHTS_CHECKING
ADS_INC_USERCOUNT
ADS_LOCAL_SERVER
selecting Advantage server types
Ads_log.txt
Linux daemons
troubleshooting in Linux
ads_longreadlen
function in PHP
ADS_MGMT_ACTIVITY_INFO
Advantage Client Engine
ADS_MGMT_COMM_STATS
Advantage Client Engine
ADS_MGMT_CONFIG_MEMORY
Advantage Client Engine
ADS_MGMT_CONFIG_PARAMS
Advantage Client Engine
ADS_MGMT_INDEX_INFO
Advantage Client Engine
ADS_MGMT_INSTALL_INFO
Advantage Client Engine
ADS_MGMT_RECORD_INFO
Advantage Client Engine
ADS_MGMT_TABLE_INFO
Advantage Client Engine
ADS_MGMT_THREAD_ACTIVITY
Advantage Client Engine
ADS_MGMT_USER_INFO
Advantage Client Engine
ads_num_fields
function in PHP
ads_num_rows
function in PHP
ADS_OPTIMIZED_FULL
AOF optimization
ADS_OPTIMIZED_NONE
AOF optimization
ADS_OPTIMIZED_PART
AOF optimization
ads_pconnect
function in PHP
ads_prepare
function in PHP
ADS_REMOTE_SERVER
selecting Advantage server types
ADS_RESOLVE_DYNAMIC
AOF performance tips
ADS_RESPECT_RIGHTS_CHECKING
ads_result
function in PHP
ads_result_all
function in PHP
ads_rollback
function in PHP
ADS_SCRIPT_EXCEPTION
ADS_SERVER_TYPE
selecting Advantage server types
ADS_SNAP.LOG file
troubleshooting in NetWare
troubleshooting in Windows
ADS_STORED_PROC_CON
ADS_TABLE_CACHE_NONE
ADS_TABLE_CACHE_READS
ADS_TABLE_CACHE_WRITES
AdsAddCustomKey
Advantage Client Engine
Advantage TDataSet Descendant
ADSADT
connecting clients through the Internet to Advantage
AdsAOFResolveImmediate
Advantage TDataSet Descendant
AdsAOFType
Advantage TDataSet Descendant
AdsAppendRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsApplicationExit
Advantage Client Engine
AdsAtBOF
Advantage Client Engine
AdsAtEOF
Advantage Client Engine
AdsAutoKeyFieldCount
Advantage TDataSet Descendant
adsbackup utility
AdsBackup.exe
AdsBeginTransaction
Advantage Client Engine
AdsBinaryFldLen
Advantage TDataSet Descendant
AdsBinaryToFile
Advantage Client Engine
Advantage TDataSet Descendant
AdsBuildRawKey
Advantage Client Engine
AdsBuildRawKey100
AdsCacheOpenCursors
Advantage Client Engine
AdsCacheOpenTables
Advantage Client Engine
AdsCacheRecords
Advantage CA-Visual Objects RDDs
Advantage Client Engine
Advantage TDataSet Descendant
AdsCachingOption
AdsCalcFieldsBeforeFilter
Advantage TDataSet Descendant
AdsCancelUpdate
Advantage Client Engine
AdsCharType
Advantage TDataSet Descendant
AdsCheckExistence
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearAllScopes
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearAOF
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearCallbackFunction
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearDefault
Advantage Client Engine
AdsClearFilter
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearProgressCallback
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearRelation
Advantage Client Engine
AdsClearScope
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearSQLAbortFunc
Advantage Client Engine
Advantage TDataSet Descendant
AdsClearSQLParams
Advantage Client Engine
AdsCloneTable
Advantage Client Engine
AdsCloseAllIndexes
Advantage Client Engine
Advantage TDataSet Descendant
AdsCloseAllTables
Advantage Client Engine
AdsCloseCachedTables
Advantage Client Engine
AdsCloseIndex
Advantage Client Engine
Advantage TDataSet Descendant
AdsCloseSQLStatement
Advantage Client Engine
Advantage TDataSet Descendant
AdsCloseTable
Advantage Client Engine
AdsCommand
Advantage .NET Data Provider
AdsCommand Constructor
Advantage .NET Data Provider
AdsCommand Constructor string
Advantage .NET Data Provider
AdsCommand Constructor string AdsConnection
Advantage .NET Data Provider
AdsCommand Constructor string AdsConnection AdsTransaction
Advantage .NET Data Provider
AdsCommand Constructors
Advantage .NET Data Provider
AdsCommand Methods
Advantage .NET Data Provider
AdsCommand Properties
Advantage .NET Data Provider
AdsCommand.Cancel
Advantage .NET Data Provider
AdsCommand.Cancelled
Advantage .NET Data Provider
AdsCommand.CommandText
Advantage .NET Data Provider
AdsCommand.CommandTimeout
Advantage .NET Data Provider
AdsCommand.CommandType
Advantage .NET Data Provider
AdsCommand.Connection
Advantage .NET Data Provider
AdsCommand.CreateParameter
Advantage .NET Data Provider
AdsCommand.DeriveParameters
Advantage .NET Data Provider
AdsCommand.ExecuteExtendedReader
Advantage .NET Data Provider
AdsCommand.ExecuteExtendedReader CommandBehavior
Advantage .NET Data Provider
AdsCommand.ExecuteNonQuery
Advantage .NET Data Provider
AdsCommand.ExecuteReader
Advantage .NET Data Provider
AdsCommand.ExecuteReader CommandBehavior
Advantage .NET Data Provider
AdsCommand.ExecuteScalar
Advantage .NET Data Provider
AdsCommand.LastAutoinc
Advantage .NET Data Provider
AdsCommand.Parameters
Advantage .NET Data Provider
AdsCommand.Prepare
Advantage .NET Data Provider
AdsCommand.Progress
Advantage .NET Data Provider
AdsCommand.ProgressMessage
Advantage .NET Data Provider
AdsCommand.TimedOut
Advantage .NET Data Provider
AdsCommand.Transaction
Advantage .NET Data Provider
AdsCommand.UpdatedRowSource
Advantage .NET Data Provider
AdsCommand.VerifySQL
AdsCommandBuilder
Advantage .NET Data Provider
AdsCommandBuilder Constructor
Advantage .NET Data Provider
AdsCommandBuilder Constructor AdsDataAdapter
Advantage .NET Data Provider
AdsCommandBuilder Constructors
Advantage .NET Data Provider
AdsCommandBuilder Methods
Advantage .NET Data Provider
AdsCommandBuilder Properties
Advantage .NET Data Provider
AdsCommandBuilder.DataAdapter
Advantage .NET Data Provider
AdsCommandBuilder.DeriveParameters
Advantage .NET Data Provider
AdsCommandBuilder.GetDeleteCommand
Advantage .NET Data Provider
AdsCommandBuilder.GetInsertCommand
Advantage .NET Data Provider
AdsCommandBuilder.GetUpdateCommand
Advantage .NET Data Provider
AdsCommandBuilder.QuotePrefix
Advantage .NET Data Provider
AdsCommandBuilder.QuoteSuffix
Advantage .NET Data Provider
AdsCommandBuilder.RefreshSchema
Advantage .NET Data Provider
AdsCommandBuilder.RequirePrimaryKey
Advantage .NET Data Provider
AdsCommandBuilder.UsePKOnlyInWhereClause
Advantage .NET Data Provider
AdsCommandBuilder.UseRowversionOnlyInWhereClause
Advantage .NET Data Provider
AdsCommitTransaction
Advantage Client Engine
AdsCompareBookmarks
Advantage Client Engine
AdsConnect
Advantage Client Engine
AdsConnect26
Advantage Client Engine
AdsConnect60
Advantage Client Engine
writing directly to ACE using AEPs
AdsConnection
Advantage TDataSet Descendant
AdsConnection Class
Advantage .NET Data Provider
AdsConnection Constructor
AdsConnection Constructor string
Advantage .NET Data Provider
AdsConnection Constructors
Advantage .NET Data Provider
AdsConnection Enumerations
Advantage .NET Data Provider
AdsConnection Events
Advantage .NET Data Provider
AdsConnection Methods
Advantage .NET Data Provider
AdsConnection Properties
Advantage .NET Data Provider
AdsConnection.AdsObjectType
Advantage .NET Data Provider
AdsConnection.BeginTransaction
Advantage .NET Data Provider
AdsConnection.BeginTransaction IsolationLevel
Advantage .NET Data Provider
AdsConnection.ChangeDatabase
Advantage .NET Data Provider
AdsConnection.Close
Advantage .NET Data Provider
AdsConnection.CloseCachedTables
Advantage .NET Data Provider
AdsConnection.ConnectionHandle
Advantage .NET Data Provider
AdsConnection.ConnectionString
Advantage .NET Data Provider
AdsConnection.ConnectionTimeout
Advantage .NET Data Provider
AdsConnection.CreateCommand
Advantage .NET Data Provider
AdsConnection.Database
Advantage .NET Data Provider
AdsConnection.DataSource
Advantage .NET Data Provider
AdsConnection.DateFormat
Advantage .NET Data Provider
AdsConnection.DDVersionMajor
Advantage .NET Data Provider
AdsConnection.DDVersionMinor
Advantage .NET Data Provider
AdsConnection.EnlistTransaction
Advantage .NET Data Provider
AdsConnection.Epoch
Advantage .NET Data Provider
AdsConnection.FlushConnectionPool
Advantage .NET Data Provider
AdsConnection.FlushConnectionPool string
Advantage .NET Data Provider
AdsConnection.GetDDObjects
Advantage .NET Data Provider
AdsConnection.GetTableNames
Advantage .NET Data Provider
AdsConnection.InfoMessage
Advantage .NET Data Provider
AdsConnection.IsConnectionAlive
Advantage .NET Data Provider
AdsConnection.IsDictionaryConn
Advantage .NET Data Provider
AdsConnection.Open
Advantage .NET Data Provider
AdsConnection.ServerName
Advantage .NET Data Provider
AdsConnection.ServerTime
Advantage .NET Data Provider
AdsConnection.ServerType
Advantage .NET Data Provider
AdsConnection.ServerVersion
Advantage .NET Data Provider
AdsConnection.SetCursorCache
Advantage .NET Data Provider
AdsConnection.SetTableCache
Advantage .NET Data Provider
AdsConnection.State
Advantage .NET Data Provider
AdsConnection.StateChange
Advantage .NET Data Provider
AdsConnectionStringBuilder
Advantage .NET Data Provider
constructors
methods
properties
AdsConnectionStringBuilder Constructor
Advantage .NET Data Provider
AdsConnectionStringBuilder Constructors
Advantage .NET Data Provider
AdsConnectionStringBuilder Data Source Properties
Advantage .NET Data Provider
AdsConnectionStringBuilder Methods
Advantage .NET Data Provider
AdsConnectionStringBuilder Properties
Advantage .NET Data Provider
AdsConnectionStringBuilder.Clear
Advantage .NET Data Provider
AdsConnectionStringBuilder.ConnectionString
Advantage .NET Data Provider
AdsConnectionStringBuilder.Remove
Advantage .NET Data Provider
AdsContinue
Advantage Client Engine
Advantage TDataSet Descendant
AdsConvertTable
Advantage Client Engine
Advantage TDataSet Descendant
AdsCopyTable
Advantage Client Engine
Advantage TDataSet extended method
callback functionality
AdsCopyTableContents
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsCopyTableStructure
Advantage Client Engine
Advantage TDataSet Descendant
AdsCreateFTSIndex
Advantage Client Engine
AdsCreateIndex
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
indexes with expressions
AdsCreateIndex61
Advantage Client Engine
AdsCreateIndex90
Advantage Client Engine
AdsCreateSavepoint
Advantage Client Engine
AdsCreateSQLStatement
Advantage Client Engine
AdsCreateTable
Advantage Client Engine
Advantage TDataSet Descendant
AdsCreateTable71
Advantage Client Engine
AdsCreateTable90
Advantage Client Engine
AdsCustomizeAOF
Advantage Client Engine
Advantage TDataSet Descendant
Adsd
changing the Advantage Linux configuration
installing the Advantage Database Server daemon for Linux
understanding Linux daemons
Adsd threads
AdsDataAdapter
Advantage .NET Data Provider
AdsDataAdapter Constructor
Advantage .NET Data Provider
AdsDataAdapter Constructor AdsCommand
Advantage .NET Data Provider
AdsDataAdapter Constructor String AdsConnection
Advantage .NET Data Provider
AdsDataAdapter Constructor String String
Advantage .NET Data Provider
AdsDataAdapter Constructors
Advantage .NET Data Provider
AdsDataAdapter Events
Advantage .NET Data Provider
AdsDataAdapter Methods
Advantage .NET Data Provider
AdsDataAdapter Properties
Advantage .NET Data Provider
AdsDataAdapter.CreateRowUpdatedEvent
Advantage .NET Data Provider
AdsDataAdapter.CreateRowUpdatingEvent
Advantage .NET Data Provider
AdsDataAdapter.DeleteCommand
Advantage .NET Data Provider
AdsDataAdapter.Fill
Advantage .NET Data Provider
AdsDataAdapter.FillError
Advantage .NET Data Provider
AdsDataAdapter.FillSchema
Advantage .NET Data Provider
AdsDataAdapter.GetFillParameters
Advantage .NET Data Provider
AdsDataAdapter.InsertCommand
Advantage .NET Data Provider
AdsDataAdapter.MissingMappingAction
Advantage .NET Data Provider
AdsDataAdapter.MissingSchemaAction
Advantage .NET Data Provider
AdsDataAdapter.OnFillError
Advantage .NET Data Provider
AdsDataAdapter.OnRowUpdated
Advantage .NET Data Provider
AdsDataAdapter.OnRowUpdating
Advantage .NET Data Provider
AdsDataAdapter.SelectCommand
Advantage .NET Data Provider
AdsDataAdapter.TableMappings
Advantage .NET Data Provider
AdsDataAdapter.Update
Advantage .NET Data Provider
AdsDataAdapter.UpdateCommand
Advantage .NET Data Provider
AdsDataReader
Advantage .NET Data Provider
AdsDataReader Methods
Advantage .NET Data Provider
AdsDataReader Properties
Advantage .NET Data Provider
AdsDataReader.Close
Advantage .NET Data Provider
AdsDataReader.Depth
Advantage .NET Data Provider
AdsDataReader.FieldCount
Advantage .NET Data Provider
AdsDataReader.GetBoolean
Advantage .NET Data Provider
AdsDataReader.GetByte
Advantage .NET Data Provider
AdsDataReader.GetBytes
Advantage .NET Data Provider
AdsDataReader.GetBytes int long byte[] int int
Advantage .NET Data Provider
AdsDataReader.GetChar
Advantage .NET Data Provider
AdsDataReader.GetChars
Advantage .NET Data Provider
AdsDataReader.GetData
Advantage .NET Data Provider
AdsDataReader.GetDataTypeName
Advantage .NET Data Provider
AdsDataReader.GetDateTime
Advantage .NET Data Provider
AdsDataReader.GetDecimal
Advantage .NET Data Provider
AdsDataReader.GetDouble
Advantage .NET Data Provider
AdsDataReader.GetFieldType
Advantage .NET Data Provider
AdsDataReader.GetFloat
Advantage .NET Data Provider
AdsDataReader.GetGuid
Advantage .NET Data Provider
AdsDataReader.GetInt16
Advantage .NET Data Provider
AdsDataReader.GetInt32
Advantage .NET Data Provider
AdsDataReader.GetInt64
Advantage .NET Data Provider
AdsDataReader.GetName
Advantage .NET Data Provider
AdsDataReader.GetOrdinal
Advantage .NET Data Provider
AdsDataReader.GetSchemaTable
Advantage .NET Data Provider
AdsDataReader.GetString
Advantage .NET Data Provider
AdsDataReader.GetTimeSpan
Advantage .NET Data Provider
AdsDataReader.GetValue
Advantage .NET Data Provider
AdsDataReader.GetValues
Advantage .NET Data Provider
AdsDataReader.HasRows
Advantage .NET Data Provider
AdsDataReader.IsClosed
Advantage .NET Data Provider
AdsDataReader.IsDBNull
Advantage .NET Data Provider
AdsDataReader.IsStatic
Advantage .NET Data Provider
AdsDataReader.Item
Advantage .NET Data Provider
AdsDataReader.NextResult
Advantage .NET Data Provider
AdsDataReader.Read
Advantage .NET Data Provider
AdsDataReader.RecordCache
Advantage .NET Data Provider
AdsDataReader.RecordsAffected
Advantage .NET Data Provider
AdsDDAddIndexFile
Advantage Client Engine
AdsDDAddProcedure
Advantage Client Engine
AdsDDAddTable
Advantage Client Engine
AdsDDAddTable90
Advantage Client Engine
AdsDDAddUserToGroup
Advantage Client Engine
AdsDDAddView
Advantage Client Engine
AdsDDCreate
Advantage Client Engine
AdsDDCreateArticle
Advantage Client Engine
AdsDDCreateLink
Advantage Client Engine
using tables from multiple data dictionaries
AdsDDCreatePublication
Advantage Client Engine
AdsDDCreateRefIntegrity
Advantage Client Engine
AdsDDCreateRefIntegrity62
Advantage Client Engine
AdsDDCreateSubscription
Advantage Client Engine
AdsDDCreateTrigger
Advantage Client Engine
AdsDDCreateUser
Advantage Client Engine
AdsDDCreateUserGroup
Advantage Client Engine
AdsDDDeleteArticle
Advantage Client Engine
AdsDDDeleteIndex
Advantage Client Engine
AdsDDDeletePublication
Advantage Client Engine
AdsDDDeleteSubscription
Advantage Client Engine
AdsDDDeleteUser
Advantage Client Engine
AdsDDDeleteUserGroup
Advantage Client Engine
AdsDDDeployDatabase
Advantage Client Engine
Advantage TDataSet Descendant
AdsDDDropLink
Advantage Client Engine
AdsDDFindClose
Advantage Client Engine
AdsDDFindFirstObject
Advantage Client Engine
AdsDDFindNextObject
Advantage Client Engine
AdsDDFreeTable
Advantage Client Engine
AdsDDGetArticleProperty
Advantage Client Engine
AdsDDGetDatabaseProperty
Advantage Client Engine
AdsDDGetFieldProperty
Advantage Client Engine
AdsDDGetIndexFileProperty
Advantage Client Engine
AdsDDGetIndexProperty
Advantage Client Engine
AdsDDGetLinkProperty
Advantage Client Engine
AdsDDGetPermissions
Advantage Client Engine
AdsDDGetProcedureProperty
Advantage Client Engine
AdsDDGetPublicationProperty
Advantage Client Engine
AdsDDGetRefIntegrityProperty
Advantage Client Engine
AdsDDGetSubscriptionProperty
Advantage Client Engine
AdsDDGetTableProperty
Advantage Client Engine
AdsDDGetTriggerProperty
Advantage Client Engine
AdsDDGetUserGroupProperty
Advantage Client Engine
AdsDDGetUserProperty
Advantage Client Engine
AdsDDGetViewProperty
Advantage Client Engine
AdsDDGrantPermission
Advantage Client Engine
AdsDDModifyLink
Advantage Client Engine
AdsDDMoveObjectFile
Advantage Client Engine
AdsDDRemoveIndexFile
Advantage Client Engine
AdsDDRemoveProcedure
Advantage Client Engine
AdsDDRemoveRefIntegrity
Advantage Client Engine
AdsDDRemoveTable
Advantage Client Engine
AdsDDRemoveTrigger
Advantage Client Engine
AdsDDRemoveUserFromGroup
Advantage Client Engine
AdsDDRemoveView
Advantage Client Engine
AdsDDRenameObject
Advantage Client Engine
AdsDDRevokePermission
Advantage Client Engine
AdsDDSetArticleProperty
Advantage Client Engine
AdsDDSetDatabaseProperty
Advantage Client Engine
AdsDDSetFieldProperty
Advantage Client Engine
AdsDDSetIndexProperty
Advantage Client Engine
AdsDDSetProcedureProperty
Advantage Client Engine
AdsDDSetPublicationProperty
Advantage Client Engine
AdsDDSetSubscriptionProperty
Advantage Client Engine
AdsDDSetTableProperty
Advantage Client Engine
AdsDDSetUserGroupProperty
Advantage Client Engine
AdsDDSetUserProperty
Advantage Client Engine
AdsDDSetViewProperty
Advantage Client Engine
AdsDecryptRecord
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsDecryptTable
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsDeleteCustomKey
Advantage Client Engine
Advantage TDataSet Descendant
AdsDeleteIndex
Advantage Client Engine
Advantage TDataSet Descendant
AdsDeleteRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsDisableAutoIncEnforcement
Advantage Client Engine
AdsDisableEncryption
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsDisableRI
Advantage Client Engine
AdsDisableUniqueEnforcement
Advantage Client Engine
AdsDisconnect
Advantage Client Engine
ADSDOSIP
Advantage Internet Server overview
adsdump Files
AdsEnableAutoIncEnforcement
Advantage Client Engine
AdsEnableEncryption
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsEnableRI
Advantage Client Engine
AdsEnableUniqueEnforcement
Advantage Client Engine
AdsEncryptRecord
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsEncryptTable
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsEvalAOF
Advantage Client Engine
Advantage TDataSet Descendant
AdsEvalEOF100
AdsEvalLogicalExpr
Advantage Client Engine
AdsEvalNumericExpr
Advantage Client Engine
AdsEvalStringExpr
Advantage Client Engine
AdsEvalTestExpr
Advantage Client Engine
AdsEventHandler
AdsException
Advantage .NET Data Provider
AdsException Properties
Advantage .NET Data Provider
AdsException.Message
Advantage .NET Data Provider
AdsException.Number
Advantage .NET Data Provider
AdsException.State
Advantage .NET Data Provider
AdsExecuteSQL
Advantage Client Engine
callback functionality
processing heuristics
AdsExecuteSQLDirect
Advantage Client Engine
AdsExecuteSQLDirectW
AdsExtendedReader
Advantage .NET Data Provider
AdsExtendedReader Enumerations
Advantage .NET Data Provider
AdsExtendedReader Events
Advantage .NET Data Provider
AdsExtendedReader Methods
Advantage .NET Data Provider
AdsExtendedReader Properties
Advantage .NET Data Provider
AdsExtendedReader.ActiveIndex
Advantage .NET Data Provider
AdsExtendedReader.AdsActiveHandle
Advantage .NET Data Provider
AdsExtendedReader.AdsHandle
Advantage .NET Data Provider
AdsExtendedReader.AppendRecord
Advantage .NET Data Provider
AdsExtendedReader.BOF
Advantage .NET Data Provider
AdsExtendedReader.Cancel
Advantage .NET Data Provider
AdsExtendedReader.ClearRange
Advantage .NET Data Provider
AdsExtendedReader.CompareBookmarks
Advantage .NET Data Provider
AdsExtendedReader.ConvertTable
Advantage .NET Data Provider
AdsExtendedReader.CopyTable
Advantage .NET Data Provider
AdsExtendedReader.CopyTableStructure
Advantage .NET Data Provider
AdsExtendedReader.CreateIndex
Advantage .NET Data Provider
AdsExtendedReader.DecryptTable
Advantage .NET Data Provider
AdsExtendedReader.DeleteIndex
Advantage .NET Data Provider
AdsExtendedReader.DeleteRecord
Advantage .NET Data Provider
AdsExtendedReader.EncryptionPassword
Advantage .NET Data Provider
AdsExtendedReader.EncryptTable
Advantage .NET Data Provider
AdsExtendedReader.EOF
Advantage .NET Data Provider
AdsExtendedReader.Filter
Advantage .NET Data Provider
AdsExtendedReader.FilterOption
Advantage .NET Data Provider
AdsExtendedReader.GetBookmark
Advantage .NET Data Provider
AdsExtendedReader.GetIndexNames
Advantage .NET Data Provider
AdsExtendedReader.GetRecordCount
Advantage .NET Data Provider
AdsExtendedReader.GotoBOF
Advantage .NET Data Provider
AdsExtendedReader.GotoBookmark
Advantage .NET Data Provider
AdsExtendedReader.GotoBottom
Advantage .NET Data Provider
AdsExtendedReader.GotoTop
Advantage .NET Data Provider
AdsExtendedReader.IndexCondition
Advantage .NET Data Provider
AdsExtendedReader.IndexExpression
Advantage .NET Data Provider
AdsExtendedReader.IndexOptions
Advantage .NET Data Provider
AdsExtendedReader.IsIndexCompound
Advantage .NET Data Provider
AdsExtendedReader.IsIndexCustom
Advantage .NET Data Provider
AdsExtendedReader.IsIndexDescending
Advantage .NET Data Provider
AdsExtendedReader.IsIndexPrimaryKey
Advantage .NET Data Provider
AdsExtendedReader.IsIndexUnique
Advantage .NET Data Provider
AdsExtendedReader.IsRecordDeleted
Advantage .NET Data Provider
AdsExtendedReader.IsRecordLocked
Advantage .NET Data Provider
AdsExtendedReader.IsTableLocked
Advantage .NET Data Provider
AdsExtendedReader.Item
Advantage .NET Data Provider
AdsExtendedReader.LastAutoinc
Advantage .NET Data Provider
AdsExtendedReader.LockRecord
Advantage .NET Data Provider
AdsExtendedReader.LockTable
Advantage .NET Data Provider
AdsExtendedReader.LogicalRecordNumber
Advantage .NET Data Provider
AdsExtendedReader.OpenIndex
Advantage .NET Data Provider
AdsExtendedReader.PackTable
Advantage .NET Data Provider
AdsExtendedReader.PartialMatch
Advantage .NET Data Provider
AdsExtendedReader.Progress
Advantage .NET Data Provider
AdsExtendedReader.ProgressMessage
Advantage .NET Data Provider
AdsExtendedReader.ReadPrevious
Advantage .NET Data Provider
AdsExtendedReader.RecallAllRecords
Advantage .NET Data Provider
AdsExtendedReader.RecallRecord
Advantage .NET Data Provider
AdsExtendedReader.RecordNumber
Advantage .NET Data Provider
AdsExtendedReader.Reindex
Advantage .NET Data Provider
AdsExtendedReader.RelativeKeyPosition
Advantage .NET Data Provider
AdsExtendedReader.Seek
Advantage .NET Data Provider
AdsExtendedReader.SeekType
Advantage .NET Data Provider
AdsExtendedReader.SetBoolean
Advantage .NET Data Provider
AdsExtendedReader.SetByte
Advantage .NET Data Provider
AdsExtendedReader.SetBytes
Advantage .NET Data Provider
AdsExtendedReader.SetChars
Advantage .NET Data Provider
AdsExtendedReader.SetDateTime
Advantage .NET Data Provider
AdsExtendedReader.SetDecimal
Advantage .NET Data Provider
AdsExtendedReader.SetDouble
Advantage .NET Data Provider
AdsExtendedReader.SetFloat
Advantage .NET Data Provider
AdsExtendedReader.SetInt16
Advantage .NET Data Provider
AdsExtendedReader.SetInt32
Advantage .NET Data Provider
AdsExtendedReader.SetInt64
Advantage .NET Data Provider
AdsExtendedReader.SetRange
Advantage .NET Data Provider
AdsExtendedReader.SetString
Advantage .NET Data Provider
AdsExtendedReader.SetTimeSpan
Advantage .NET Data Provider
AdsExtendedReader.SetValue
Advantage .NET Data Provider
AdsExtendedReader.TableType
Advantage .NET Data Provider
AdsExtendedReader.UnlockRecord
Advantage .NET Data Provider
AdsExtendedReader.UnlockTable
Advantage .NET Data Provider
AdsExtendedReader.WriteRecord
Advantage .NET Data Provider
AdsExtendedReader.ZapTable
Advantage .NET Data Provider
AdsExtractKey
Advantage Client Engine
Advantage TDataSet Descendant
AdsFactory
Advantage .NET Data Provider
fields
methods
overview
AdsFactory Fields
Advantage .NET Data Provider
AdsFactory.CreateCommand
Advantage .NET Data Provider
AdsFactory.CreateCommandBuilder
Advantage .NET Data Provider
AdsFactory.CreateConnection
Advantage .NET Data Provider
AdsFactory.CreateConnectionStringBuilder
Advantage .NET Data Provider
AdsFactory.CreateDataAdapter
Advantage .NET Data Provider
AdsFactory.CreateParameter
Advantage .NET Data Provider
AdsFactory.Instance
Advantage .NET Data Provider
AdsFailedTransactionRecovery
Advantage Client Engine
AdsFileToBinary
Advantage Client Engine
Advantage TDataSet Descendant
AdsFilterOptions
Advantage TDataSet Descendant
AdsFindClose
Advantage Client Engine
AdsFindConnection
Advantage Client Engine
AdsFindConnection25
Advantage Client Engine
AdsFindFirstTable
Advantage Client Engine
AdsFindFirstTable62
Advantage Client Engine
AdsFindNextTable
Advantage Client Engine
AdsFindNextTable62
Advantage Client Engine
AdsFlushFileBuffers
Advantage Client Engine
Advantage TDataSet Descendant
AdsFreshRecordCount
Advantage TDataSet Descendant
AdsGetActiveLinkInfo
Advantage Client Engine
AdsGetAllIndexes
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetAllLocks
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetAllTables
Advantage Client Engine
AdsGetAOF
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetAOF100
AdsGetAOFOptLevel
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetAOFOptLevel100
AdsGetBinary
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetBinaryLength
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetBookmark
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetBookmark60
Advantage Client Engine
AdsGetBookmarkLength
Advantage Client Engine
AdsGetCollation
Advantage Client Engine
AdsGetCollationLang
AdsGetConnectionPath
Advantage Client Engine
AdsGetConnectionProperty
Advantage Client Engine
AdsGetConnectionType
Advantage Client Engine
AdsGetDate
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetDateFormat
Advantage Client Engine
AdsGetDateFormat60
Advantage Client Engine
AdsGetDecimals
Advantage Client Engine
AdsGetDefault
Advantage Client Engine
AdsGetDeleted
Advantage Client Engine
AdsGetDouble
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetEpoch
Advantage Client Engine
AdsGetErrorString
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetExact
Advantage Client Engine
AdsGetExact22
Advantage Client Engine
AdsGetField
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldDecimals
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldLength
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldLength100
AdsGetFieldName
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldNum
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldOffset
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldType
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFieldW
AdsGetFilter
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetFTSIndexes
Advantage Client Engine
AdsGetFTSIndexInfo
Advantage Client Engine
AdsGetHandleLong
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetHandleType
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexCollation
Advantage Client Engine
AdsGetIndexCondition
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexExpr
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexFilename
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexHandle
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexHandleByExpr
Advantage Client Engine
AdsGetIndexHandleByOrder
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexName
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetIndexOrderByHandle
Advantage Client Engine
AdsGetJulian
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetKeyColumn
Advantage Client Engine
AdsGetKeyCount
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetKeyLength
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetKeyNum
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetKeyType
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetLastAutoinc
Advantage Client Engine
AdsGetLastError
Advantage Client Engine
Advantage TDataSet Descendant
connecting clients through the Internet to Advantage
AdsGetLastTableUpdate
Advantage Client Engine
AdsGetLogical
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetLong
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetLongLong
Advantage Client Engine
AdsGetMemoBlockSize
Advantage Client Engine
AdsGetMemoDataType
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetMemoLength
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetMilliseconds
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetMoney
Advantage Client Engine
AdsGetNumActiveLinks
Advantage Client Engine
AdsGetNumFields
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetNumFTSIndexes
Advantage Client Engine
AdsGetNumIndexes
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetNumLocks
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetNumOpenTables
Advantage Client Engine
AdsGetRecord
Advantage Client Engine
AdsGetRecordCount
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetRecordCRC
Advantage Client Engine
AdsGetRecordLength
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetRecordNum
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetRelKeyPos
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetScope
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetSearchPath
Advantage Client Engine
AdsGetServerName
Advantage Client Engine
AdsGetServerTime
Advantage Client Engine
AdsGetShort
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetSQLStatement
Advantage Client Engine
AdsGetSQLStatementHandle
Advantage Client Engine
AdsGetString
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetStringW
AdsGetTableAlias
Advantage Client Engine
AdsGetTableCharType
Advantage Client Engine
AdsGetTableCollation
Advantage Client Engine
AdsGetTableConnection
Advantage Client Engine
AdsGetTableFileName
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetTableHandle
Advantage Client Engine
AdsGetTableHandle25
Advantage Client Engine
AdsGetTableLockType
Advantage Client Engine
AdsGetTableOpenOptions
Advantage Client Engine
AdsGetTableRights
Advantage Client Engine
AdsGetTableType
Advantage Client Engine
AdsGetTime
Advantage Client Engine
Advantage TDataSet Descendant
AdsGetTransactionCount
Advantage Client Engine
AdsGetVersion
Advantage Client Engine
Advantage TDataSet Descendant
AdsGotoBookmark
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsGotoBookmark60
Advantage Client Engine
callback functionality
AdsGotoBottom
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsGotoRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsGotoTop
Advantage Client Engine
Advantage TDataSet Descendant
AdsHandle
Advantage .NET Data Provider
AdsImageToClipboard
Advantage Client Engine
Advantage TDataSet Descendant
AdsIndexPageSize
Advantage TDataSet Descendant
AdsInfoMessageEventArgs
Advantage .NET Data Provider
AdsInfoMessageEventArgs Properties
Advantage .NET Data Provider
AdsInfoMessageEventArgs.Message
Advantage .NET Data Provider
AdsInfoMessageEventArgs.Number
Advantage .NET Data Provider
adsini_path
AdsInitRawKey
Advantage Client Engine
AdsInTransaction
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsConnectionAlive
Advantage Client Engine
AdsIsEmpty
Advantage Client Engine
Advantage TDataSet Descendant
null field values
AdsIsEncryptionEnabled
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsIsExprValid
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsFound
Advantage Client Engine
AdsIsIndexCandidate
Advantage Client Engine
AdsIsIndexCompound
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsIndexCustom
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsIndexDescending
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsIndexFTS
Advantage Client Engine
AdsIsIndexNullable
Advantage Client Engine
AdsIsIndexPrimaryKey
Advantage Client Engine
AdsIsIndexUnique
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsNull
Advantage Client Engine
AdsIsRecordDeleted
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsRecordEncrypted
Advantage Client Engine
Advantage TDataSet Descendant
general en
AdsIsRecordInAOF
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsRecordLocked
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsRecordVisible
Advantage Client Engine
AdsIsServerLoaded
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsTableEncrypted
Advantage Client Engine
Advantage TDataSet Descendant
general encryption information
AdsIsTableLocked
Advantage Client Engine
Advantage TDataSet Descendant
AdsIsTableTransactionFree
AdslinuxXX.intrn.tar.gz
ADSLOC32.DLL
Advantage ODBC Driver installation information
benefits of selecting the Advantage Local Server
Server Type: Advantage Local Server
adslocal.cfg
Advantage Local Server configuration
avoiding ANSI collation mismatch errors
benefits of selecting the Advantage Local Server
AdsLocate
Advantage Client Engine
Advantage TDataSet Descendant
AdsLockRecord
Advantage Client Engine
Advantage TDataSet Descendant
explicit and implicit record locking with the Advantage Client Engine
AdsLockTable
Advantage Client Engine
Advantage TDataSet Descendant
AdsLockType
Advantage TDataSet Descendant
AdsLookupKey
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgConnect
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgDisconnect
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetActivityInfo
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetCommStats
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetConfigInfo
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetInstallInfo
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetLockOwner
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetLocks
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetOpenIndexes
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetOpenTables
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetServerType
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetUserNames
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgGetWorkerThreadActivity
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgKillUser
Advantage Client Engine
Advantage TDataSet Descendant
AdsMgResetCommStats
Advantage Client Engine
Advantage TDataSet Descendant
AdsNullTerminateStrings
Advantage Client Engine
AdsNumericsAsFloats
Advantage TDataSet Descendant
AdsObjectType
Advantage .NET Data Provider
ADSODBC.DLL
AdsOpenIndex
Advantage Client Engine
Advantage TDataSet Descendant
AdsOpenTable
Advantage Client Engine
database security
AdsOpenTable90
Advantage Client Engine
AdsOptimizedFilters
Advantage TDataSet Descendant
AdsOptimizedFilters subproperty
set
AdsPackTable
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsParameter
Advantage .NET Data Provider
AdsParameter Constructor
Advantage .NET Data Provider
AdsParameter Constructor int object
Advantage .NET Data Provider
AdsParameter Constructor string DbType
Advantage .NET Data Provider
AdsParameter Constructor string DbType int
Advantage .NET Data Provider
AdsParameter Constructor string DbType int ParameterDirection Boolean Byte Byte string DataRowVersion object
Advantage .NET Data Provider
AdsParameter Constructor string DbType int string
Advantage .NET Data Provider
AdsParameter Constructor string DbType string DataRowVersion
Advantage .NET Data Provider
AdsParameter Constructor string object
Advantage .NET Data Provider
AdsParameter Constructors
Advantage .NET Data Provider
AdsParameter Properties
Advantage .NET Data Provider
AdsParameter.DbType
Advantage .NET Data Provider
AdsParameter.Direction
Advantage .NET Data Provider
AdsParameter.Index
Advantage .NET Data Provider
AdsParameter.IsNull
Advantage .NET Data Provider
AdsParameter.IsNullable
Advantage .NET Data Provider
AdsParameter.ParameterName
Advantage .NET Data Provider
AdsParameter.Precision
Advantage .NET Data Provider
AdsParameter.Scale
Advantage .NET Data Provider
AdsParameter.Size
Advantage .NET Data Provider
AdsParameter.SourceColumn
Advantage .NET Data Provider
AdsParameter.SourceVersion
Advantage .NET Data Provider
AdsParameter.Value
Advantage .NET Data Provider
AdsParameterCollection
Advantage .NET Data Provider
AdsParameterCollection Methods
Advantage .NET Data Provider
AdsParameterCollection Properties
Advantage .NET Data Provider
AdsParameterCollection.Add AdsParameter
Advantage .NET Data Provider
AdsParameterCollection.Add int object
Advantage .NET Data Provider
AdsParameterCollection.Add object
Advantage .NET Data Provider
AdsParameterCollection.Add string DbType
Advantage .NET Data Provider
AdsParameterCollection.Add string DbType int string
Advantage .NET Data Provider
AdsParameterCollection.Add string object
Advantage .NET Data Provider
AdsParameterCollection.Clear
Advantage .NET Data Provider
AdsParameterCollection.Contains
Advantage .NET Data Provider
AdsParameterCollection.Count
Advantage .NET Data Provider
AdsParameterCollection.IndexOf
Advantage .NET Data Provider
AdsParameterCollection.Item int
Advantage .NET Data Provider
AdsParameterCollection.Item string
Advantage .NET Data Provider
AdsParameterCollection.RemoveAt int
Advantage .NET Data Provider
AdsParameterCollection.RemoveAt string
Advantage .NET Data Provider
AdsPrepareSQL
Advantage Client Engine
processing heuristics
AdsPrepareSQLW
AdsPreserveSpaces
AdsTableOptions
Advantage TDataSetDescendant
ADSPROP_INIT
in Advantage OLE DB Provider
ADSPROP_INIT_ENCRYPTION_PASSWORD
ADSPROP_INIT_SECURITY_MODE
database security
ADSPROP_INIT_SERVER_TYPE
in ads.ini file
AdsRecallAllRecords
Advantage Client Engine
AdsRecallRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsRecordCache
Advantage TDataSet Descendant
AdsRecordLockingMode
Advantage TDataSet Descendant
AdsRefreshAOF
Advantage Client Engine
Advantage TDataSet Descendant
AdsRefreshRecord
Advantage Client Engine
Advantage TDataSet Descendant
read-ahead record caching
AdsRegisterCallbackFunction
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsRegisterProgressCallback
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsRegisterSQLAbortFunc
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsReindex
Advantage Client Engine
Advantage TDataSet Descendant
AdsReindex61
Advantage Client Engine
AdsReindexFTS
Advantage Client Engine
AdsResetConnection
Advantage Client Engine
AdsRestructureTable
Advantage Client Engine
AdsRestructureTable90
Advantage Client Engine
AdsRightsCheck
Advantage TDataSet Descendant
AdsRollbackTransaction
Advantage Client Engine
AdsRollbackTransaction80
Advantage Client Engine
AdsScopeOptions
Advantage TDataSet Descendant
AdsSeek
Advantage Client Engine
Advantage TDataSet Descendant
AdsSeekLast
Advantage Client Engine
Advantage TDataSet Descendant
ADSSEM
Semaphore Connection File Path configuration parameter
AdsServerTypes
TAdsConnection
TAdsDictionary
TAdsSettings
AdsSetAOF
Advantage Client Engine
Advantage TDataSet Descendant
AOF performance tips
calling
AdsSetAOFW
AdsSetBinary
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetCollation
Advantage Client Engine
AdsSetCollationLang
AdsSetDate
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetDateFormat
Advantage Client Engine
SQL literals
AdsSetDateFormat60
Advantage Client Engine
AdsSetDecimals
Advantage Client Engine
AdsSetDefault
Advantage Client Engine
AdsSetDouble
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetEmpty
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetEpoch
Advantage Client Engine
AdsSetExact
Advantage Client Engine
Advantage Expression Engine operators
AdsSetExact22
Advantage Client Engine
AdsSetField
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetFieldW
AdsSetFilter
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetFilter100
AdsSetHandleLong
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetIndexByOrder
Advantage TDataSet Descendant
AdsSetIndexDirection
AdsSetJulian
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetLogical
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetLong
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetLongLong
Advantage Client Engine
AdsSetMilliseconds
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetMoney
Advantage Client Engine
AdsSetNull
Advantage Client Engine
AdsSetRecord
Advantage Client Engine
AdsSetRelation
Advantage Client Engine
AdsSetRelKeyPos
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetRightsChecking
AdsSetScope
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetScopedRelation
Advantage Client Engine
AdsSetSearchPath
Advantage Client Engine
AdsSetServerType
Advantage Client Engine
selecting server types via the ads.ini file
AdsSetShort
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetSQLTimeout
AdsSetString
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetStringW
AdsSetTableTransactionFree
AdsSetTime
Advantage Client Engine
Advantage TDataSet Descendant
AdsSetTimeStamp
Advantage Client Engine
AdsShowDeleted
Advantage Client Engine
AOF performance tips
AdsShowError
Advantage Client Engine
Advantage TDataSet Descendant
AdsSkip
Advantage Client Engine
Advantage TDataSet Descendant
callback functionality
AdsSkipUnique
AdsStamp Utility
adsstamp.exe
ADSStatement Object Additional Methods in JDBC
AdsStmtClearTablePasswords
Advantage Client Engine
Advantage TDataSet Descendant
AdsStmtConstrainUpdates
Advantage Client Engine
AdsStmtDisableEncryption
Advantage Client Engine
Advantage TDataSet Descendant
AdsStmtEnableEncryption
Advantage Client Engine
Advantage TDataSet Descendant
encryption with the Advantage TDataSet Descendant
AdsStmtReadAllColumns
Advantage Client Engine
AdsStmtSetTableCharType
Advantage Client Engine
AdsStmtSetTableCollation
Advantage Client Engine
AdsStmtSetTableLockType
Advantage Client Engine
AdsStmtSetTablePassword
Advantage Client Engine
Advantage TDataSet Descendant
AdsStmtSetTableReadOnly
Advantage Client Engine
AdsStmtSetTableRights
Advantage Client Engine
AdsStmtSetTableType
Advantage Client Engine
ADSSYS
accessing an Advantage Data Dictionary with the TDataSet Descendant
Advantage Data Dictionary user permissions
ALTER TABLE SQL statement
CREATE INDEX SQL statement
CREATE PROCEDURE SQL statement
CREATE TABLE SQL statement
DROP INDEX SQL statement
DROP PROCEDURE SQL statement
DROP TABLE SQL statement
AdsTableOptions
AdsPerserveSpaces
Advantage TDataSet Descendant
properties
AdsTableOptions.AdsCachingOption
AdsTableOptions.AdsIndexPageSize
index page size information
AdsThreadExit
Advantage Client Engine
ADSTPS
AdsTransaction
Advantage .NET Data Provider
AdsTransaction Methods
Advantage .NET Data Provider
AdsTransaction Properties
Advantage .NET Data Provider
AdsTransaction.Commit
Advantage .NET Data Provider
AdsTransaction.Connection
Advantage .NET Data Provider
AdsTransaction.CreateSavepoint
Advantage .NET Data Provider
AdsTransaction.IsolationLevel
Advantage .NET Data Provider
AdsTransaction.Rollback
Advantage .NET Data Provider
AdsUnlockRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsUnlockTable
Advantage Client Engine
Advantage TDataSet Descendant
ADSVER.EXE
AdsVerifyPassword
Advantage Client Engine
AdsVerifySQL
Advantage Client Engine
AdsVerifySQLW
AdsWriteAllRecords
Advantage Client Engine
AdsWriteRecord
Advantage Client Engine
Advantage TDataSet Descendant
AdsZapTable
Advantage Client Engine
Advantage TDataSet Descendant
ADT
Advantage file formats overview
Advantage Proprietary file format specifications
creating new ADT tables using Advantage Data Architect
deleted records
field types and specifications
file format for importing in Advantage Data Architect
more suited for future enhancements
null field values
overview
performance information
ADT Deleted Records
Advanced Functions in Advantage CA-Visual Objects RDD
Advanced Visual Studio 2005 Integration
Advantage
Advantage .NET Data Provider
AdsConnection.EnlistTransaction
AdsExtendedReader.AdsActiveHandle
AdsExtendedReader.BOF
AdsExtendedReader.EOF
AdsExtendedReader.GotoBOF
AdsExtendedReader.IndexCondition
AdsExtendedReader.IndexExpression
AdsExtendedReader.IsIndexCompound
AdsExtendedReader.IsIndexCustom
AdsExtendedReader.IsIndexDescending
AdsExtendedReader.IsIndexPrimaryKey
AdsExtendedReader.IsIndexUnique
AdsTransaction.CreateSavepoint
class summary
code portability
connection pooling
data types
distributing
installing
multi-threading
name space
product overview
quick start
referencing
registering
system requirements
Advantage 15xx Error Codes
Advantage 16-bit Windows
number of connections
Advantage 1xxx Error Codes
Advantage 2xxx Error Codes
Advantage 30xx Error Codes
Advantage 31xx Error Codes
Advantage 32-bit Windows
number of connections
Advantage 32xx Error Codes
Advantage 33xx Error Codes
Advantage 34xx Error Codes
Advantage 35xx Error Codes
Advantage 4xxx Error Codes
Advantage 5xxx Error Codes
Advantage 6.0
Advantage 6.11
Advantage 6.2
Advantage 60xx Error Codes
Advantage 61xx Error Codes
Advantage 62xx Error Codes
Advantage 63xx Error Codes
Advantage 64xx Error Codes
Advantage 66xx Error Codes
Advantage 67xx Error Codes
Advantage 68xx Error Codes
Advantage 7xxx Error Codes
Advantage 8xxx Error Codes
Advantage 9xxx Error Codes
Advantage ADT
null field values
proprietary locking
Advantage ADT Files
null field values
Advantage AEF files
for Advantage CA-Visual Objects RDD
Advantage AEPs
Advantage Extended Procedures tips and tricks
creating an Advantage Extended Procedure
overview
Advantage ANSI Collation Utility
Advantage Assert Log File
in Windows
Advantage Assertion Failure Log file
Advantage BINARY
Advantage CA-Clipper RDD
ads.ini file support
Advantage file formats overview
index files -- CDX: IDX: NTX
memo files -- DBT: FPT
Advantage CA-Visual Objects RDD
advanced functions
Advantage RDDs
application development notes
AX_AXSLocking
AX_BLOB2File
AX_File2BLOB
AX_GetAceIndexHandle
AX_GetAceTableHandle
AX_IsServerLoaded
AX_PercentIndexed
AX_RightsCheck
AX_SetConnectionHandle
AX_SetPassword
AX_SetServerType
AX_Transaction
AX_UsingClientServer
BLOB functions
CLASS AxDBServer
connecting to an Advantage Data Dictionary
creating applications
DB server editor
error object
file requirements
installing optional AEF files
product overview
run time problems
specifying the Advantage RDD
transaction processing
using the Advantage Local Server
with Advantage SQL Engine
writing code
Advantage CDX
Advantage Client Communication Layer
Advantage client DLL
Advantage Client Engine
API TPS examples
architecture
automatic version checking
callback functionality
distributing applications
example code
explicit and implicit record locking with the Advantage Client Engine
file requirements
how to use with the Advantage TDataSet Descendant
integrating into your application
transaction processing APIs
when to make direct calls from the Advantage TDataSet Descendant
Advantage Client Engine API
Advantage Client Engine DLLs
automatic version checking
Advantage Client Installs
avoiding ANSI collation mismatch errors
Advantage Client Kits
product overview
Advantage client setting
Max Timeouts
Advantage Client/Server
benefits of selecting the Advantage Local Server
database stability
Seek movement operation
Advantage communication
ads.ini file support
IP Port number
issues with ADS and Windows
registry settings that affect communication
Advantage Communication Transport Layer
Advantage Communications Troubleshooting
Advantage Compatibility Locking
open files
with ADT files
with Xbase files
Advantage Components for Delphi
Advantage Configuration
command line parameters
communication issues with ADS and Windows
error and diagnostic logs
ignore rights
setting the Internet port configuration parameter
startup parameters for Windows
utility for Windows
Advantage Configuration Utility
Advantage Configuration Utility for Windows
Advantage connection
creating an Advantage Extended Procedure
Number of Connections configuration parameter
Advantage Crystal Reports Driver
overview
providing an external Advantage connection handle
Advantage daemon
Advantage Data Architect
adding existing tables to the database
adding tables to the ER view
adding/removing users to/from groups
Advantage Environment Check utility
Advantage Management Utility
ARC32.EXE
changing passwords
changing the refresh rate
creating dictionary links
creating new tables
creating or modifying a package
creating or modifying a user defined function
creating or modifying databases
creating or modifying groups
creating or modifying RI objects
creating or modifying stored procedures
creating or modifying triggers
creating or modifying users
creating or modifying views
creating referential integrity objects with the ER Diagramming Tool
creating/dropping views
database aliases
deleting a package
deleting a user defined function
deleting databases
deleting groups
deleting referential integrity objects in Advantage Data Architect
deleting stored procedures
deleting triggers
deleting users
deleting views
developing databases using the ER Diagramming Tool
enabling Internet access on a per user basis
ER diagram printing
exporting Advantage tables to code
exporting table data
importing data into Advantage tables
manually refreshing the current view
native SQL link manager
Native SQL Utility
opening databases
opening tables
overview
performing data conversion in Delphi applications
redistributing in Windows
refreshing active databases
removing referential integrity objects
removing tables from databases
schema templates
setting group permissions
setting user permissions
SQL Debugger
table browser
table commands
user defined functions
user rights overview
using tables from multiple data dictionaries
using with the Advantage TDataSet Descendant
viewing communication statistics in Advantage Data Architect
viewing configuration parameters affecting memory
viewing configuration paramters not affecting memory
viewing connected users
viewing database activity information
viewing installation information
viewing open files
with Advantage OLE DB Provider
Advantage Data Dictionary
accessing with the Advantage CA-Visual Objects RDD
accessing with the Advantage TDataSet Descendant
connecting with CA-Visual Objects
deployment
enabling Internet access on a per user basis
functions in the Advantage Client Engine
Internet security levels
overview
upgrades
upgrading
user permissions
Advantage Data Dictionary Functions
AdsDDCreateArticle
AdsDDCreatePublication
AdsDDCreateSubscription
AdsDDDeleteArticle
AdsDDDeletePublication
AdsDDDeleteSubscription
AdsDDGetArticleProperty
AdsDDGetPublicationProperty
AdsDDGetSubscriptionProperty
AdsDDSetArticleProperty
AdsDDSetPublicationProperty
AdsDDSetSubscriptionProperty
Advantage Data Types
Paradox table conversion
Advantage Database Server
benefits of selecting
client communication layer
client/server technology
communication issues with NetWare
communication issues with Windows
comparing performance to non-client/server solutions
discovery for Windows
general performance factors
installing
installing with Advantage OLE DB Provider
mailslot
NetWare support
networking protocols
overview
server type
system requirements
worker thread information
Advantage Database Server Discovery
for NetWare
for Windows
overview
using the ADS.INI file
Advantage Database Server Installs
Advantage Database Server Mailslot
Advantage Database Server NLM
command line parameters
installling the Advantage Database Server NLM for NetWare
Advantage Database Server NLM Screen
Advantage Database Server Processing
performance factors relative to non-client/server
troubleshooting in the NetWare environment
Advantage Database Server Serial Number ID Card
for NetWare
for Windows
Advantage Database Server Service
installing the Advantage Database Server Service for Windows
uninstalling
Windows 2000/2003
Windows NT 4.0
Advantage Database Server Service Startup
Advantage Database Server Versus Advantage Local Server
Advantage DB
starts
Advantage DBI Driver
Advantage DBS
stops
Advantage Developer Zone Web Site
address
technical support information
Advantage DLLs
Advantage DOS-based
Advantage Encryption
Advantage Encryption Functions
Advantage Client Engine
Advantage Environment Check Utility
in Advantage Data Architect
use
Advantage Error Guide
Advantage Error Log and Replication
Advantage Error Log file
Advantage Expression Engine
examples
operators
overview and function list
performance
Advantage Extended Methods
Advantage TDataSet Descendant
how they work
Advantage Extended Procedures
deleting in Advantage Data Architect
DONTs
executing
interface version comparison
maintain
overview
TDataSet Descendant tutorial
testing and debugging
tips and tricks
Visual Basic tutorial
Advantage Extended Procedures file
name
Advantage FAQs
Advantage File Formats
specifications
Xbase specifications
Advantage FPT
Advantage Help documentation
Advantage IMAGE
create
Advantage Import Utility
in Advantage Data Architect
Advantage Indexes
Advantage Internet Connector
Advantage Internet Server
discovery
Internet IP Address configuration parameter
overview
security levels
server type overview
setting up
specifying the location
system requirements
troubleshooting
Advantage Internet Server System Requirements
Advantage ISAM
Advantage ISAM File Types
Advantage JDBC Driver
Advantage JDBC Driver Directory Structure
Advantage Knowledge Base
accessing
Advantage Linux
changing the Advantage Linux configuration
configuration file
Advantage Local Server
benefits of selecting
Crystal Reports
limitations of selecting
server type
using with the Advantage RDDs
Advantage Local Server DLL
Windows
Advantage Local Server Merge Module for Developers
Advantage locking
Advantage Locking Mode
open files
Advantage Management API
examples in Advantage TDataSet Descendant
examples in the Advantage Client Engine
for NetWare and Windows
functions in the Advantage Client Engine
list of APIs in Advantage TDataSet Descendant
Advantage Management Utility
in Advantage Data Architect
Advantage NTX
Advantage ODBC Driver
accessing through the BDE
API conformance
character sets
installation on Windows
overview
special charateristics
using with Delphi
with SQL
Advantage OLE DB Provider
architect utility
bookmarks
Command object information
command parameters
command syntax
commands overview
Connection object information
creating rowsets with ICommand Execute
creating rowsets with IOpenRowsets
data source information properties
data source objects
Data Source properties
data type mapping in rowsets and parameters
data types overview
database security
distributing
errors overview
files
indexes
initialization properties
installing
installing the Advantage Database Server
preparing commands
provider-specific Connection properties
provider-specific data source information properties
provider-specific initialization properties
provider-specific initialization properties for ADO
provider-specific Recordset properties for ADO
provider-specific rowset properties
provider-specific session properties
read-ahead record caching
record caching
Recordset object
return codes
Rowset properties
rowsets overview
selecting server types via ServerType property
server types
Session properties
sessions overview
setting the date format
SQL literals
storage overview
supported Command object interfaces
supported Data Source object interfaces
supported Error object interfaces
supported Rowset object interfaces
supported rowsets restrictions
supported schema rowsets
supported Session object interfaces
supported Storage object interfaces
supported View object interfaces
supporting local transactions
system requirements
updating data in rowsets
View properties
views overview
with ADO
Advantage OLE DB Provider String
Advantage Optimized Filter Functions
Advantage Client Engine
Advantage Optimized Filters
comparison with traditional record filters
general performance factors
how indexes are used by the WHERE clause
methods in the Advantage TDataSet Descendant
optimization
overview
performance tips
processing heuristics
relational operators
setting to optimize performance with the Advantage TDataSet Descendant
Advantage Performance
factors relative to non-client/server solutions
Advantage PHP Extension
connecting clients through the Internet to Advantage
overview
system requirements
Advantage Product CD
Advantage Product Family
Advantage Proprietary
Advantage Proprietary File Format
additional field data types
Advantage file formats overview
index files (ADI)
memo files (ADM)
more suited for future enhancements
supported file formats
table (ADT)
Advantage Proprietary File Format Specifications
Advantage Proprietary Format
Advantage Proprietary Index
Advantage Proprietary Locking
open files
Advantage Query Builder
in Advantage Data Architect
Advantage queuing
multi-user performance
proprietary locking
Advantage RDDs
Advantage CA-Visual Objects RDD general protection faults
Advantage Read-Ahead Record Caching
defined
optimizing use
Advantage Rights Checking
Advantage Server Not Available
Advantage server type setting
Advantage Server Types
overview
programmatically selecting for OLE DB Provider
programmatically selecting in the Advantage TDataSet Descendant
selecting via the ADS.INI file
selecting via the ServerType property with OLE DB Provider
selecting via the TAdsConnection component
selecting via the TAdsSettings Component
TAdsConnection.AdsServerTypes
TAdsDictionary
TAdsSettings
Advantage Shared Objects
distributing
Advantage SQL
Advantage SQL Engine
comparison to BDE
cursor type overview
date/time functions list
indexes with expressions
math functions
miscellaneous scalar functions
overview
processing heuristics
SQL literals
statement limits
string functions list
supported data types in Advantage SQL
supported statements
using tables from multiple data dictionaries
using with CA-Visual Objects RDD
Advantage SQL Grammar
Advantage Tables
Code Generator
TPS limitations
Advantage Tables to Code Generator
in Advantage Data Architect
Advantage Tags in ODBC
Advantage TDataSet Descendant
ads.ini file support
architecture
C++Builder specific files installed
Delphi specific files installed
distributing applications
installation
installed files
overview
TAdsTable/TAdsQuery.AdsTableOptions.AdsRe
tutorial using Advantage Extended Procedures
uninstalling
Advantage TDataSet Descendent
automatic version checking
Advantage Tools
Advantage TPS
error conditions
integrating
introducing
limitations
overview
signals
Advantage TPS Behavioral Changes
Advantage TPS Error Conditions
Advantage Transaction Processing
explicit and implicit record locking with the Advantage Client Engine
overview
Advantage Transaction Processing System
Advantage Transaction Processing System Features
Advantage Transaction Processing System Limitations
Advantage Triggers Tutorial
Advantage Troubleshooting Tools
Advantage User
Advantage Web Assist
Advantage Windows clients
Advantage Windows communication
communication issues with ADS and Windows
Advantage Xbase file
Advantage file formats overview
Advantage-only
proprietary locking
Advantages of Constraints
AE_ALLOCATION_FAILED
AE_ALREADY_MEMBER_OF_GROUP
AE_AUTOOPEN_INDEX
AE_BINARY_FILE_ERROR
AE_CANNOT_DELETE_TEMP_INDEX
AE_CANNOT_OPEN_DATABASE_TABLE
AE_COLLATION_SEQUENCE_MISMATCH
AE_COLUMN_CANNOT_BE_NULL
AE_COLUMN_PERMISSION_DENIED
AE_COMM_MISMATCH
AE_CONCURRENT_PROBLEM
AE_CONSTRAINT_VALIDATION_ERROR
AE_CORRUPT_INDEX
AE_CORRUPT_TABLE
AE_CURSOR_NOT_CLOSED
AE_CYCLIC_RELATION
AE_DATA_TOO_LONG
AE_DATA_TRUNCATED
AE_DATABASE_REQUIRES_NEW_CLIENT
AE_DATABASE_REQUIRES_NEW_SERVER
AE_DD_REQUEST_NOT_COMPLETED
AE_DD_UNSUPPORTED_DEPLOYMENT
AE_DICTIONARY_ALREADY_EXISTS
AE_DUPLICATE_ALIAS
AE_ENCRYPTION_NOT_ENABLED
AE_FILE_NOT_FOUND
receive
AE_FILE_NOT_ON_SERVER
AE_ILLEGAL_COMMAND_DURING_TRANS
AE_ILLEGAL_USER_OPERATION
AE_INDEX_ALREADY_OPEN
AE_INDEX_COLLATION_MISMATCH
AE_INDEX_EXISTS
AE_INDEX_EXPR_NOT_FOUND
AE_INDEX_SHARED
AE_INDEX_UDF_NOT_SET
AE_INF_FILE_ERROR
AE_INFO_AUTO_CREATION_OCCURRED
AE_INFO_COPY_MADE_BY_CLIENT
AE_INSUFFICIENT_BUFFER
AE_INVALID_BINARY_OFFSET
AE_INVALID_BOOKMARK
AE_INVALID_CALLBACK
AE_INVALID_CENTURY
AE_INVALID_CHARSETTYPE
AE_INVALID_COLUMN_NAME
AE_INVALID_COLUMN_NUMBER
AE_INVALID_CONNECTION_HANDLE
AE_INVALID_CONSTRAIN_TYPE
AE_INVALID_CONSTRAINT
AE_INVALID_CONTINUE
AE_INVALID_CURSORHANDLE
AE_INVALID_DATA_TYPE
AE_INVALID_DATE
AE_INVALID_DATEFORMAT
AE_INVALID_DAY
AE_INVALID_DECIMALS
AE_INVALID_DELETED_BYTE_VALUE
AE_INVALID_DICTIONARY_FILE
AE_INVALID_DICTIONARY_HANDLE
AE_INVALID_ENCRYPTION_VERSION
AE_INVALID_EXPRESSION
AE_INVALID_FIELD_TYPE
AE_INVALID_FIELDDEF
AE_INVALID_FIELDNAME
AE_INVALID_FIELDNUMBER
AE_INVALID_FILTER_OPTION
AE_INVALID_FIND_HANDLE
AE_INVALID_HANDLE
AE_INVALID_IMAGE
AE_INVALID_INDEX_HANDLE
AE_INVALID_INDEX_NAME
AE_INVALID_INDEX_ORDER
AE_INVALID_INDEX_ORDER_NAME
AE_INVALID_INDEX_TYPE
AE_INVALID_KEY_LENGTH
AE_INVALID_KEY_OPTIONS
AE_INVALID_LINK_NUMBER
AE_INVALID_LOCKTYPE
AE_INVALID_MEMO_BLOCK_SIZE
AE_INVALID_MONTH
AE_INVALID_OBJECT_ID
AE_INVALID_OBJECT_NAME
AE_INVALID_OBJECT_RIGHT
AE_INVALID_OBJECT_TYPE
AE_INVALID_OEM_CHAR_FILE
AE_INVALID_OPTION
AE_INVALID_PASSWORD
AE_INVALID_PATH
AE_INVALID_POINTER
AE_INVALID_PROPERTY
AE_INVALID_PROPERTY_ID
AE_INVALID_PROPERTY_LENGTH
AE_INVALID_READONLY_OPTION
AE_INVALID_RECORD_LENGTH
AE_INVALID_RECORD_NUMBER
AE_INVALID_RELATION
AE_INVALID_RIGHTSOPTION
AE_INVALID_SQL_PARAM_NAME
AE_INVALID_SQL_PARAM_NUMBER
AE_INVALID_SQLCURSOR_HANDLE
AE_INVALID_SQLSTATEMENT_HANDLE
AE_INVALID_STATEMENT
AE_INVALID_TABLE_HANDLE
AE_INVALID_TABLETYPE
AE_INVALID_USERNAME
AE_INVALID_VALUE
AE_INVALID_WORKAREA
AE_IS_CURSOR_HANDLE
AE_LINK_ACTIVATION_FAILED
AE_LOCAL_CONN_DISABLED
AE_LOCK_FAILED
explicit and implicit record locking with the Advantage Client Engine
AE_MAX_CONSTRAINT_VIOLATION
AE_MAX_THREADS_EXCEEDED
AE_MIN_CONSTRAINT_VIOLATION
AE_NAME_TOO_LONG
AE_NO_CONNECTION
AE_NO_CURRENT_RECORD
AE_NO_DRIVE_CONNECTION
AE_NO_ERROR_MESSAGE
AE_NO_FILE_FOUND
AE_NO_FILTER
AE_NO_INF_LOCK
AE_NO_OBJECT_FOUND
AE_NO_PENDING_UPDATE
AE_NO_PRIMARY_KEY_EXISTS
AE_NO_SCOPE
AE_NO_STORED_PROC_EXEC_RIGHTS
AE_NO_TABLE
AE_NO_TABLE_ENCRYPTION_PASSWORD
AE_NO_WORKAREA
AE_NOT_ADMINISTRATOR
AE_NOT_DML
AE_NOT_FOUND
AE_NOT_IMPLEMENTED
AE_NOT_MEMBER_OF_GROUP
AE_NOT_PREPARED
AE_OBSOLETE_FUNCTION
AE_OUTDATED_CLIENT_VERSION
AE_PENDING_UPDATE
AE_PERMISSION_DENIED
AE_PRECISION_LOST
AE_PROPERTY_NOT_SET
AE_RECORD_CONSTRAINT_VIOLATION
AE_RECORD_ENCRYPTED
AE_RECORD_NOT_LOCKED
AE_RESTRUCTURE_FAILED
AE_RI_CASCADE
AE_RI_CORRUPTED
AE_RI_FAILED
AE_RI_RESTRICT
AE_RI_RULE_EXISTS
AE_RI_UNDO_FAILED
AE_SAME_TABLE
AE_SERVER_MISMATCH
AE_START_THREAD_FAIL
AE_STORED_PROCEDURE_FAILED
AE_STRING_NOT_FOUND
AE_SUCCESS
connecting clients through the Internet to Advantage
AE_TABLE_CACHED
AE_TABLE_CLOSED_IN_TRANSACTION
AE_TABLE_ENCRYPTED
AE_TABLE_NOT_ENCRYPTED
AE_TABLE_NOT_EXCLUSIVE
AE_TABLE_NOT_LOCKED
AE_TABLE_NOT_SHARED
AE_TABLE_READONLY
AE_TADSDATASET_GENERAL
AE_TOO_MANY_INDEXES
AE_TOO_MANY_TAGS
AE_TRANS_OUT_OF_SEQUENCE
AE_UDF_OVERWROTE_BUFFER
AE_UNKNOWN_CHAR_SET
AE_UNKNOWN_ERRCODE
AE_UNRECOGNIZED_ENCRYPTION
AE_UNRECOGNIZED_FTS_VERSION
AE_UNRECOGNIZED_VERSION
AE_UNSUPPORTED_LANGUAGE
AE_VALUE_OVERFLOW
AEF files
for Advantage CA-Visual Objects RDD
AEP Interface Version Comparison
AEP Notes
AEP-library
AEPs
COM dll containing
creating
detailed description
executing
interface version comparison
overview
TDataSet Descendant tutorial
testing and debugging
tips and tricks
Visual Basic tutorial
Affect Advantage Comm
Affect Advantage Communication
registry settings that affect communication
AFTER triggers
AfterCommit
Advantage TDataSet Descendant
AfterConnect
Advantage TDataSet Descendant
AfterDisconnect
Advantage TDataSet Descendant
AfterRollback
Advantage TDataSet Descendant
Aggregate Column Functions
Aggterm
aicu.dll
aicu.so
AIS
overview
AIS.INI
Alias Operators
Aliased
using tables from multiple data dictionaries
Aliases
in Advantage Data Architect
server-side
AliasName
TAdsConnection.AliasName
TAdsDictionary.AliasName
AliasName.FieldName
ALL
reserved keyword in Advantage SQL engine
ALLTRIM()
expression engine function
ALS
ALTER
ALTER an existing table
ALTER COLUMN
ALTER FUNCTION
ALTER PROCEDURE
ALTER TABLE
ALTER TRIGGER
Alternatives to Constraints
Am/pm
American
AND
Annual Service Contract
ANSI
avoiding ANSI collation mismatch errors
ANSI Character Set
installing the Advantage Database Server for Linux
ANSI Character Sets with ODBC
ANSI Collation Mismatch Errors
ANSI Language Support
ANSI yyyy-mm-dd
ANSI.CHR
ANSI_CHAR_SET
Advantage Local Server configuration
AOF Optimization
AOF Relational Operators
AOF uses
AOFs
comparison with traditional record filters
general performance factors
how indexes are used by the WHERE clause
optimization
overview
performance tips
processing heuristics
relational operators
API Conformance
ODBC driver
API Conventions
Advantage Client Engine
API Special Characteristics
in ODBC
Append
Advantage TDataSet Descendant
AppendRecord
Advantage .NET Data Provider
Application Development
building multi-threaded applications with TAdsQuery and TAdsTable
converting existing applications to use the Advantage TDataSet Descendant
developing a sample Advantage-enabled Delphi application
distributing Advantage Client Engine-enabled applications
distributing Advantage TDataSet Descendant applications
integrating the Advantage Client Engine
notes about using Advantage CA-Visual Objects RDD
specifying an Advantage RDD for Advantage CA-Visual Objects RDD
using Advantage CA-Visual Objects RDD
ApplicationID
Apply
Approximate Numeric
vs exact numeric
ARC
ARC32.EXE
creating/dropping views
overview
with Advantage Extended Procedures
ARC32.EXE
overview
troubleshooting tool
Arccosine
Returns
Architecture
Advantage Client Engine
Advantage TDataSet Descendant
Delphi
Arcsine
Returns
Arctangent
Returns
ASC
reserved keyword in Advantage SQL engine
ASC/DESC key
ASCENDING/DESCENDING key
ASCII
ASIN
SQL math function
ASSERT
Assert Log Path
Advantage
ASSERT.LOG
Assertion Failure
Assertion Failure Log
Assignment
AT()
example code
expression engine function
indexes with expressions in SQL
ATAN
SQL math function
ATAN2
SQL math function
Authentication
general information
Internet security levels
Auto Increment
Auto-Creation
autoinc
LASTAUTOINC scalar function
AutoIncrement
ADT field type
Automatic
Advantate Transaction Processing Features
disable failed transaction recovery
version checking in Advantage Client Engine DLLs
Automatic Transactions
Automatic Version Checking
Automatically Reused
Auto-Open
Auto-Open (Structural) Index Files
Auto-Open ADI
Auto-Open Indexes
in ODBC
Auto-Sense Protocol
Auto-Updating Fields
replication
Available Server Types
Available Transactions
AverageFieldNameLength
Advantage Proprietary file format specifications
AVG
AX_AXSLocking in Advantage CA-Visual Objects RDD
AX_BLOB2File in Advantage CA-Visual Objects RDD
AX_File2BLOB Advantage CA-Visual Objects RDD
AX_GetAceIndexHandle in Advantage CA-Visual Objects RDD
AX_GetAceStmtHandle
AX_GetAceTableHandle and AX_GetAceIndexHandle
AX_GetAceTableHandle in Advantage CA-Visual Objects RDD
AX_IsServerLoaded in Advantage CA-Visual Objects RDD
AX_PercentIndexed in Advantage CA-Visual Objects RDD
AX_RightsCheck
database security
AX_RightsCheck in Advantage CA-Visual Objects RDD
AX_SetCollation
AX_SetConnectionHandle
connecting clients through the Internet to Advantage
AX_SetConnectionHandle in Advantage CA-Visual Objects RDD
AX_SetExactKeyPos
AX_SetPassword
AX_SetPassword in Advantage CA-Visual Objects RDD
AX_SetServerType
AX_SetServerType in Advantage CA-Visual Objects RDD
AX_SetSQLTablePasswords
AX_SetSQLTimeout
AX_Transaction in Advantage CA-Visual Objects RDD
AX_UsingClientServer in Advantage CA-Visual Objects RDD
AXCWS32.DLL
AXDBFCDX
AxDBServer in Advantage CA-Visual Objects RDD
AXS_TPS
AXS_TPS field
use of deleted byte in DBF tables
AXSQL Refresh Functionality
AXSQL Requirements
AXSQLNTX and Index Optimization
- B -
BACK
Backup
adsbackup utility
differential backups
Backup and Restore Canned Procedure Result Sets
Backup and Restore Canned Procedures
Backup and Restore Options
Backup Functionality
Backup Result Table
Basic Replication Strategies
BatchMove
BDE
how the Advantage SQL engine differs from the BDE
BEFORE
query
BEFORE triggers
BeforeCommit
Advantage TDataSet Descendant
BeforeConnect
Advantage TDataSet Descendant
BeforeDisconnect
Advantage TDataSet Descendant
BeforeRollback
Advantage TDataSet Descendant
begin
BEGIN TRANSACTION
BeginTransaction
Advantage .NET Data Provider
Advantage TDataSet Descendant
BeginTransaction IsolationLevel
Advantage .NET Data Provider
BETWEEN
Advantage SQL grammar
reserved keyword in Advantage SQL engine
Bi-Directional Replication
Bin/bash
Bin/sh
binary
ADT field type
DBF field type
Binary Indexes
Binary Large OBject
Binary/image/BLOB
Advantage Proprietary file format specifications
Bindery/directory
file server
Binding Tables
BIT_LENGTH
Bitmap
Bitwise
bitwise operators
BitWiseAnd
BitWiseNot
BitWiseOr
BitWiseXor
BLOB
BLOB Functions
in Advantage CA-Visual Objects RDD
BNF
Book
Book s Errata Web Page
Bookmark
Advantage TDataSet Descendant
index scope/range
movement operation
Bookmarks
in Advantage OLE DB Provider
Boolean
Boolean_expression
Borland
Read
Borland C++Builder
creating an Advantage Extended Procedure
Borland Database Engine
Borland Delphi Integration
integrating the Advantage Client Engine
Borland Kylix
Bottom
index scope/range
new block
using index scopes vs. record filters
Breaking
debug session
Breakpoints
Select
Setting
Browser Creation
Building an Installation Program
with Advantage OLE DB Provider
Building Database Applications
BY
reserved keyword in Advantage SQL engine
- C -
C
C++Builder
exporting Advantage tables to code in Advantage Data Architect
system requirements
C++Builder Specific Files Installed
CACHE
CachedUpdates
differences between the BDE and the Advantage TDataSet Descendant
Caching
Caching Script Semantics
CA-Clipper
Advantage
index files -- CDX: IDX: NTX
memo files -- DBT: FPT
Call Stack
inspecting
CallableStatement Object in JDBC
Calling a Stored Procedure
Calling a User Defined Function
Cancel
AdsExtendedReader
Advantage .NET Data Provider
Cancelled
Advantage .NET Data Provider
CancelOnRollback
Candidate Indexes
CASCADE
CASE
Case Insensitive Field Type
CASE searched_when_clauses
Case Sensitivity
in Linux
insensitive field types
Case-independent
CaseInsensitive
Advantage TDataSet Descendant
CAST
SQL scalar function
Catalog Connection String Property in JDBC
CATCH
CA-Visual Objects
connecting clients through the Internet to Advantage
system requirements
CA-Visual Objects RDD
Advantage advanced functions
Advantage RDDs
application development notes
AX_AXSLocking
AX_BLOB2File
AX_File2BLOB
AX_GetAceIndexHandle
AX_GetAceTableHandle
AX_IsServerLoaded
AX_PercentIndexed
AX_RightsCheck
AX_SetConnectionHandle
AX_SetPassword
AX_SetServerType
AX_Transaction
AX_UsingClientServer
BLOB functions
CLASS AxDBServer
connecting to an Advantage Data Dictionary
creating applications
DB server editor
error object
file requirements
general protection faults
installing optional Advantage AEF files
product overview
run time problems
specifying the Advantage RDD
transaction processing
using the Advantage Local Server
with Advantage SQL Engine
writing code
CDX
Advantage file formats overview
applies
delete
Number of Index Files configuration parameter
CDX index
CDX Index Files
CDX Indexes
FoxPro behavior in ODBC
CEILING
SQL math function
ChangeDatabase
Advantage .NET Data Provider
Changing
passwords in Advantage Data Architect
TCrpe report alias at runtime
Changing a User Password
Changing a View
Changing AdsServer.Ini
Changing Data
Changing Keyboard Shortcuts
SQL debugger
Changing Objects
Changing the Default Window Layout
SQL debugger
CHAR
CHAR_FIELD
data type independent expression concatenation operator
CHAR_LENGTH
CHAR2HEX
Character
ADT field type
DBF field type
Character Sets in ODBC
Character String
SQL literal
Character Type
CHARACTER_LENGTH
Charfield
CharType
Advantage .NET Data Provider
in Advantage OLE DB Provider
CharType Connection String Property in JDBC
Check Rights
Check Rights security
Check Sum Failures
Checking User Rights
Chkconfig
CHR()
expression engine function
indexes with epressions in SQL
CICHAR
CICharacter
ADT field type
CLASS AxDBServer Advantage CA-Visual Objects RDD
Class Summary
Advantage .NET Data Provider
ClassID
CLASSPATH in JDBC
Clear
Advantage .NET Data Provider
Clearing
ClearRange
Advantage .NET Data Provider
Client Communication
Client connects
Client Development Platforms
Client Kits
product overview
Client Operating Systems
Client PCs
specifying the Advantage Internet Server location
Client Settings
Advantage communications compression
Client Timeout
configuration parameter
Internet Client Timeout configuration parameter
Keep alive
Client waits
Client/Server
Advantage Database Server overview
benefits of selecting the Advantage Local Server
database stability
multi-user performance
performance relative to non-client/server
technology
CLIENT_TIMEOUT
Clients
setting up using the ADS.INI file
Client-specific
Close
Advantage .NET Data Provider
Advantage TDataSet Descendant
OPEN, CLOSE, FETCH
CloseCachedTables
Advantage .NET Data Provider
Advantage TDataSet Descendant
CloseSQLStatement
Advantage TDataSet Descendant
Cluster
installing and running the Advantage Database Server on a Windows cluster
LAN IP Address configuration parameter
Use Clustering configuration parameter
Cluster Resource Object
Clustering support
installing and running the Advantage Database Server on a Windows cluster
LAN IP address configuration parameter
Use Clustering configuration parameter
COALESCE
SQL scalar function
Code
exporting Advantage tables to code in Advantage Data Architect
object-oriented and procedural for Advantage CA-Visual Objects RDD
Code Generator
Advantage Tables
Code Portability
Advantage .NET Data Provider
Code Samples
Coercion
COERCION_COMPATIBLE
COERCION_EXPLICIT
COERCION_IMPLICIT
COERCION_NECESSARY
COLLATE
expression engine function
Collation
Collation Mismatch Errors
avoiding
Collation Sequence
in ODBC
Collation Support
COLUMN
Column Permissions
using full text search
Column-identifier
COM
creating an Advanta
COM dlls
Command Line Parameters
Command Object
in Advantage OLE DB Provider
Command Parameters
in Advantage OLE DB Provider
Commands
in Advantage OLE DB Provider
preparing for optimized multiple execution in Advantage OLE DB Provider
supported object interfaces in Advantage OLE DB Provider
syntax in Advantage OLE DB Provider
tables in Advantage Data Architect
CommandText
Advantage .NET Data Provider
CommandTimeout
Advantage .NET Data Provider
CommandType
Advantage .NET Data Provider
Comments
Comments About Constraints
Comments in SQL Statements
Commit
Advantage .NET Data Provider
tables during
TAdsConnection.Commit
transaction processing system feature
Commit Phase
COMMIT WORK
CommitCount
Advantage TDataSet Descendant
Committed Isolation Level
Communication
Advantage Database Server discovery for Windows
Communication DLL
ads.ini file support
Communication Issues
Advantage Database Server for NetWare
Advantage Database Server for Windows
Communication Issues Specific
with NetWare
Communication Layer
ads.ini file support
registry settings that affect communication
Communication Library
in Advantage CA-Visual Objects RDD
Communication Statistics
viewing in Advantage Data Architect
Communication Transport Layer
Communications Compression
Communications Troubleshooting
CommunicationType
TAdsConnection.CommunicationType
CompareBookmarks
Advantage .NET Data Provider
Comparing Data Dictionaries
Comparison Operators and Coercion
case insensitive field types
Compatibility
Compatibility Locking
ADT files
locking modes general information
proprietary locking
with cursor types in Advantage SQL
Xbase files
Compatibility of Advantage JDBC Driver
Compression
Advantage .NET Data Provider
Advantage configuration parameter
communications compression overview
connection string parameter n Advantage OLE DB Provider
TAdsConnection.Compression
CONCAT
Concatenation Operator
data type independent expression
Concurrency
Advantage compatibility locking with Xbase files
Advantage Database Server overview
integrating TPS into Advantage applications
Concurrent User Configuration in Advantage Local Server
Conditional Expression Length
Conditional Indexes
ADI
description
Xbase
Conditional Selection
Condition-expression
CONFIG.NLM
CONFIG.SYS
CONFIG.TXT
configuration
for Windows
overview for Advantage Data Architect
Configuration File
avoiding ANSI collation mismatch errors
for Linux
for NetWare
Configuration Overview
Configuration Parameters
Client Timeout
Compression
configuration parameter settings list
CreateMask
Disable Failed Transaction Recovery
Disable Free Connections
Display NetWare Connection Names
Error and Assert Log Path
Error Log File Size
Express Queue
Flush Frequency
Help Screen
Index Sort Buffer Size
Internet IP Address
Internet Port
IP Port
LAN IP Address
Lowercase All Paths
MAX_CACHE_MEMORY
modifying during installation of the Advantage Database Server
Number of Connections
Number of Data Locks
Number of Index Files
Number of Tables
Number of Work Areas
Number of Worker Threads
Partial Connection Timeout
Permitted_Rep_Errors
Semaphore Connection File Path
SQL Sort Buffer Size
Suppress Message Boxes
Transaction Log Files Path
Use Clustering
Use Dynamic Cursors
Use Semaphore Files
Configuration Parameters Affecting Memory
configuration parameters screen
in Advantage Data Architect
Configuration Parameters Not Affecting Memory
configuration parameters screen
in Advantage Data Architect
Configuration Parameters Screen
Configuration Utility
Advantage Database Server Service for Windows
configuration parameters screen
using with the Advantage Database Server for Windows
Configuring Replication
Configuring Replication Errors
CONFLICT triggers
CONLOG.NLM
Connect
TAdsConnection.Connect
TAdsDictionary.Connect
Connect attempt
Connect button
Connected Users
viewing in Advantage Data Architect
Connecting Clients Through the Internet to Advantage
Connecting through the JDBC Driver Manager
Connecting to a database
in JDBC
Connecting to Advantage Using
Connecting to Advantage Using PHP
Connecting to Data
Connection
AdsCommand.Connection
AdsCommand.LastAutoinc
AdsTransaction.Connection
Connection Attempts
server
Connection files
Semaphore Connection File Path
Connection handle
Connection Handles
Advantage Client Engine
Connection ID
Connection Lifetime
Advantage .NET Data Provider
Connection methods
in Advantage OLE DB Provider
Connection names
Connection number
Connection Object
in Advantage OLE DB Provider
Connection Object in JDBC
Connection Pooling
Advantage .NET Data Provider
Connection Pooling Usage
replication
Connection Properties for ADO in Advantage OLE DB Provider
Connection String Parameters
in Advantage OLE DB Provider
Connection String Properties in JDBC
Connection Table Full
Advantage Local Server configuration
ConnectionHandle
Advantage .NET Data Provider
Advantage TDataSet Descendant
Connections
in Advantage OLE DB Provider
Connections Configuration in Advantage Local Server
ConnectionString
Advantage .NET Data Provider
ConnectionThreadID
Advantage TDataSet Descendant
ConnectionTimeout
Advantage .NET Data Provider
ConnectionType
Advantage TDataSet Descendant
ConnectPath
TAdsConnection.ConnectPath
TAdsDictionary.ConnectPath
CONSTRAINT
CONSTRAINT ERROR MESSAGE
Constraints
CONTAINS
Advantage .NET Data Provider
expression engine function
full text search overview
SQL scalar function
Content Search
column permissions
details list
example situations
for full text search indexes
index creation and temporary file size
index options
index updates
null handling
optimization
overview
quick start
record visibility
scalar functions
scoring
search conditions
using dynamic cursors
using with versions of Advantage prior to v7.0
CONTINUE
Control
Controlling Script Execution
SQL debugger
conversion
Conversions in ODBC
CONVERT
SQL scalar function
Convert Database Driver
Converting
Existing BDE Reports
Existing ODBC Reports
Converting Existing BDE Reports in Crystal 6 through 8
Converting Existing ODBC Reports in Crystal 6 through 8
Converting Report From BDE Driver
ConvertTable
Advantage .NET Data Provider
CopyTable
Advantage .NET Data Provider
CopyTableStructure
Advantage .NET Data Provider
COS
SQL math function
cost prediction
COT
SQL math function
COUNT
CPU Speed
CPU working
CPUs
CREATE
TAdsDictionary.Create
TAdsSettings.Create
using tables from multiple data dictionaries
create a new table
CREATE DATABASE
CREATE FUNCTION
CREATE INDEX
CREATE PACKAGE
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
using tables from multiple data dictionaries
CreateCommand
AdsFactory method
Advantage .NET Data Provider
CreateCommandBuilder
AdsFactory method
CreateConnection
AdsFactory method
CreateConnectionStringBuilder
AdsFactory method
CreateDataAdapter
AdsFactory method
CreateDDLink
TAdsConnection.CreateDDLink
TAdsDictionary.CreateDDLink
CreateDictionary
Advantage TDataSet Descendant
CreateFromHandle
CreateIndex
Advantage .NET Data Provider
CreateMask
Advantage configuration parameter
CreateParameter
AdsFactory method
Advantage .NET Data Provider
CreateRI
Advantage TDataSet Descendant
CreateRowUpdatedEvent
Advantage .NET Data Provider
CreateRowUpdatingEvent
Advantage .NET Data Provider
CreateSavepoint
TAdsConnection.CreateSavepoint
CreateTable
Advantage TDataSet Descendant
CreateTrigger
Advantage TDataSet Descendant
CreateUserGroup
Advantage TDataSet Descendant
CreateWithHandle
Advantage TDataSet Descendant
Creating
a dictionary link in Advantage Data Architect
database aliases in Advantage Data Architect
referential integrity objects with the ER Diagrammer in Advantage Data Architect
Rowsets with ICommand Execute in Advantage OLE DB Provider
Rowsets with IOpenRowsets in Advantage OLE DB Provider
Creating a Backup
Creating a Backup Using
Creating a Backup Using AdsBackup.exe
Creating a Data Dictionary
Creating a New Report in Crystal 6 and 7
Creating a New Report in Crystal 8
Creating a New Report in Crystal 9 and newer
Creating a Package
Creating a Table
Creating a User Defined Function
Creating ADS Tables
Creating AEPs Using C
Creating AEPs Using Delphi
Creating AEPs Using VB.NET
Creating AEPs Using Visual Basic
Creating Applications
using Advantage CA-Visual Objects RDD
Creating Constraints
Creating Dictionary Links
Creating Editable Views
Creating FTS Index Orders
Creating Indexes
Creating or Modifying
a package in Advantage Data Architect
databases in Advantage Data Architect
groups in Advantage Data Architect
referential integrity objects in Advantage Data Architect
stored procedures in Advantage Data Architect
triggers in Advantage Data Architect
user defined functions in Advantage Data Architect
users in Advantage Data Architect
views in Advantage Data Architect
Creating Stored Procedures
Creating Tables
Creating the Client Applications
Creating the Database
Creating the Publication
Creating the Sample Table
Creating the Subscription
Creating Triggers
Cross Join
Crystal Reports
changing a TCrpe report alias at runtime
character type
configuring at runtime
converting existing BDE reports in Crystal 6 through 8
converting existing ODBC reports in Crystal 6 through 8
creating a new report in Crystal 6 and 7
creating a new report in Crystal 8
creating a new report in Crystal 9 and newer
defining a database alias for use with
known issues
locking mode
overview
providing an external Advantage connection handle
report distribution
rights checking mode
server type
showing deleted DBF records
CTOD()
AOF optimization
expression engine function
CTOT()
expression engine function
CTOTS()
expression engine function
CURDATE
Advantage SQL date/time functions
Curdouble
ADT field type
CURR_DATE
CURRENT_DATE
Advantage SQL date/time functio
CURRENT_TIME
Advantage SQL date/time functions
CURRENT_TIMESTAMP
Advantage SQL date/time functions
CurrentDateTimeOffset
CurrentUtcDateTime
Cursor
OPEN, CLOSE, FETCH
Cursor Adapters
Cursor handles
overview
working with cursor handles in the Advantage Client Engine
Cursor Types
in Advantage for JDBC
overview
read-ahead record caching
CursorAdapter
Cursor-based
Cursors
how live and static cursors are processed
limitations with static cursors
live versus static
populating static cursors
support within Advantage OLE DB Provider
types of
CURTIME
Custom Indexes
Custom TDataSet Versions
CustomErrorObject in Advantage OLE DB Provider
Customizing a Publication
- D -
Daemon
Daemons
Data
Data Aware Controls Affects on Speed
Data Caching
Data Conversion Using Advantage Data Architect
Data Conversion Using the Advantage Data Architect
Data Dictionary
accessing with the Advantage TDataSet Descendant
associating indexes with tables
connecting with Advantage CA-Visual Objects
deployment
enabling internet access
Internet security levels
overview
referential integrity
setting up Advantage for the internet
upgrading
using tables from multiple data dictionaries
Data Dictionary Management
Data Dictionary Overview
Data Hiding
Data Locking and Transaction Processing
Data Locks
Advantage Local Server configuration
L Number
multi-user performance
NLM screen
Number
Number of Data Locks configuration parameter
Data Manipulation Functions
Advantage Client Engine
Data Security
Data Size Limitations in ODBC
Data Source
in Advantage OLE DB Provider
Data Source Entries
for Linux in ODBC
for Windows in ODBC
Data Source Information Properties
in Advantage OLE DB Provider
Data Source Keys
for the Advantage ODBC Driver
Data Source Properties
in the Advantage OLE DB Provider
Data Source Setup
for Linux in ODBC
for Windows in ODBC
Data Source Setup Screen for ODBC
Data Sources
overview for OLE DB Provider
supported object interfaces for Advantage OLE DB Provider
Data Type Independent Expression Concatenation Operator
overview
Data Type Mapping
Advantage ODBC Driver
Data Type Mapping in Rowsets and Parameters
in Advantage OLE DB Provider
Data Typeless Join Operator
Data Types
Advantage .NET Data Provider
Advantage file formats overview
data type independent expression concatenation operator
in Advantage JDBC Driver
in Advantage OLE DB Provider
in the Advantage SQL Engine
mapping in Advantage ODBC Driver
Mapping in Advantage OLE DB Provider
Paradox table conversion
Data Update Visibility
DataAdapter
Advantage .NET Data Provider
DATABASE
Advantage .NET Data Provider
SQL scalar function
Database Activity Information
viewing information fields in Advantage Data Architect
Database Administrator
Database Aliases
in Advantage Data Architect
Database Aliases and the ads.ini File
Advantage TDataSet Descendant
Database API Parameters
in ODBC
Database Base Roles
Database Connection
Database Directory in ODBC
Database Errors in JDBC
Database login
Database Object
debugging
Database Permissions
Advantage Data Dictionary
effective vs explicit
Database Roles
Database Security
Database Stability
overview
transaction processing
Database stability ensuring
Database Table
DatabaseMetaData Object in JDBC
DatabaseName
Advantage TDataSet Descendant
Databases
adding existing tables in Advantage Data Architect
creating or modifying in Advantage Data Architect
deleting in Advantage Data Architect
opening in Advantage Data Architect
refreshing active in Advantage Data Architect
removing tables from a database in Advantage Data Architect
Datagram communication
DataSetCount
Advantage TDataSet Descendant
DataSets
Advantage TDataSet Descendant
DataSnap
DataSource
Advantage .NET Data Provider
Data-typeless
Date
ADT field type
DBF field type
SQL literal
Date Format
setting in Advantage OLE DB Provider
Date Operators
DATE()
expression engine function
Date/Time
Date/Time Functions
DATE_FIELD
data type independent expression concatenation operator
DateFormat
Advantage .NET Data Provider
Advantage TDataSet Descendant
day name of a date value
day of week
day of year
DAY()
expression engine function
DAYNAME
DAYOFMONTH
Advantage SQL date/time functions
DAYOFWEEK
DAYOFYEAR
DB
Admin
Backup
Debug
Public
DB Server Editor
creating applications with Advantage libraries
using with Advantage CA-Visual Objects RDD
DBASE III
DBCConvert.prg
dbExpress
DBF
Advantage file formats overview
creating in Advantage Data Architect
field types and specifications
DBF Field Types and Specifications
DBF Formats
DBF index
DBFCDXAX in Advantage CA-Visual Objects RDD
DBFNTXAX Advantage CA-Visual Objects RDD
DbfsUseNulls
Advantage .NET Data Provider
in Advantage OLE DB Provider
DBI
DBI Driver
DBPROP_CANFETCHBACKWARDS
read-ahead record caching
DBPROP_CANSCROLLBACKWARDS
read-ahead record caching
DBPROPSET_ADSDBINIT
in Advantage OLE DB Provider
DBPROPSET_DBINIT
in Advantage OLE DB Provider
DBServer
DBServer class
for Advantage CA-Visual Objects RDD
DBShared
DBT
general Advantage performance factors
memo files -- DBT: FPT
DBT Memo Files
DbType
Advantage .NET Data Provider
DDVersionMajor
Advantage .NET Data Provider
Advantage TDataSet Descendant
DDVersionMinor
Advantage .NET Data Provider
Advantage TDataSet Descendant
DEBUG BEGIN
DEBUG BREAK
DEBUG BREAK POINT
DEBUG CONNECTION
DEBUG DATABASE
DEBUG END
DEBUG REMOVE BREAK POINT
DEBUG RUN
Debug Session
restarting
starting
stopping
DEBUG WAIT
DEBUG_BREAKS
DEBUG_CONNECTIONS
DEBUG_SOURCES
DEBUG_STACK
DEBUG_STATEMENTS
DEBUG_VARIABLES
Debugger
menu
SQL
Debugger Topics
Debugging
Debugging a Database Object
SQL debugger
Debugging a Script
SQL debugger
Debugging an External Application
SQL debugger
Debugging SQL Script
Debugging Stored Procedures
Debugging Triggers
DECLARE
Declaring Variables
Decrypt Tables
in Advantage Data Architect
DecryptTable
Advantage .NET Data Provider
DEFAULT default-column-value
Default Field Values
using with Advantage Data Dictionary
DEFAULT PROTOCOL
depending
DEFAULT VALUES
Default Window Layout
changing in debugger
DEFAULT_PROTOCOL
DefaultIndex
Define
Defining a Database Alias for use with Crystal Reports
Defining Constraints
Defining Field-Level Properties
Defining Indexes
Defining Referential Integrity Constraints
Defining Server-Side Aliases
Defining Table-Level Properties
Defining Triggers
Defining Users
DEGREES
SQL math function
DELETE
CDX
indexes and SQL performance
reserved keyword in Advantage SQL engine
SQL execution plan node
DELETE FROM
Delete Rules
DELETE Statements Using Indexes
DeleteCommand
Advantage .NET Data Provider
Deleted Byte
Deleted DBF Records
Showing
DELETED Record Indexes
Deleted Records
ADT
operation summary
Deleted Records in ODBC
overview
DELETED()
AOF performance tips
expression engine function
DeleteIndex
Advantage .NET Data Provider
DeleteRecord
Advantage .NET Data Provider
DeleteUserGroup
Deleting
groups in Advantage Data Architect
referential integrity objects in Advantage Data Architect
stored procedures in Advantage Data Architect
users in Advantage Data Architect
views in Advantage Data Architect
Deleting a Package
Deleting a User Defined Function
Deleting databases
in Advantage Data Architect
Deleting Records
Deleting Triggers
in Advantage Data Architect
Delphi
exporting Advantage tables to code in Advantage Data Architect
Delphi Applications
converting to use the Advantage TDataSet Descendant
developing a sample Advantage-enabled Delphi application
Delphi Components
Delphi Data Access Components
Delphi Data Control Components
Delphi Database Applications
Delphi for .NET
Delphi Functionality
Delphi Specific Files Installed
Denial
Service Attacks
Deploying
Advantage .NET Data Provider applications
Advantage CA-Visual Objects applications
Advantage Client Engine applications
Advantage ODBC applications
Advantage OLE DB Provider applications
Advantage shared objects
Advantage TDataSet Descendant applications
distributing an Advantage Client Engine enabled application
triggers
Deploying Stored Procedures
Deploying Triggers
Deployment
AOF performance tips
ease of distributing Advantage Local Server
installing the Advantage Database Server for Linux
Deployment Functionality
depth
Advantage .NET Data Provider
DeriveParameters
Advantage .NET Data Provider
DESC
DESC|ASC
DESCEND
expression engine function
DESCEND()
DescriptionsAvailable
Destroy
TAdsDictionary.Destroy
TAdsSettings.Destroy
Developer Zone Web Site
Developing and Distributing Applications
How the Advantage TDataSet Descendant is Built into your Application
Developing Databases Using the ER Diagramming Tool
Development
overview for Advantage Data Architect
DevZone.AdvantageDatabase.com
Diagnostic Logs
Dictionary Link
using tables from multiple data dictionaries
Dictionary Links
creating in Advantage Data Architect
Dictionary Path
Dictionary-Related SQL Statements
DIFFERENCE
SQL scalar function
Differential Backups
Direct Calls to the Advantage Client Engine
Direct Table Access in ADO.NET
Direction
Advantage .NET Data Provider
Directory and Files for Advantage JDBC Driver
Directory Structure
Advantage JDBC Driver
Disable Failed Transaction Recovery
Advantage configuration parameter
Disable Free Connections
Advantage configuration parameter
Disabling Database Logins
general information
using Advantage Data Architect
Disabling Triggers
Disconnect
TAdsConnection.Disconnect
TAdsDictionary.Disconnect
Discovery
Advantage Database Server for NetWare
Advantage Database Server for Windows
Advantage Database Server overview
Advantage Internet Server
registry settings that affect communication
Display NetWare Connection Names
Advantage configuration parameter
DISPLAY_NW_CONN_NAMES
DISTINCT
Distributing
Advantage .NET Data Provider applications
Advantage CA-Visual Objects applications
Advantage Client Engine applications
Advantage ODBC applications
Advantage OLE DB Provider applications
Advantage Shared Objects
Advantage TDataSet Descendant applications
triggers
Distribution
AOF performance tips
ease of distributing Advantage Local Server
installing the Advantage Database Server Daemon for Linux
DLL Caching
DLL Operations
local transactions in the Advantage OLE DB Provider
DLLs
ADSLOC32.DLL
automatic version checking
DOS
Advantage Database Server system requirements
SCANBIND.EXE
Double
ADT field type
DBF field type
Double Quotes
Driver Boundaries in ODBC
Driver Errors in JDBC
Driver Functions
AdsCreateSavepoint
AdsFollbackTransaction80
Advantage Client Engine
Driver Manager in JDBC
Driver Object in JDBC
Driver Settings
Advantage Client Engine
DriverManager.getConnection in JDBC
DROP
DROP FUNCTION
DROP INDEX
DROP PACKAGE
DROP PROCEDURE
DROP TABLE
DROP TRIGGER
DROP VIEW
DropDDLink
TAdsConnection.DropDDLink
TAdsDictionary.DropDDLink
DTOC()
expression engine function
DTOS()
AOF optimization
data type independent expression concatenation operator
expression engine function
dump files
Dynamic
Advantage Database Server discovery for NetWare
communication issues with NetWare
live cursor represents
Dynamic Collation Mismatch Error
Dynamic Cursors
cursor type overview
in full text search
- E -
EADSDatabaseError
ACEErrorCode
ColumnName
component
Create
DatabaseName
DatabasePath
DataSetInstanceName
DataSetInstanceOwner
methods
properties
SQLErrorCode
TableName
edgmen2
Editing Data
Editor
inspecting variable data
modifying database objects
Effective Permissions vs Explicit Permissions
Effects of Upgrading
Effects of Upgrading from a Version Prior to v8.0
Effects of Upgrading to 9.0
Effects of Upgrading to Advantage 8.1
Effects of Upgrading to Version 10
Effects of Upgrading to Version 9.1
ELSE
reserved keyword in Advantage SQL engine
EMPTY
SQL scalar function
Empty DBF
Empty string
Empty Tables
in Advantage Data Architect
EMPTY()
AOF optimization
expression engine function
Enabled
Enabling Table Encryption
Encrypt Tables
in Advantage Data Architect
Encrypting Database Tables
Encryption
ads.ini file support
in Advantage Data Architect native SQL utility
initialization properties in Advantage OLE DB Provider
Internet security levels
overview
using the Advantage OLE DB Provider with ADO
with the Advantage TDataSet Descendant
within Advantage Data Dictionary
Encryption Functions Available
EncryptionPassword
Advantage .NET Data Provider
Advantage OLE DB Provider
Advantage TDataSet Descendant
EncryptionPassword provider-specific Connection
EncryptTable
Advantage .NET Data Provider
END
ENDIF
ENDWHILE
Enforced
Enhanced Security
Enhanced SQL Scripts
Enhanced Support
EnlistTransaction
Advantage .NET Data Provider
Entity Data Model
Entity Framework
Limitations of the Automated Entity Framework Tools
Unsupported Functionality
Entity Framework Namespace
Entity Framework Type Map
Environment Check Log File
Environment Checks
in Advantage Data Architect
Environment Settings
in Advantage Data Architect
Epoch
Advantage .NET Data Provider
ER Diagram Printing
in Advantage Data Architect
ER Diagramming Tool
adding tables to the ER view in Advantage Data Architect
creating referential integrity objects in Advantage Data Architect
developing databases in Advantage Data Architect
ERR_LOST_CACHED_UPDATES
Error and Assert Log Path
Advantage configuration parameter
Error and Diagnostic Logs
Error Codes
ads.ini file support
Error Conditions
in Advantage TPS
Error handling
Error Handling in JDBC
Error Log
Error Log file
Error Log File Size
Advantage configuration parameter
Advantage Local Server configuration
Error Objects
supported interfaces in Advantage OLE DB Provider
Error Table
ERROR_ASSERT_LOGS
ERROR_LOG_MAX
ErrorObject in Advantage OLE DB Provider
ErrorRecord in Advantage OLE DB Provider
Errors
ANSI collation mismatch
OEM collation mismatch
return codes in the Advantage OLE DB Provider
Errors and Error Recovery
Advantage Client Engine
Errors in Advantage OLE DB Provider
overview
Eval Expiration Date
NLM screen
EVALUATE
Evaluation Order
Event Application Log
Event Detail Window
Event Logging
Event Notifications
Event Viewer
Events
Events Notifications
EventTimeout
Exact
AOF optimization
DBF field types and specifications
expression engine operators
Exact Numeric
vs approximate numeric
Example Class AxDBServer for Advantage CA-Visual Objects RDD
Example Code
Advantage Client Engine
Advantage Management API
more Advantage Client Engine examples
Example Situations
full text search
Example Triggers
Exception
Exception Handling
system variables
Exclusive
Advantage TDataSet Descendant
opened
Exclusive Locks
Exclusive Mode
ExecSQLScript
Advantage TDataSet Descendant
EXECUTE
reserved keyword in Advantage SQL engine
Execute as Script
in Advantage Data Architect native SQL utility
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
ExecuteExtendedReader
Advantage .NET Data Provider
ExecuteExtendedReader CommandBehavior
Advantage .NET Data Provider
ExecuteNonQuery
Advantage .NET Data Provider
ExecuteReader
Advantage .NET Data Provider
ExecuteReader CommandBehavior
Advantage .NET Data Provider
ExecuteScalar
Advantage .NET Data Provider
Executing
Advantage
subquery
Executing a Query
Executing SQL
Executing Stored Procedures
Execution Plan
Advantage SQL Engine
Execution Rights
in Advantage Data Architect
Existing BDE Reports
Converting
Existing ODBC Reports
Converting
EXISTS
reserved keyword in Advantage SQL engine
Expansion
Explicit
Explicit and Implicit Record Locking with the Advantage Client Engine
Explicit Unlocks
Exporting Advantage Tables to Code
in Advantage Data Architect
Exporting Data
Exporting Table Data
in Advantage Data Architect
Exporting Table Structures
Express Queue
Expression Engine
operators
Expression Engine Examples
Expression Engine Operators
Expressions
data type independent expression concatenation operator
function compares
functions disqualifies
how indexes are used by ORDER BY clauses
how indexes are used by the WHERE clause
Expressions containing
EXTEND.CHR
Extended DBF Table Data Types
Extended Methods
Advantage TDataSet Descendant
how they work
Extended Procedures
deleting in Advantage Data Architect
detailed description
overview
TDataSet Descendant tutorial
testing and debugging
tips and tricks
Visual Basic tutorial
Extension Functions in PHP
ads_autocommit
ads_close
ads_close_all
ads_commit
ads_connect
ads_cursor
ads_do
ads_error
ads_errormsg
ads_exec
ads_execute
ads_fetch_array
ads_fetch_into
ads_fetch_row
ads_field_len
ads_field_nameword
ads_field_num
ads_field_precision
ads_field_scale
ads_field_type
ads_free_result
ads_longreadlen
ads_num_fields
ads_num_rows
ads_pconnect
ads_prepare
ads_result
ads_result_all
ads_rollback
External Application
debugging
Extract
substring
- F -
Failed Transaction Recovery
Advantage configuration parameter
FAQs
FAT32
Advantage Proprietary file format specifications
Features
advanced functions in Advantage CA-Visual Objects RDD
Features Added
FETCH
OPEN, CLOSE, FETCH
Field Aliases
Field and Path Names in ODBC
Field Data Types
additional
Field Level Constraints
using with Advantage Data Dictionary
Field Names
Advantage Proprietary file format specifications
Field Names and Index Names
Field Types
case insensitive field types
valid types for full text search indexes
FieldCount
Advantage .NET Data Provider
Field-Level Permissions
Fields
adding/removing users to/from groups
creating dictionary links in Advantage Data Architect
creating or modifying databases in Advantage Data Architect
creating or modifying groups in Advantage Data Architect
creating or modifying RI objects in Advantage Data Architect
creating or modifying stored procedures
creating or modifying triggers
creating or modifying users in Advantage Data Architect
creating or modifying views in Advantage Data Architect
setting group permissions in Advantage Data Architect
setting user permissions in Advantage Data Architect
viewing communication statistics in Advantage Data Architect
viewing configuration parameters affecting memory in Advantage Data Architect
viewing configuration parameters not affecting memory Advantage Data Architect
viewing connected users in Advantage Data Architect
viewing database activity in Advantage Data Architect
viewing installation information for Advantage Data Architect
viewing open files in Advantage Data Architect
File Format
Advantage proprietary
choosing
sharing data with non-Advantage applications
specifications
supported in Advantage Client Engine
File Formats
Advantage file formats overview
File Handle Usage
File Locations
for Advantage OLE DB Provider
for distribution in ODBC
File Locations for Distribution
Advantage TDataSet Descendant
File locking
Samba configuration
File Locking with ODBC
File Requirements
Advantage CA-Visual Objects RDD
Advantage Client Engine
File Size
temporary file size in full text search
File Size Support Greater Than 4 Gigabytes
Filename
creating an Advantage Extended Procedure
files
required for Advantage CA-Visual Objects RDD
write privileges
Files Installed
with Advantage OLE DB Provider
Fill
Advantage .NET Data Provider
FillError
Advantage .NET Data Provider
FillSchema
Advantage .NET Data Provider
Filter
Advantage .NET Data Provider
Advantage TDataSet Descendant
in table browser in Advantage Data Architect
Filter Expression
ADI conditional indexes
AOF optimization
using index scopes vs. record filters
Filter Functionality
adding in Advantage TDataSet Descendant
Filtering on memo fields in Advantage CA-Visual Objects RDD
Filtering tables
how indexes are used by the WHERE clause
Filtering with WHERE
how indexes are used by the WHERE clause
FilterOption
Advantage .NET Data Provider
FilterOptions
Filters
Advantage Proprietary file format specifications
differences between AOFs and traditional record filters
using index scopes vs. record filters
Filters Comparison
using index scopes vs. record filters
FINALLY
Find
movement operation
FindClose
Advantage TDataSet Descendant
FindFirstObject
Advantage TDataSet Descendant
Finding a Record Based
FindKey
index scope/range
movement operation
FindKey/FindNearest Functionality
FindNearest
index scope/range
FindNextObject
Advantage TDataSet Descendant
Firewall
Firewall Communication Issues
First
index scope/range
FLOOR
SQL math function
Flow Control
Flush File
AdsFlushFileBuffers
TAdsTable/TAdsQuery.AdsFlushFileBuffers
Flush Frequency
Advantage configuration parameter
FLUSH_FREQUENCY
FlushConnectionPool
Advantage .NET Data Provider
FlushConnectionPool string
Advantage .NET Data Provider
Forwarding and Loop Detection
FoxPro
Advantage file formats overview
Getting Started with Visual FoxPro
index files -- CDX: IDX: NTX
memo files -- DBT: FPT
FoxPro Behavior in ODBC
FoxPro Tags in ODBC
FPT
Advantage file formats overview
memo files -- DBT: FPT
FPT Memo Files
Free Connection
Free Connections
Disable Free Connections configuration parameter
Free Tables Versus Database Tables
FreeDM
Advantage TDataSet Descendant
Frequently Asked Questions
replication
FROM
FTP site
FTS
column permissions
details list
example situations
index creation and temporary file size
index options
index updates
null handling
optimization
overview
quick start
record visibility
scalar functions
scoring
search conditions
using dynamic cursors
using with versions of Advantage prior to v7.0
valid field types for FTS indexes
Full ADO.NET 2.0 Support
Full Text Search
column permissions
details list
example situations
index creation and temporary file size
index options
index updates
null handling
optimization
overview
quick start
record visibility
scalar functions
scoring
search conditions
using dynamic cursors
using with versions of Advantage prior to v7.0
valid field types for FTS indexes
Full Text Search Indexes
Full Text Search Queries
FUNCTION
Functionality
DLL caching
Functions
BLOB in Advantage CA-Visual Objects RDD
Command object interfaces in Advantage OLE DB Provider
Data Source object interfaces in Advantage OLE DB Provider
Error object interfaces in Advantage OLE DB Provider
Rowset object interfaces in Advantage OLE DB Provider
Session object interfaces in Advantage OLE DB Provider
Storage object interfaces in Advantage OLE DB Provider
View object interfaces in Advantage OLE DB Provider
- G -
Gateway Service
General Improvements to Advantage SQL
General Information
General Performance Factors
General Protection Faults
Advantage CA-Visual Objects
GetAceConnectionHandle
Advantage TDataSet Descendant
GetAceIndexHandle
Advantage TDataSet Descendant
GetAceOrderHandle
Advantage TDataSet Descendant
GetAceTableHandle
Advantage TDataSet Descendant
GetActiveDDLinkInfo
Advantage TDataSet Descendant
GetApplicationID
GetBookmark
Advantage .NET Data Provider
GetBoolean
Advantage .NET Data Provider
GetByte
Advantage .NET Data Provider
GetBytes
Advantage .NET Data Provider
GetBytes int long byte[] int int
Advantage .NET Data Provider
GetChar
Advantage .NET Data Provider
GetChars
Advantage .NET Data Provider
GetConnectionPath
Advantage TDataSet Descendant
GetConnectionWithDDPath
Advantage TDataSet Descendant
GetData
Advantage .NET Data Provider
GetDatabasePath
Advantage TDataSet Descendant
GetDatabaseProperty
Advantage TDataSet Descendant
GetDataTypeName
Advantage .NET Data Provider
GetDateTime
Advantage .NET Data Provider
GetDDLinkNames
Advantage TDataSet Descendant
GetDDObjects
Advantage .NET Data Provider
GetDecimal
Advantage .NET Data Provider
GetDeleteCommand
Advantage .NET Data Provider
GetDM
Advantage TDataSet Descendant
GetDouble
Advantage .NET Data Provider
GetFieldNames
Advantage TDataSet Descendant
GetFieldProperty
Advantage TDataSet Descendant
GetFieldType
Advantage .NET Data Provider
GetFillParameters
Advantage .NET Data Provider
GetFloat
Advantage .NET Data Provider
GetGroupNames
Advantage TDataSet Descendant
GetGuid
Advantage .NET Data Provider
GetIndexFileNames
Advantage TDataSet Descendant
GetIndexFileProperty
Advantage TDataSet Descendant
GetIndexNames
Advantage .NET Data Provider
Advantage TDataSet Descendant
GetIndexNamesPerIndexFile
Advantage TDataSet Descendant
GetIndexProperty
Advantage TDataSet Descendant
GetInsertCommand
Advantage .NET Data Provider
GetInt16
Advantage .NET Data Provider
GetInt32
Advantage .NET Data Provider
GetInt64
Advantage .NET Data Provider
GetLinkProperty
Advantage TDataSet Descendant
GetName
Advantage .NET Data Provider
GetNumActiveDDLinks
Advantage TDataSet Descendant
GetOrdinal
Advantage .NET Data Provider
GetPermissions
Advantage TDataSet Descendant
GetPrivateProfileString
Advantage Local Server configuration
GetProcedureNames
Advantage TDataSet Descendant
GetProcedureProperty
Advantage TDataSet Descendant
GetQualifiedTriggerNames
TDataSet Descendant
GetRecordCount
Advantage .NET Data Provider
GetRINames
Advantage TDataSet Descendant
GetRIProperty
Advantage TDataSet Descendant
Gets Backed
GetSchemaTable
Advantage .NET Data Provider
GetServerTime
Advantage TDataSet Descendant
GetStoredProcedureNames
Advantage TDataSet Descendant
GetString
Advantage .NET Data Provider
GetTableAndLinkNames
Advantage TDataSet Descendant
GetTableNames
Advantage .NET Data Provider
TAdsConnection.GetTableNames
TAdsDictionary.GetTableNames
GetTableProperty
Advantage TDataSet Descendant
GetTablesAndLinks
Advantage TDataSet Descendant
GetTimeSpan
Advantage .NET Data Provider
Getting Dictionary Information
Getting Information About Advantage Error Codes
Getting Other Object Information
Getting Started
Getting Started with Replication
Getting Started with Visual FoxPro
Getting Table-Related Information
Getting Tables
Getting User
GetTotalOffsetMinutes
GetTriggerNames
Advantage TDataSet Descendant
GetTriggerProperty
TAdsDictionary.GetTriggerProperty
GetUpdateCommand
Advantage .NET Data Provider
GetUserGroupProperty
Advantage TDataSet Descendant
GetUserNames
Advantage TDataSet Descendant
GetUserProperty
Advantage TDataSet Descendant
GetUsersFromGroup
Advantage TDataSet Descendant
GetValue
Advantage .NET Data Provider
GetValues
Advantage .NET Data Provider
GetViewNames
Advantage TDataSet Descendant
GetViewProperty
Advantage TDataSet Descendant
Go Bottom
index scope/range
live versus static cursors
movement operation
populating static cursors
using index scopes vs. record filters
Go To
index scope/range
movement operation
using index scopes vs. record filters
Go To Record
in table browser in Advantage Data Architect
Go Top
index scope/range
movement operation
using index scopes vs. record filters
GoBottom is Slow
GotoBookmark
Advantage .NET Data Provider
index scope/range
movement operation
GotoBottom
Advantage .NET Data Provider
GotoKey
index scope/range
movement operation
GotoNearest
index scope/range
movement operation
GotoTop
Advantage .NET Data Provider
GPF
Advantage CA-Visual Objects
GRANT
supported SQL statement
Granting Rights
GrantPermissions
Advantage TDataSet Descendant
GROUP
reserved keyword in Advantage SQL engine
GROUP BY
Group Information
Grouping Data
Groups
adding/removing users
creating or modifying in Advantage Data Architect
deleting in Advantage Data Architect
setting permissions in Advantage Data Architect
GUID
SQL scalar function
- H -
Handle
TAdsConnection.Handle
TAdsStoredProc.Handle
HasRows
Advantage .NET Data Provider
HAVING
Help Files
Help Screen (-H)
Advantage configuration parameter
HEX2CHAR
hexadecimal
High Performance
hot backup
HOUR
hour portion of a time or timestamp
How Replication Works Internally
How the Advantage TDataSet Descendant is Built into your Application
How to use the Advantage Client Engine
Hub
- I -
I/O
integrating TPS into Advantage applications
I2BIN()
expression engine function
ICommand Execute in Advantage OLE DB Provider
ICU
icudt40l.dat
Identification
IDX Index Files
IF
script
IF()
expression engine function
IFNULL
SQL scalar function
Ignore Rights
IGNORE TRANSACTIONS
IIF
IIF()
expression engine function
SQL scalar function
Illegal Operations
Advantage TPS error conditions
Image
ADT field type
DBF field type
Immediate and Delayed Update Modes
in Advantage OLE DB Provider
Implementing Replication
Implementing Security
Implicit Record Locking
implicit transactions
Implicit Transactions and Triggers
Import Utility in Advantage Data Architect
Important Notes
Importing Data
into Advantage tables
Impressive Backwards Compatibility
Improved Performance
Improved Stability
Improved Visual Studio 2005 Integration
IN
IncrementUserCount
Index
Advantage .NET Data Provider
Index Creation
full text search temporary file size
Index Creation Capability
adding in Advantage TDataSet Descendant
Index Encryption
Index Expression
Index file locking
Index Files (ADI)
Index Handles
Advantage Client Engine
Index Key Size and Page Size Relationships
Index Optimizations
with ODBC
Index options
using full text search
Index Page Size
Advantage Proprietary file format specifications
Index Properties
INDEX SCAN
Index Scope Versus Traditional Record Filters Comparison
Index Scopes (Ranges)
Index Sort Buffer Size -Z
Advantage configuration parameter
Index Structures
in Advantage TDataSet Descendant
Index Types
Advantage behavior with the ODBC driver
Advantage ODBC Driver
compatibility issues in the Advantage ODBC driver
FoxPro behavior in ODBC
Index Updates
in full text search
IndexCollationMismatch
Advantage TDataSet Descendant
IndexDefs
Advantage TDataSet Descendant
Indexed Sequential Access Method
Indexes
and SQL performance
expressions in SQL
supported in Advantage OLE DB Provider
types of
used by UPDATE: DELETE and INSERT statements
IndexFieldName
Advantage TDataSet Descendant
IndexFiles
Advantage TDataSet Descendant
IndexName
Advantage TDataSet Descendant
IndexOf
Advantage .NET Data Provider
IndexOptions
Advantage .NET Data Provider
InfoExpression
Advantage TDataSet Descendant
InfoMessage
Advantage .NET Data Provider
InfoPower Support for Delphi 3 and Delphi 4
InfoStructure
Advantage TDataSet Descendant
Inherited Rights
in Advantage Data Architect
init.d Script
Initi
Initial Catalog
Advantage .NET Data Provider
in Advantage OLE DB Provider
Initialization Properties
ADSPROP_INIT IN Advantage OLE DB Provider
DBPROPSET_ADSDBINIT in Advantage OLE DB Provider
DBPROPSET_DBINIT in Advantage OLE DB Provider
for ADO in Advantage OLE DB Provider
INLIST
INNER
reserved keyword in Ad
INSERT
Advantage TDataSet Descendant
reserved keyword in Advantage SQL engine
INSERT INTO
execution plan
supported SQL statements
INSERT Statements Using Indexes
Insert/Edit Functionality
Advantage TDataSet Descendant
InsertCommand
Advantage .NET Data Provider
Inserting Records
InsertRecord
Advantage TDataSet Descendant
Inspecting the Call Stack
SQL debugger
Inspecting Variable Data
SQL debugger
Install
Advantage Database Server for Windows
installing and loading the Advantage Database Server for NetWare
installing and running on a Windows cluster
installing the Advantage Database Server Service for Windows
installling the Advantage Database Server NLM for NetWare
performing silent installs
Installation
Advantage .NET Data Provider
Advantage Database Server
Advantage ODBC driver Windows installation
Advantage TDataSet Descendant
building files for TDataSet Descendant applications
optional Advantage AEF files for Advantage CA-Visual Objects RDD
Installation Information for Advantage Data Architect
Installed Files
Advantage TDataSet Descendant
C++Builder-specific files for Advantage TDataSet Descendant
Delphi-specific files for Advantage TDataSet Descendant
Installing
Advantage Database Server with OLE DB Provider
Advantage OLE DB provider
Installing AEPs
Installing SQL Stored Procedures
Installing the Sample Database
InstallShield
Instance
AdsFactory Fields
Advantage .NET Data Provider
INSTEAD OF triggers
Integer
ADT field type
DBF field type
Integrity
intermediate
Internet access
enabling on a per user basis
Internet Client Timeout
configuration parameter
Internet IP Address
Advantage configuration parameter
Internet logins
Internet Port
Advantage configuration parameter
Internet Security Levels
Internet Use
enabling Internet access on a per user basis
specifying the Advantage Internet Server location
INTERNET_CLIENT_TIMEOUT
configuration parameter
INTERNET_IP
ads.ini fi
INTERNET_PORT
Intersect
INTO
InTransaction
transaction processing with Advantage TDataSet Descendant
Introduction
Introduction to Using
IOpenRowset in Advantage OLE DB Provider
IOTA Table
IP
communication issues
networking issues
specifying with the ads.ini file
IP address
ads.ini file support
registry settings that affect communication
IP ECHO ONLY
registry settings that affect communication
IP ONLY
registry settings that affect communication
IP Port
Advantage configuration parameter
IP_PORT
IPCONFIG.EXE
IPX
Advantage client communication layer
Advantage Database Server discovery for NetWare
Advantage Database Server discovery for Windows
communication issues
networking issues
registry settings that affect communication
workstation configuration
IPX ONLY
registry settings that affect communication
IPX SAP ONLY
IPX/SPX
IRowsetRefresh
IS NULL
ISAM
filters
locking
master/detail relations
overview
table sharing modes
ISAM Locking
IsClosed
Advantage .NET Data Provider
IsConnected
TAdsConnection.IsConnected
TAdsDictionary.IsConnected
IsConnectionAlive
AdsConnection
TAdsConnection
IsDBNull
Advantage .NET Data Provider
IsDictionaryConn
Advantage .NET Data Provider
Advantage TDataSet Descendant
ISNULL
Advantage .NET Data Provider
expression engine function
SQL scalar function
IsNullable
Advantage .NET Data Provider
ISO 8601 week number of a date value
IsolationLevel
Advantage .NET Data Provider
ISOWEEK
IsRecordDeleted
Advantage .NET Data Provider
IsRecordLocked
Advantage .NET Data Provider
IsStatic
Advantage .NET Data Provider
IsTableLocked
Advantage .NET Data Provider
Item
Advantage .NET Data Provider
- J -
Java
JDBC Driver
additional methods available to the ADSStatement object
Advantage JDBC Driver directory structure
CallableStatement object
compatibility of Advanatage JDBC Driver
connecting through the JDBC Driver Manager
connecting to a database
Connection object
connection string properties
data types
DatabaseMetaData object
Driver object
error handling
overview
passing the connection URL
PreparedStatement object
registering the driver
result sets
ResultSet object
ResultSetMetaData object
setting the CLASSPATH
Statement object
transaction processing
unsupported functionality
JDBC Driver Errors
JOIN
reserved keyword in Advantage SQL engine
JOINS
across servers
indexing the appropriate fields
JOIN/LEFT/RIGHT/FULL OUTER JOIN
using indexes
- K -
Keep Alive
Client Timeout configuration parameter
internet client timeout
sp_mgGetConfigInfo
Key
ADI conditonal indexes
index key overview
Key Size
Keywords
Knowledge Base
Known Issues
Known Problems
- L -
L2BIN
expression engine function
LAN and Internet Ports
LAN IP Address
Advantage configuration parameter
LAN_IP
ads.ini file support
LAN_IP/LAN_PORT
registry settings that affect communication
Large Tables
with small result sets in Advantage SQL Engine
Last
index scope/range
LASTAUTOINC
Advantage .NET Data Provider
Advantage Client Engine
Advantage OLE DB Provider
suported miscellaneous scalar functions
LastAutoincVal
Advantage TDataSet Descendant
TAdsTable property
LastError
Advantage TDataSet Descendant
LCASE
LD_LIBRARY_PATH
LEAVE
LEFT()
expression engine function
Len
LEN()
expression engine function
LENGTH
Libace
Libace.so
Libadsloc.so
Server Type: Advantage Local Server
Licensing
LIKE
limit
Limitations of the Automated Entity Framework Tools
Limiting
Limiting Query Results
Line Breakpoint
SQL Debugger
Link Manager
Advantage Data Architect native SQL
Linked Data Dictionaries
using tables from multiple data dictionaries
LINQ
Linux
Advantage configuration file
changing the configuration in Advantage
command line parameters
data source entries in ODBC
data source setup in ODBC
distributing Advantage shared objects
lock offset configuration
Native SQL Utility in Advantage Data Architect
ODBC file locations for distribution
overview for Advantage Data Architect
rights checking
Samba configuration
shared objects
troubleshooting
Linux 6060 Errors
Linux ANSI/OEM Translations
Linux Installation Notes
Linux Rights Checking
Linux Shared Objects
Literals
in SQL
SQL statement limits
Live Cursors
comparison to static cursors
cursor type overview
how indexes are used by ORDER BY clauses
how indexes are used by the WHERE clause
how live cursors are processed
scalar functions that can be used in a WHERE clause
Live Cursors Versus Static Cursors
Live versus Static Cursors
LoadParamsFromDictionary
Advantage TDataSet Descendant
Local File Flush Frequency Configuration in Advantage Local Server
Local Server
benefits of selecting the Advantage Local Server
limitations of selecting
server type overview
using with the Advantage RDDs
Local Transactions in Advantage OLE DB Provider
locale
Locate
movement operation
Lock compatibility with ODBC
Lock Limits with ODBC driver
Lock Management
Advantage compatibility locking with Xbase files
multi-user performance
Lock Offset Configuration
Locking
Advantage locking modes
Advantage proprietary
compatibility locking with ADT files
explicit and implicit record locking with the Advantage Client Engine
files with ODBC
ISAM
with Advantage ODBC driver
with SQL and ODBC
Locking Levels with Advantage ODBC Driver
Locking Mode
LockMode
in Advantage OLE DB Provider
LockRecord
Advantage .NET Data Provider
LOCKS
Advantage Local Server configuration
LockTable
Advantage .NET Data Provider
Advantage TDataSet Descendant
LockType Connection String Property in JDBC
LOG
SQL math function
Log Entries
NLM screen
Log File
Log Files
LOG10
SQL math function
Logging
SQL Query Logging
Logical
ADT field type
DBF field type
SQL literal
Logical Operators
LogicalRecordNumber
Advantage .NET Data Provider
LoginPrompt
TAdsConnection.LoginPrompt
TAdsDictionary.LoginPrompt
Logins
disabling database logins
Long Field Names
Long Index Names
Loop control
Low Lock Offsets
Advantage Local Server configuration
Low Maintenance
LOWER()
expression engine function
Lowercase All Paths
Advantage configuration parameter
Advantage Local Server configuration
LOWERCASE_ALL_PATHS
LOWERW()
expression engine function
LTRIM()
expression engine function
- M -
Mailslot
registry settings that affect communication
Mailslot communication
Mailslots
registry settings that affect communication
Maintenance
Making ADO.NET Better
Making Views Accessible
Management
overview for Advantage Data Architect
Management API
disabling database logins
Management API Examples
Advantage TDataSet Descendant
Management API Functions
Advantage Client Engine
Management Capabilities
Management Information
NLM screen
Management Utility
Advantage NLM Management Utility for NetWare
Many Indexes
Mapping
data type mapping in Advantage ODBC Driver
Mapping Data Types in Advantage OLE DB Provider
mapping specification
Master/Detail Relationships
MasterFields
Advantage TDataSet Descendant
Math Functions
MAX
reserved keyword in Advantage SQL engine
Max Pool Size
MAX()
expression engine function
MAX_CACHE_MEMORY
Advantage configuration parameter
MAX_CONNECTIONS
MAX_TIMEOUTS
ads.ini file support
MAXIMUM
Maximum Failed Login Attempts
Maximum Values of SQL Statements
MDAC
MDAC SDK
with Advantage OLE DB Provider
Memo
ADT field type
DBF field type
Memo Block Size
Memo Field Limitations
Memo fields and filtering
Memo fields and filtering in Advantage CA-Visual Objects RDD
Memo Files
ADM
Advantage Proprietary file format specifications
block size
DBT: FPT
MERGE
Merge Module
Message
Advantage .NET Data Provider
Metadata
Methods
Command in Advantage OLE DB Provider
Recordset in Advantage OLE DB Provider
Microsoft C/C++ Integration
integrating the Advantage Client Engine
Microsoft Visual Basic Integration
integrating the Advantage Client Engine
MiddleTierConnection
Min Pool Size
Advantage .NET Data Provider
MIN()
expression engine function
MINIMUM
Minus
MINUTE
Advantage SQL date/time functions
minute portion of a time or timestamp
Miscellaneous SQL Scalar Functions
Miscellaneous System Procedures
MissingMappingAction
Advantage .NET Data Provider
MissingSchemaAction
Advantage .NET Data Provider
MOD
Modifying Database Objects in the Editor
SQL debugger
Modifying Objects
Modifying Subscription Information
Modifying Triggers
in Advantage Data Architect
ModifyLink
Advantage TDataSet Descendant
MODMAN.EXE
ModTime
field types
Modularizing Operations
Modulus
Money
ADT field type
month name of a date value
MONTH()
Advantage SQL date/time functions
expression engine function
MONTHNAME
Advantage SQL date/time functions
Move
MoveBy
index scope/range
movement operation
MoveFirst
movement operation
MoveLast
index scope/range
movement operation
Movement Operations
MoveNext
index scope/range
movement operation
MovePrevious
movement operation
Moving Dictionary Objects
Multicast
Advantage Database Server discovery for NetWare
Advantage Database Server discovery for Windows
Multiple Instances
Multiple Order (Compound) Index Files
definition
Multiple Versions
Multi-segmented
Multi-segmented index
Multitable Queries
Multi-threaded applications
Advantage .NET Data Provider
Advantage TDataSet Descendant
Multi-Threading and Multiple Processors
Multi-User Performance
Advantage Database Server overview
client/server technology
data locking and transaction processing
general performance factors
- N -
Name Space
Advantage .NET Data Provider
namespace
NAS
Native Delphi Functionality
Native Methods
Advantage TDataSet Descendant
Native SQL Link Manager
Native SQL Utility
Advantage Data Architect
Navigation Bar
in table browser in Advantage Data Architect
Navigational Actions
NChar
nested
Nested and Recursive Triggers
nesting
nesting depth
NET Development
NetBEUI
communications issues specific to Windows
NetBIOS API
NetBIOS
Advantage Database Server discovery for Windows
communications issues specific to Windows
overview
NETSTAT
Internet Port configuration parameter
IP Port configuration parameter
NetWare
Advantage Database Server discovery for NetWare
communication issues with Advantage Database Server
Display NetWare Connection Names configuration parameter
troubleshooting
NetWare Server OS Errors
Network Analyzers
Network Attached Storage NAS Devices
Networking Issues
Advantage client communication layer
Advantage communication transport layer
communications
IP
IPX
NetBIOS
workstation configuration
Networking Protocols Used by the Advantage Database Server
New Field Types
NEWIDSTRING
expression engine function
SQL scalar function
Newsgroups
Next
index scope/range
movement operation
NextResult
Advantage .NET Data Provider
NLM
Advantage Database Server NLM screen
Advantage Database Server overview
command line parameters
configuration
management utility
NMemo
Non-Auto-Open
ADI index files
types of indexes
Non-Exclusive Proprietary Locking
Non-Select Statements Processing
Non-Standard Characters in Names
NOT
Advantage SQL grammar
Notifi
notification
Notifications
NOW
Advantage SQL date/time functions
expression engine function
NTX
Advantage file formats overview
NTX Index Files
NULL
reserved keyword in Advantage SQL engine
Null Field Values
Null Handling
in full text search
NULL Values
Num
Number
Advantage .NET Data Provider
Number of Connections (-C)
Advantage configuration parameter
Number of Data Locks (-L)
Advantage configuration parameter
Number of Index Files (-I)
Advantage configuration parameter
Number of Tables (-D)
Advantage configuration parameter
Number of Work Areas (-W)
Advantage configuration parameter
Number of Worker Threads (-T)
Advantage configuration parameter
Express Queue
numbering
NumCachedCursors
Advantage TDataSet Descendant
NumCachedTables
Advantage TDataSet Descendant
NumDecimals
Advantage TDataSet Descendant
Numeric
DBF field type
exact vs approximate
SQL literal
Numeric Operators
NumOpenTables
Advantage TDataSet Descendant
NVarChar
NWLink IPX/SPX-Compatible Transport
- O -
OBDC Driver
index compatibility
Object Breakpoint
SQL Debugger
Object Interfaces
Command in Advantage OLE DB Provider
Data Source in Advantage OLE DB Provider
Rowset in Advantage OLE DB Provider
Session in Advantage OLE DB Provider
Storage in Advantage OLE DB Provider
View in Advantage OLE DB Provider
Object Pascal
creating an Advantage Extended Procedure
Object-Oriented Code
for Advantage CA-Visual Objects RDD
ObjectView
OCTET_LENGTH
ODBC
ODBC Data Source Entries
for Windows
ODBC DLL
ODBC Driver
accessing through the BDE
Advantage behavior with ODBC
API conformance
boundaries
character sets
data source entries for Linux
data source entries for Windows
data source keys
data source setup for Linux
data source setup for Windows
Data Source Setup Screen
database directory
database security
deleted records
distributing Advantage ODBC applications
FoxPro behavior
index optimizations
index types
locking
overview
special characteristics
SQL grammar
system requirements
using with Delphi
Windows installation
with SQL
ODBC Registry
ODBC.INI File
ODBCExpress
OEM
OEM Character Set
OEM Character Sets with ODBC
OEM Collation Mismatch
Avoiding
OEM Collation Mismatch Errors
OEM/Localized Character Set
installing the Advantage Database Server for Linux
OEM_CHAR_SET
Offline Targets
OJ
Ojshorthand
OldValue
OLE DB
Index Operations
List of Existing Indexes
Provider-Specific Connection Parameters
Reindexing
Typical Connection String
OLE DB Provider
Advantage Data Architect utility
bookmarks
Command object information
command parameters
command syntax
Commands overview
Connection object information
connection string parameters
creating rowsets with ICommand Execute
creating rowsets with IOpenRowsets
data source information properties
data source objects
Data Source properties
data type mapping in rowsets and parameters
data types
database security
distributing
errors overview
indexes
initialization properties
installing
installing the Advantage Database Server
preparing commands
product overview
provider-specific Connection properties
provider-specific data source information properties
provider-specific initialization properties
provider-specific Recordset properties for ADO
provider-specific rowset properties
provider-specific session properties
read-ahead record caching
record caching
Recordset object
return codes
Rowset properties
rowsets overview
selecting Advantage Server types via ServerType property
Session properties
sessions overview
setting the date format
SQL literals
storage overview
supported Command object interfaces
supported Data Source object interfaces
supported Error object interfaces
supported Rowset object interfaces
supported schema rowsets
supported Session object interfaces
supported Storage object interfaces
supported View object interfaces
supporting local transactions
system requirements
updating data in rowsets
View properties
views overview
with ADO
ON CONFLICT Triggers
OnConnect
Advantage TDataSet Descendant
OnDisconnect
Advantage TDataSet Descendant
OnFillError
Advantage .NET Data Provider
Online Backup
OnLog
OnLogin
TAdsConnection.OnLogin
TAdsDictionary.OnLogin
OnNotification
OnRowUpdated
Advantage .NET Data Provider
OnRowUpdating
Advantage .NET Data Provider
Open
Advantage .NET Data Provider
Advantage application attempts
OPEN, CLOSE, FETCH
Open All Tables At Startup
Open Data Files
Open Files
Advantage Database Server
in Advantage Data Architect
Open Index Files
Open Tables
Shared Use
OpenIndex
Advantage .NET Data Provider
Opening a Data Dictionary
Opening a Previously Created Table
Opening databases
in Advantage Data Architect
Opening tables in Advantage Data Architect
Operations Since Loaded
NLM screen
Operator contains
Operators
AOF performance tips
data type independent expression concatenation operator
String
Operators (AOF)
Oplocks
Optimistic Locking Mode
In Advantage TDataSet Descendant
Optimization
full text search
indexes and SQL performance
SQL execution plan
Optimization Level
Resulting
Optimize Use
Advantage Read-Ahead Record Caching
Optimized
Optimized Data Access
Advantage Database Server overview
multi-user performance
Optimum Single-User Performance
Optional ODBC Registry Keys
Options for FTS Index Orders
OR
reserved keyword in Advantage SQL engine
OR Logically ORs
OR last
Order
in table browser in Advantage Data Architect
ORDER BY
how indexes are used by ORDER BY clauses
indexes and SQL performance
ORDER BY Clause
small result sets with large tables
Other Dictionary Operations
Other Issues
Other System Tables
Other Table Support Features
OUTER
OUTER joins
Outerjoin
OUTPUT
reserved keyword in Advantage SQL engine
Overview
Crystal Reports
SQL Debugger
Overview of Advantage Database Server
Overview of Advantage Replication
Overview of Advantage SQL Queries
Overview of Index Files
Overview of Stored Procedures
Overview of the Switch Process
Overview of Triggers
Overview of Views
- P -
P
Pack Table
in Advantage Data Architect
Packages
Packed
Packet Exchange
Packet Owner Not Logged In
PACKET_SIZE
ads.ini file support
Packets
Packets Received
PackTable
Advantage .NET Data Provider
PAD()
expression engine function
PADC()
PADL()
PADR()
expression engine function
Page Size
Paradox
Advantage file formats overview
Paradox Data Type
Paradox Table Formats
Advantage file formats overview
Parameter-identifier
ParameterName
Advantage .NET Data Provider
Parameters
Advantage .NET Data Provider
connection in Advantage OLE DB Provider
in SQL Script
local transactions in Advantage OLE DB Provider
mapping datatypes in Avantage OLE DB Provider
Native SQL Utility in Advantage Data Architect
Parameters During Installation
Parameters in SQL Statements
Advantage Client Engine
Advantage SQL Engine
Params
Advantage TDataSet Descendant
Part
Partial Connection
Partial Connection Timeout
Advantage configuration parameter
PartialMatch
Advantage .NET Data Provider
Passing the Connection URL in JDBC
Password
Advantage .NET Data Provider
Advantage Extended Procedures tips and tricks
connecting clients through the Internet to Advantage
Internet security levels
TAdsConnection.Password
TAdsDictionary.Password
using tables from multiple data dictionaries
Password Connection String Property in JDBC
Passwords
changing in Advantage Data Architect
PATH
PERCENT
Performance
Advantage Optimized Filters
benefits of selecting the Advantage Local Server
client/server technology
Express Queue
general Advantage performance factors
indexes and SQL performance
Internet security levels
multi-user performance
read-ahead record caching
small result sets in Advantage SQL Engine
using index scopes vs. record filters
Performance benefit
memo files -- DBT: FPT
Performance compared
non-client/server
Performance Factors
general
non client/server
Performance Improvements
Performance monitoring
Performance Optimization in the Advantage TDataSet Descendant
Performance Proprietary
Performance Proprietary locking
Performance Tests
Advantage troubleshooting tools
comparing Advantage to non-client/server solutions
Performance Tips
Advantage Optimized Filters
Performing Basic Tasks
Performing Silent Installs
Performing Simple Advantage Database Server Upgrades and Expansions
Perl
Permissions
Advantage Data Dictionary user
effective vs explicit
in Advantage Data Architect
setting group permissions in Advantage Data Architect
setting user permissions in Advantage Data Architect
Permitted_Rep_Errors
Personal Identification Number
Pessimistic Locking Mode
in Advantage TDataSet Descendant
Phase
PHP
PHP Extension
connecting clients through the Internet to Advantage
overview
physical
PI
Picture
Pid
Pidfile
Pidof adsd
PIN
After registering
registering
placeCityADO
placeDelphi
Plan
SQL Execution Plan
PollInterval
Pooling
Advantage .NET Data Provider
connection pooling in Advantage .NET Data Provider
Populating Static Cursors
callback functionality
overview
Pos
POSITION
Positioning
POWER
int
Precision
Advantage .NET Data Provider
Precision and Scale
in ODBC
Prepare
Advantage .NET Data Provider
Prepared Queries
PreparedStatement Object in JDBC
Preparing Commands in OLE DB Provider
PRIMARY
Primary Indexes
Primary Key
AdsDDSetTableProperty
ALTER TABLE
CREATE TABLE
SetTableProperty in Advantage TDataSet Descendant
Primary/foreign key
Printing
ER diagrams in Advantage Data Architect
Prior
index scope/range
Procedural Code
for Advantage CA-Visual Objects RDD
Processing Heuristics
Processname
PRODUCT
Product Information Window
installing the Advantage Database Server Service for Windows
installling the Advantage Database Server NLM for NetWare
ProgID
Programming Practices
Progress
AdsExtendedReader
Advantage .NET Data Provider
ProgressMessage
AdsCommand
Advantage .NET Data Provider
Projects
Select
Prompted
Properties
ADSPROP_INIT in Advantage OLE DB Provider
Command in Advantage OLE DB Provider
Connection in Advantage OLE DB Provider
Data Source in OLE DB Provider
data source information in Advantage OLE DB Provider
initialization for ADO in Advantage OLE DB Provider
initialization in Advantage OLE DB Provider
of indexes in Advantage OLE DB Provider
provider-specific data source information in Advantage OLE DB Provider
provider-specific Recordset for ADO
Recordset in Advantage OLE DB Provider
Rowset in Advantage OLE DB Provider
Session in Advantage OLE DB Provider
View in Advantage OLE DB Provider
Property Editors
Proprietary
Proprietary locking
Advantage proprietary locking
multi-user performance
Proprietary scripting
Protocol Auto-Sense
Overriding
Protocols Used
Networking
Provider
in Advantage OLE DB Provider
Provider-specific Connection
database security
Provider-Specific Properties
Connection properties for Advantage OLE DB Provider
Data Source Information Properties for Advantage OLE DB Provider
initialization properties for ADO in Advantage OLE DB Provider
Initialization Properties for Advantage OLE DB Provider
Recordset properties for ADO in Advantage OLE DB Provider
Rowset Properties for Advantage OLE DB Provider
Session Properties for Advantage OLE DB Provider
Providing an External Advantage Connection Handle
Ps
Pseudocolumn
Psudocolumn ROWID
Public Function Shutdown
Public Function Startup
creating an Advantage Extended Procedure
- Q -
Qt
Qualifying a Table Using
Qualifying a Table Using Data Dictionary Links
QUARTER
Advantage SQL date/time functions
Queries
Advantage Data Architect Query Builder
in Advantage Data Architect Native SQL Utility
limitations with static cursors
reusing prepared queries
Query
Query Builder
Query Logging
SQL
Query Tools
Query-specification
Quick Start
Advantage Data Architect
Quoted Strings
QuotePrefix
Advantage .NET Data Provider
Quotes
QuoteSuffix
Advantage .NET Data Provider
- R -
R&R ReportWorks
R&R ReportWorks XBase Edition
RADIANS
SQL math function
RAISE
RAM
RAND
SQL math function
Random number generator
Range Functionality
adding in Advantage TDataSet Descendant
Ranges
RAT()
expression engine function
Raw
ADT field type
RDD
RDDs for Advantage CA-Visual Objects RDD
creating your application with the Advantage libraries
specifying as default or as needed
using RDDSetDefault to specify the Advantage RDD
using with a DB Server class
RDDSETDEFAULT
RDDSetDefault in Advantage CA-Visual Objects RDD
RDDSetInfo
Read
Advantage .NET Data Provider
Read Committed
Read Only
using tables from multiple data dictionaries
READ rights
in Advantage Data Architect
Read/input
Read/write
Advantage compatibility locking with Xbase files
Read-Ahead Record Caching
defined
optimizing use
ReadAllColumns
Advantage TDataSet Descendant
Reading
README
ReadOnly
Advantage .NET Data Provider
Advantage TDataSet Descendant
ReadPrevious
Advantage .NET Data Provider
Realnumber
rebuild indexes
Rebuilds
Recall All Records
in Advantage Data Architect
Recall Current Record
in Advantage Data Architect
RecallAllRecords
Advantage .NET Data Provider
RecallRecord
Advantage .NET Data Provider
RecCount
RecCount is slow
Receive Packets Out of Sequence
Recno
Advantage TDataSet Descendant
RECNO()
expression engine function
read-ahead record caching
Recommended Best Usage
Advantage TDataSet Descendant
Record Caching
in Advantage OLE DB Provider
Record Deletion Status as a Filter
Record filter include
Record Filters
how indexes are used by the WHERE clause
index scope/range
using index scopes vs. record filters
Record locking
Advantage locking modes
data locking and transaction processing
explicit and implicit record locking with the Advantage Client Engine
in Advantage TDataSet Descendant
in ODBC
Record matches
Record Visibility
in full text search
Record/Count
in table browser in Advantage Data Architect
RecordCache
Advantage .NET Data Provider
RecordCount
Advantage TDataSet Descendant
RecordCount INTEGER OUTPUT
RecordNumber
Advantage .NET Data Provider
Records
explicit and implicit record locking with the Advantage Client Engine
Records Read by the Client
RecordsAffected
Advantage .NET Data Provider
Recordset Object
in Advantage OLE DB Provider
Recordset Properties for ADO in Advantage OLE DB Provider
Redistributing Advantage Data Architect
in Windows
Redistributing MDAC
for Advantage OLE DB Provider
Reducing Network Traffic
Referencing
Advantage .NET Data Provider
Referential Integrity
overview
using with Advantage Data Dictionary
Referential Integrity and Replication
Referential Integrity Object
creating with the ER Diagramming tool in Advantage Data Architect
deleting in Advantage Data Architect
Referential Integrity Objects
creating in Advantage Data Architect
removing in Advantage Data Architect
Refresh
active database in Advantage Data Architect
Refresh in Advantage Data Architect
changing the refresh rate in the Advantage Management Utility
manually refreshing current view in Advantage Management Utility
Refreshing Rows
in Advantage OLE DB Provider
RefreshParams
Advantage TDataSet Descendant
RefreshSchema
Advantage .NET Data Provider
RefreshVisibleData
read-ahead record caching
REGEDIT.EXE
Registering
Advantage .NET Data Provider applications
MyCallbackFunction
PIN
Registering the Advantage OLE DB Provider
Registering the Driver in JDBC
Registering Triggers
Registration
Advantage Extended Procedures tips and tricks
installing the Advantage Database Server for Linux
Registry
database security
for Windows
Registry Editor
Registry keys
ODBC driver
optional for ODBC driver
Registry Modification
Registry Settings
affect on communication
Regsvr32.exe
Reindex
Advantage .NET Data Provider
Re-Index
in Advantage Data Architect
Reindexing
Rejected
NLM screen
Relational Operators
Relations
Relations (Master/Detail Relationships)
RelativeKeyPosition
Advantage .NET Data Provider
Remote
server types
Remote Data
Remote Database Server
Remote Views
RemoveAt int
Advantage .NET Data Provider
RemoveAt string
Advantage .NET Data Provider
Removed Partial Connection
Removed/disabled
RemoveIndex
Advantage TDataSet Descendant
RemoveIndexFile
Advantage TDataSet Descendant
RemoveProcedure
Advantage TDataSet Descendant
RemoveRI
Advantage TDataSet Descendant
RemoveTable
Advantage TDataSet Descendant
RemoveTrigger
Advantage TDataSet Descendant
RemoveUser
Advantage TDataSet Descendant
RemoveUserFromGroup
Advantage TDataSet Descendant
RemoveView
Advantage TDataSet Descendant
Removing
referential integrity objects in Advantage Data Architect
users from groups in Advantage Data Architect
Removing a Table
Removing Tables from Databases
with Advantage Data Architect
REPEAT
REPLACE
REPLACE_UNC_SERVER
Replication
Advantage error log
auto-updating fields
Behind the Scenes
connection pooling usage
creating a publication
creating a subscription
deleted records
forwarding and loop detection
frequently asked questions
getting started
modifying subscription information
N-way
offline targets
one-way
overview
publications options
referential integrity
requirements
scenarios
security
subscription options
terminology
transactions
two-way
using triggers
Replication Example
Replication Support
Report Distribution
Reporting progress
request
RequestLive
Advantage TDataSet Descendant
Required Files for Distribution
Advantage TDataSet Descendant
Requirements
Advantage .NET Data Provider
Advantage Database Server
Advantage OLE DB Provider
Crystal Reports
RequirePrimaryKey
Advantage .NET Data Provider
Reserved Keywords
Restart|reload
Restarting
debug session
Restoring Data
Restoring Data Using
RESTRICT
Restructure
Advantage TDataSet Descendant
Result Sets in JDBC
Result Sets Using PHP
Result Sets with Large Tables
Advantage SQL Engine
ResultSet Object in JDBC
ResultSetMetaData Object in JDBC
Retrieve Metadata
Using SQL
RETRY_ADS_CONNECTS
RETURN
Return Codes
errors in Advantage OLE DB Provider
REVERSE()
expression engine function
REVOKE
RevokePermissions
Advantage TDataSet Descendant
Revoking Rights
RI
referential integrity overview
using with Advantage Data Dictionary
RI Objects
creating or modifying in Advantage Data Architect
creating with ER Diagramming tool in Advantage Data Architect
deleting in Advantage Data Architect
RI Visual Designer
RIGHT()
expression engine function
Rights
in Advantage Data Architect
setting group permissions in Advantage Data Architect
setting user permissions in Advantage Data Architect
Rights Checking
in Advantage OLE DB Provider
on Linux
value in ODBC registry
Rights Checking Mode
Rollback
Advantage .NET Data Provider
Advantage TPS error conditions
TAdsConnection.Rollback
Rollback Phase
ROLLBACK WORK
ROUND()
expression engine function
Row Level Trigger Support
ROWID
ROWNUM
Rowsets
bookmarks in Advantage OLE DB Provider
creating with ICommand Execute in Advantage OLE DB Provider
creating with IOpenRowset in Advantage OLE DB Provider
indexes in Advantage OLE DB Provider
mapping data types in Advantage OLE DB Provider
overview for Advantage OLE DB Provider
properties in Advantage OLE DB Provider
provider-specific properties in Advantage OLE DB Provider
supported object interfaces in Advantage OLE DB Provider
updating data in Advantage OLE DB Provider
views in Advantage OLE DB Provider
RowVersion
field types
RTRIM()
expression engine function
Run Time Problems
Advantage CA-Visual Objects
- S -
Samba
configuration
running
Samba Configuration
Sample Application
add active index selection
add filter functionality
add FindKey/FindNearest functionality
add index creation capability
add search functionality
adding range functionality in Advantage TDataSet Descendant
create a simple browser
increase Insert/Edit functionality
performing data conversion using the Advantage Data Architect
Sample PHP Web Site
SAP
Advantage Database Server discovery for NetWare
communication issues with NetWare
registry settings that affect communication
SAVEPOINT
Savepoints
Advantage TPS limitations
Scalability
Scalable
Scalar Functions
using full text search
Scalar Functions in a WHERE Clause
Scalar Functions Supported
Scalarshorthand
Scale
Advantage .NET Data Provider
SCANBIND.EXE
communication issues with NetWare
Scanning a Result Set
Scanning Result Sets
Schema Rowsets
supported in the Advantage OLE DB Provider
Schema Rowsets in Advantage OLE DB Provider
overview
Schema Templates
creating a new table
creating a new template
creating from an existing table
creating from an existing template
Scope
in table browser in Advantage Data Architect
Scope versus Traditional Record Filters Comparison
ScopeBegin
Advantage TDataSet Descendant
Scoped
Advantage TDataSet Descendant
ScopeEnd
Advantage TDataSet Descendant
Scopes
index scope/range
using index scopes vs. record filters
SCORE
SQL scalar function
SCOREDISTINCT
SQL scalar function
Scoring
in full text search
Script
debugging
Scrollable
Scrollable cursor
cursor type overview
Search
in table browser in Advantage Data Architect
Search Conditions
using full text search
Search Functionality
Search-condition
Searched_case
Searched_when_clause
Searched_when_clause searched_when_clauses
Searched_when_clauses
SECOND
second portion of a time or timestamp
Security
encryption
ignore rights method
Internet security levels
replication
semaphore connection file
Security access
file
Security Levels
Internet
Security Log
Security Log—tracks
SecurityMode
Advantage .NET Data Provider
in Advantage OLE DB Provider
Seek
Advantage .NET Data Provider
Go Bottom causes
index scope/range
movement operation
using index scopes vs. record filters
SeekType
Advantage .NET Data Provider
SELECT
using tables from multiple data dictionaries
SELECT COUNT
SELECT custid FROM
SelectCommand
Advantage .NET Data Provider
Selecting
Advantage Server types for OLE DB Provider
debug break
server types via the ServerType Property in OLE DB Provider
Selecting Data
Selecting Record Subsets
SEMAPHORE
Semaphore connection
Semaphore Connection File Path
Advantage configuration parameter
Semaphore Connection Files
Sending bursts
Sequence
Packets Out
Receive Requests Out
Sequenced
Advantage TDataSet Descendant
in table browser in Advantage Data Architect
SequencedLevel
Advantage TDataSet Descendant
Sequentialized
multi-user performance
Serial Number
installing the Advantage Database Server for Linux
installing the Advantage Database Server Service for Windows
installling the Advantage Database Server NLM for NetWare
NLM screen
Server
Advantage Database Server overview
Server AbEnd
Server Crash Recovery
Server Crashes
Server name
Server Processors
Server RAM
Server Settings
Advantage communications compression
Server Type
Advantage Database Server
Advantage Internet Server
Advantage Local Server
Crystal Reports
Server Types
overview
programmatically selecting for OLE DB Provider
programmatically selecting in the Advantage TDataSet Descendant
selecting via the ads.ini file
selecting via the TAdsConnection component
selecting via the TAdsSettings Component
TAdsConnection.AdsServerTypes
TAdsDictionary
TAdsSettings
ServerName
Advantage .NET Data Provider
Advantage TDataSet Descendant
Server-Side Aliases
ServerTime
Advantage .NET Data Provider
ServerType
Advantage .NET Data Provider
ServerType Property
in Advantage OLE DB Provider
ServerVersion
Advantage .NET Data Provider
Service
Service Advertising Protocol
Advantage Database Server discovery for NetWare
communication issues with NetWare
Service Control Manager
Service Name
Service Up Time
Session Properties
in Advantage OLE DB Provider
provider-specific in Advantage OLE DB Provider
SessionName
Sessions
in Advantage OLE DB Provider
properties in Advantage OLE DB Provider
provider-specific session properties in Advantage OLE DB Provider
supported object interfaces in Advantage OLE DB Provider
SET <system variable>
SET TRANSACTION
SET_DEFAULT
SET_NULL
SET_OPTIMIZE
SetBoolean
Advantage .NET Data Provider
SetByte
Advantage .NET Data Provider
SetBytes
Advantage .NET Data Provider
SetChars
Advantage .NET Data Provider
SetCursorCache
Advantage .NET Data Provider
SetDatabaseProperty
Advantage TDataSet Descendant
SetDateTime
Advantage .NET Data Provider
SetDecimal
Advantage .NET Data Provider
SetDelphiDate
Advantage TDataSet Descendant
SetDouble
Advantage .NET Data Provider
SetFieldProperty
Advantage TDataSet Descendant
SetFloat
Advantage .NET Data Provider
SetHandle
TAdsConnection.SetHandle
SetInt16
Advantage .NET Data Provider
SetInt32
Advantage .NET Data Provider
SetInt64
Advantage .NET Data Provider
SetObjectAccessRights
Advantage TDataSet Descendant
SetProcedureProperty
Advantage TDataSet Descendant
SetRange
Advantage .NET Data Provider
SetString
Advantage .NET Data Provider
SetTableCache
Advantage .NET Data Provider
SetTableProperty
Advantage TDataSet Descendant
SetTimeSpan
Advantage .NET Data Provider
Setting
group permissions in Advantage Data Architect
user permissions in Advantage Data Architect
Setting a Filter
Setting a Range
Setting an Index
Setting Breakpoints
SQL debugger
Setting the CLASSPATH in JDBC
Setting the Date Format
in Advantage OLE DB applications
Setting Up a Data Source
for Linux in ODBC
for Windows in ODBC
Settings
ads.ini file support
NLM configuration file
Settings affecting
configuration parameters screen
Settings List
SETUP.EXE
setup.ini
SETUP.ISS
Setup.pl
SetUserGroupProperty
Advantage TDataSet Descendant
SetUserProperty
Advantage TDataSet Descendant
SetValue
Advantage .NET Data Provider
SetViewProperty
Advantage TDataSet Descendant
Share
Shared
Advantage .NET Data Provider
Shared Mode
Advantage compatibility locking with Xbase files
Advantage Extended Procedures tips and tricks
Shared Objects
distributing Advantage shared objects
in Linux
Server Type: Advantage Local Server
Shared Use
Open Tables
Sharing Data with Non-Advantage Applications
SHIFT LEFT
SHIFT RIGHT
Short Integer
ADT field type
ShortDate
DBF field type
ShortInteger
ADT field type
SHOW PLAN FOR
SQL Execution Plan
ShowDeleted
Advantage .NET Data Provider
Advantage TDataSet Descendant
ShowDeleted Connection String Property in JDBC
Showing
Deleted DBF Records
Showing Deleted DBF Records
Shutdown
creating an Advantage Extended Procedure
SIGN
SQL math function
Silent Installs
Silent Mode
SIN
SQL math function
Single Application Scalability
Single Order Index Files
definition
IDX and NTX format
Single Quotes
Single-threaded
Size
Advantage .NET Data Provider
Skip
index scope/range
movement operation
read-ahead record caching
using index scopes vs. record filters
Small Result Sets with Large Tables
Advantage SQL Engine
Softseek
using index scopes vs. record filters
SOME
SORT
SORT_BUFFER
Index Sort Buffer Size configuration parameter
Sorting Data
SOUNDEX
SQL scalar function
Source Code
SourceColumn
Advantage .NET Data Provider
SourceTableType
Advantage TDataSet Descendant
SourceVersion
Advantage .NET Data Provider
sp_AddIndexFileToDatabase
sp_AddTableToDatabase
sp_AddUserToGroup
sp_AllowMultipleCollations
sp_BackupDatabase
sp_BackupFreeTables
sp_CancelQuery
sp_CreateArticle
sp_CreateEvent
sp_CreateGroup
sp_CreateIndex
sp_CreateIndex90
sp_CreateLink
sp_CreatePublication
sp_CreateReferentialIntegrity
sp_CreateSubscription
sp_CreateUser
sp_DisableQueryLogging
sp_DisableTriggers
sp_DropAllEvents
sp_DropArticle
sp_DropEvent
sp_DropGroup
sp_DropLink
sp_DropPublication
sp_DropReferentialIntegrity
sp_DropSubscription
sp_DropUser
sp_EnableQueryLogging
sp_EnableTriggers
sp_GetApplicationID
sp_GetCollations
sp_GetCollationTable
sp_GetColumns
sp_GetRecordCRC
sp_GetSQLKeywords
sp_GetSQLStatements
sp_GetTables
sp_IgnoreTransactions
sp_mgGetActivityInfo
sp_mgGetAllIndexes
sp_mgGetAllLocks
sp_mgGetAllTables
sp_mgGetCommStats
sp_mgGetConfigInfo
sp_mgGetConfigMemory
sp_mgGetConnectedUsers
sp_mgGetIndexUsers
sp_mgGetInstallInfo
sp_mgGetLockOwner
sp_mgGetServerType
sp_mgGetTableIndexes
sp_mgGetTableUsers
sp_mgGetUsageInfo
sp_mgGetUserIndexes
sp_mgGetUserLocks
sp_mgGetUserTables
sp_mgGetWorkerThreadActivity
sp_mgKillUser
sp_mgResetCommStats
sp_ModifyArticleProperty
sp_ModifyDatabase
sp_ModifyFieldProperty
sp_ModifyGroupProperty
sp_ModifyIndexProperty
sp_ModifyLink
sp_ModifyProcedureProperty
sp_ModifyPublicationProperty
sp_ModifySubscriptionProperty
sp_ModifyTableProperty
sp_ModifyUserProperty
sp_ModifyViewProperty
sp_MoveDDObjectFile
sp_PackTable
sp_ProcessReplicationQueues
sp_Reindex
sp_RemoveIndexFile
sp_RemoveUserFromGroup
sp_RenameDDObject
Advantage SQL Engine
sp_RestoreDatabase
sp_RestoreFreeTables
sp_SetApplicationID
sp_SignalEvent
sp_ViewQueryLogging
sp_WaitForAnyEvent
sp_WaitForEvent
sp_ZapTable
SPACE()
expression engine function
Specifications
ADT field type specifications
Advantage file formats overview
Advantage Proprietary file format specifications
DBF field types and specifications
Specifying an IP Address
ads.ini file support
Specifying an IP Port
ads.ini file support
Specifying the Advantage Internet Server Location
Speed
Advantage Optimized Filters performance tips
CPU
Network
Spoke Replication
SPX
SQL
Advantage Data Architect native SQL link manager
Advantage Data Architect Native SQL Utility
Advantage Database Server overview
Advantage SQL overview
Advantage TDataSet Descendant TAdsQuery.SQL
building queries in Advantage Data Architect
comments in SQL statements
Delphi Property Editor
execution plan
exporting Advantage tables to code in Advantage Data Architect
extended data types
functions
grammar
grammar in ODBC
how indexes are used by ORDER BY clauses
indexes and SQL performance
miscellaneous system procedures
parameters and syntax supported in Advantage OLE DB Provider
SQL literals
standard data types
statement limitations with ODBC
statement limits
statement parameters in the Advantage Client Engine
suported miscellaneous scalar functions
supported aggregate column functions
supported data types
supported math scalar functions
supported scalar functions
supported statements
timeout
using to manage tables
using with Advantage ODBC Driver
using with CA-Visual Objects RDD
using with the Advantage Client Engine
using with the Advantage OLE DB Provider
working with cursor handles
SQL Debugger
changing keyboard shortcuts
changing the default window layout
controlling script execution
debugging a database object
debugging a script
debugging an external application
inspecting the call stack
inspecting variable data
menu
modify database objects in the editor
overview
setting breakpoints
SQL Execution Plan
Advantage SQL Engine
SQL Functionality
Query Logging
SQL Link Manager
SQL Literals
SQL Operators
SQL Optimization
indexes and SQL performance
SQL execution plan
SQL Pass Through
SQL Query Logging
SQL Reserved Keywords
SQL Scalar Functions
SQL Script
overview
SQL Scripted Stored Procedure
SQL Scripts
SQL Sort Buffer Size
Advantage configuration parameter
SQL Statement
DROP FUNCTION
SQL Statement Dimensions
SQL Statements
ALTER FUNCTION
CREATE FUNCTION
CREATE PACKAGE
DROP PACKAGE
SQL Timeout
SQL Transaction Processing Statements
SQL Utility
SQL_ATTR_CURSOR_TYPE
SQL_TSI_DAY
SQL_TSI_HOUR
SQL_TSI_MINUTE
Advantage SQL date/time functions
SQL_TSI_QUARTER
SQL_TSI_SECOND
Advantage SQL date/time functions
SQL_TSI_WEEK
SQL_TSI_YEAR
Advantage SQL date/time functions
SQLTimeout
SQRT
SQL math function
Stability
Advantage Database Server overview
Stack Size
with ODBC
START AT
Starting
debug session
StartTransaction
transaction processing with Advantage TDataSet Descendant
StartUp
creating an Advantage Extended Procedure
Startup and Shutdown Functions
Startup function
creating an Advantage Extended Procedure
Startup Parameters
for Windows
using startup parameters to change Advantage configuration
State
Advantage .NET Data Provider
StateChange
Advantage .NET Data Provider
Statement Object in JDBC
Static
Static Cursor Example
Static cursor rowset
Static Cursors
comparison to live cursors
cursor type overview
how static cursors are processed
limitations
populating
static or read-only data
Static vs. Live Cursors
Statistics
StDev
Step Commands
debug session
StmtHandle
Advantage TDataSet Descendant
STOD()
expression engine function
Stopping
Advantage Database Server Service
debug session
Storage
in Advantage OLE DB Provider
storage metadata schema
Storage Objects
supported interfaces in Advantage OLE DB Provider
StoreActive
Advantage TDataSet Descendant
StoreConnected
Advantage TDataSet Descendant
Stored Procedures
calling
containers
creating
creating or modifying in Advantage Data Architect
deleting in Advantage Data Architect
disabling database logins
privileges
using with Advantage Data Dictionary
Stored Procedures Versus
StoredProcedureConnection
Advantage TDataSet Descendant
in Advantage OLE DB Provider
STOTS()
expression engine function
STR()
expression engine function
String
expression engine operators
timestamp
String Functions
String Properties
Catalog in JDBC
CharType in JDBC
Connection in JDBC
LockType in JDBC
Password in JDBC
ShowDeleted in JDBC
TableType in JDBC
User in JDBC
Structural CDX
Structure of AEPs
Structure of SQL Stored Procedures
STRZERO()
expression engine function
Subindexes
Subqueries
limitations with static cursors
Subquery
SUBSTR()
expression engine function
Substring
SUM
reserved keyword in Advantage SQL engine
Superior ADO.NET 1.1 Support
Superuser
Supported Connection Methods in Advantage OLE DB Provider
Supported Data Types in the Advantage SQL Engine
Supported file formats
for Advantage CA-Visual Objects RDD
Supported Object Interfaces
Commands in Advantage OLE DB Provider
Data Source in Advantage OLE DB Provider
Errors in Advantage OLE DB Provider
Rowset in Advantage OLE DB Provider
Session objects in Advantage OLE DB Provider
Storage in Advantage OLE DB Provider
View in Advantage OLE DB Provider
Supported Operating Systems and Platforms
Supported Schema Rowsets
in Advantage OLE DB Provider
Supported SQL statements
Suppported Rowsets
in Advantage OLE DB Provider
Suppress Message Boxes
Advantage configuration parameter
Switch
Switch TDataSet Versions
Syntax
for Command objects in Advantage OLE DB Provider
SYS
System
System Failure Recovery
System Management
System Procedures
System Requirements
Advantage .NET Data Provider
Advantage Client Engine
Advantage Database Server
Advantage Internet Server
Advantage ODBC driver
Advantage OLE DB Provider
System Stored Procedures
System Tables
Advantage SQL Engine
System Variables
System Views
Advantage SQL Engine
system.articles
system.columns
system.dictionary
system.effectivepermissions
system.fts
system.functions
system.indexes
system.indexfiles
system.links
system.objects
system.packages
system.permissions
system.publicationarticles
system.publications
system.relations
system.storedprocedures
system.subscriptions
system.systemprocedures
system.tables
system.triggers
system.usergroupmembers
system.usergroups
system.users
system.views
- T -
T-#####.TMP
T-#####.TPS
TABLE
Table (ADT)
Table (DBF)
Table Aliases
Table Browser
in Advantage Data Architect
Table Commands
in Advantage Data Architect
Table Data
exporting in Advantage Data Architect
Table Data Caching
Table Encryption
Table Encryption Enabled
Table Formats
Advantage file formats overview
Table Formats Supported
Table Functions
Advantage Client Engine
Table Handles
Advantage Client Engine
Table Information
Table locking
integrating TPS into Advantage applications
Table Maintenance
Table Names
Table Names with Paths
TABLE SCAN
Table Sharing Modes
TABLE_CACHING
Table_Trans_Free
TABLE_TXN_FREE
Table-constraint
Tablelist
TableMappings
Advantage .NET Data Provider
TableName
Tableref
Tables
creating temporary tables
Tables Configuration in Advantage Local Server
Tables in Advantage Data Architect
adding existing tables to the database
adding to the ER view
commands
creating
exporting Advantage tables to code
importing data into Advantage tables
opening
removing from a database
schema templates
Tables to a Data Dictionary
Tables to Code Generator
in Advantage Data Architect
TableType
Advantage .NET Data Provider
Advantage TDataSet Descendant
in Advantage OLE DB Provider
TableType String Property in JDBC
TAdsAEPSessionMgr
component
methods
TAdsBatchMove
methods
properties
TAdsBcdField
Advantage TDataSet Descendant
TAdsBlobStream
component
methods
TAdsConnection
component
events
methods
properties
TAdsDictionary
Advantage TDataSet Descendant
events
methods
properties
TAdsEvent
TAdsQuery
Advantage TDataSet Descendant
LastAutoincVal
MasterFields
Property Editors
Scoped
ScopeEnd
type definitions
TAdsQuery Events
Advantage TDataSet Descendant
TAdsQuery Methods
Advantage TDataSet Descendant
TAdsQuery Properties
AdsConnection
Advantage TDataSet Descendant
TAdsQuery.SQL
Property Editor
TAdsSettings
component
methods
properties
TAdsStoredProc
Advantage TDataSet Descendant
methods
TAdsStoredProc Properties
Advantage TDataSet Descendant
TAdsStringField
Advantage TDataSet Descendant
TAdsStringField Properties
TAdsTable
Advantage TDataSet Descendant
known differences with TTable
Property Editors
type definitions
TAdsTable Events
Advantage TDataSet Descendant
TAdsTable Methods
Advantage TDataSet Descendant
TAdsTable properties
AdsConnection
AdsTableOptions
Advantage TDataSet Descendant
Bookmark
DatabaseName
EncryptionPassword
IndexCollationMismatch
IndexFiles
InfoExpression
LastAutoincVal
MasterFields
RecNo
RecordCount
ScopeBegin
Scoped
ScopeEnd
Table Type
TAN
SQL math function
Task 1 Copy Test Data and Create Database
Task 2 Create Your Trigger Project
Task 3 Implement Your Trigger
Task 4 Register Your Trigger in the Database
Task 5 Test and Debug
TCallbackFunction
tcNone
TCP
TCP/IP
ads.ini file support
TCP/IP Support for All Clients
tcReads
TCrpe Report Alias
changing at runtime
tcWrites
TDataSet Switch Utility
TDataSet Versions Supported
Technical Support
temporary
Temporary File Size
full text search index creation
Temporary Tables
creating
using in SQL
Testing a View
Testing AEPs
Testing FTS Index Orders
Testing Indexes
Testing the New Trigger
Text Search
column permissions
details list
index creation and temporary file size
index options
index updates
null handling
optimization
overview
quick start
record visibility
scalar functions
scoring
search conditions
using dynamic cursors
using with versions of Advantage prior to v7.0
valid field types for FTS indexes
THdbc
The adsbackup Utility
The AdsSQLServer Class
Third-Party Components with Advantage
thread
Threads
building mulit-threaded apps with TAdsQuery and TAdsTable
Express Queue
multi-threading in Advantage .NET Data Provider
NLM configuration file
NLM screen
number of worker threads
Time
ADT field type
SQL literal
TIME()
expression engine function
TimedOut
Advantage .NET Data Provider
Timeout
Client Timeout configuration parameter
NLM configuration file
Timestamp
ADT field type
SQL literal
STOTS expression engine function
trigger modifies
TIMESTAMPADD
Advantage SQL date/time functions
Timestampdiff
TMP_FILE_POOL_SIZE
TODAY()
expression engine function
TOEQuery
TOP
TOP x
Total Packets
TParam
TPS
error conditions
in JDBC
integrating TPS into Advantage applications
TPS File Locations
TPS_LOGS
NLM configuration file
transaction
Advantage .NET Data Provider
Transaction Isolation Levels
in JDBC
Transaction Log File stability
Transaction Log Files Path
Advantage configuration parameter
NLM configuration file
Transaction Processing
ACE API examples
ACE APIs
capturing errors and error recovery in the Advantage Client Engine
error conditions
explicit and implicit record locking with the Advantage Client Engine
features
in JDBC
integrating TPS into Advantage applications
introduction
limitations
number of transactions per connection
use of deleted byte
using with the Advantage Data Dictionary
when to use
with Advantage CA-Visual Objects RDD
with data locking
with the Advantage TDataSet Descendant
Transaction Processing APIs
integrating TPS into Advantage applications
Transaction Processing System Features
Transaction programming
Transaction Savepoints
Transaction Support in the Advantage .NET Data Provider
TransactionActive
TAdsConnection.TransactionActive
transaction processing with Advantage TDataSet Descendant
TransactionCount
transaction-free
transaction-free table
Transaction-Free Tables
Transactions
and locking with ODBC
in Advantage Data Architect Native SQL Utility
processing with Advantage CA-Visual Objects RDD
replication
supporting local transactions in the Advantage OLE DB Provider
Transactions Exist Per Connection
Transactions operating
transaction-tree tables
TRANSFORM()
expression engine function
Transliterate
Advantage TDataSet Descendant
Transmission Control Protocol
Trigger Containers
Trigger Deadlock
Trigger Limitations
Trigger modifies
timestamp
Trigger Options
Trigger Permissions
Trigger Priority
Trigger support
Trigger Types
Triggers
__old __new and __error tables
containers
creating
creating or modifying in Advantage Data Architect
deadlock
debugging
deleting in Advantage Data Architect
disabling
distributing
implicit transactions
limitations
nested and recursive
on static views
options
overview
permissions
row level support
Test/Debug button
trigger types
tutorial
using in replication
using with Advantage Data Dictionary
Triggers on Static Views
TRIM
SQL statement
TRIM()
expression engine function
TrimTrailingSpaces
Advantage .NET Data Provider
in Advantage OLE DB Provider
Troubleshooting
adsdump files
Advantage CA-Visual Objects RDD error object
Advantage CA-Visual Objects RDD general protection faults
Advantage CA-Visual Objects run time problems
Advantage Internet Server
Advantage tools
ANSI collation mismatch errors
Communications
error and diagnostic logs
in the Linux environment
in the NetWare environment
installation of the Advantage ODBC driver
non-Advantage tools
OEM collation mismatch errors
TRUNCATE
SQL math function
TRY
TSTOD
expression engine function
TTOC
Tutorials
Advantage Extended Procedures for Advantage TDataSet Descendant
Advantage Extended Procedures for Visual Basic
Advantage Triggers
developing a sample Advantage-enabled Delphi application
Type Definitions
Advantage TDataSet Descendant
Types of Index Orders
Typical Connection String
in Advantage OLE DB Provider
- U -
UCASE
UDF
UDFs
UDP
Understanding Constraints
Understanding Groups
Understanding the TDataSet Descendants
Unicode
unicode collation
Unicode strings
UniDirectional
Advantage TDataSet Descendant
Unidirectional Replication
Uninstall
Advantage Database Server Service
Uninstalling the Advantage TDataSet Descendant
UNION
reserved keyword in Advantage SQL engine
UNION ALL
UNIQUE
Unique Indexes
ADI
types of indexes
UNLOAD NLM
UnlockRecord
Advantage .NET Data Provider
UnlockTable
Advantage .NET Data Provider
Advantage TDataSet Descendant
unsupported
Unsupported Entity Framework Functionality
Apply
BitWiseAnd
BitWiseNot
BitWiseOr
BitWiseXor
Cross Join
CurrentDateTimeOffset
CurrentUtcDateTime
GetTotalOffsetMinutes
Intersect
Minus
Skip
StDev
Visit
Unsupported Functionality
accessors in Advantage OLE DB Provider
asynchronous operations in Advantage OLE DB Provider
calling the Advantage client engine API directly in Advantage OLE DB Provider
client cursor support in Advantage OLE DB Provider
creating and deleting indexes and tables in Advantage OLE DB Provider
cursor types in Advantage OLE DB Provider
dealyed/batch updates in Advantage OLE DB Provider
in JDBC
multiple rowset results in Advantage OLE DB Provider
OLE DB/ADO conformance level in Advantage OLE DB Provider
timeouts in Advantage OLE DB Provider
transactions in Advantage OLE DB Provider
UPDATE
Advantage .NET Data Provider
Advantage SQL Engine
SQL execution plan node
Update Modes
in Advantage OLE DB Provider
Update Operations
database stability
limitations using local server
multi-user performance
referential itegrity
SQL
Update Rules
UPDATE Statements Using Indexes
UpdateCommand
Advantage .NET Data Provider
Updated Advantage Data Architect
Updated Crystal Report Driver
UpdatedRowSource
Advantage .NET Data Provider
Updating Records
upgrade
Upgrades
Advantage Data Dictionary
Upgrading
UPPER()
Advantage SQL string functions
AOF optimization
expression engine function
how indexes are used by the WHERE clause
indexes with expressions
scalar functions in a WHERE clause
UPPERW()
expression engine function
URL Format for Driver Manager in JDBC
Usage Information
Use Clustering
Advantage configuration parameter
Use Dynamic Cursors
Advantage configuration parameter
Use Other Database Tables
Use Semaphore Files
Advantage configuration parameter
Use the Advantage Local Server
Use the Advantage ODBC Driver
Use Views
USE_LOW_LOCK_OFFSETS
USE_SEMAPHORE_FILES
NLM configuration file
UsePKOnlyInWhereClause
Advantage .NET Data Provider
USER
error string
SQL scalar function
user count
TAdsConnection.MiddleTierConnection property
User Datagram Protocol
USER DEFINED FUNCTION
User Defined Functions
Advantage Data Architect
creating or modifying a package
creating or modifying in Advantage Data Architect
deleting a package
deleting in Advantage Data Architect
User ID
Advantage .NET Data Provider
User Information
Advantage management utility
User Options
NLM configuration file
NLM screen
Number of Connections configuration parameter
system requirements
User Permissions
Advantage Data Dictionary
effective vs explicit
User String Property in JDBC
User/group
User-Defined Functions
UserGroups
Advantage TDataSet Descendant
UserGroupsString
Advantage TDataSet Descendant
UserName
TAdsConnection.Username
TAdsDictionary.Username
UseRowversionOnlyInWhereClause
Advantage .NET Data Provider
Users
adding/removing to/from groups in Advantage Data Architect
creating or modifying in Advantage Data Architect
deleting in Advantage Data Architect
enabling Internet access on a per user basis
Internet security levels
rights in Advantage Data Architect
setting permissions in Advantage Data Architect
users attempt
login
Users/Connections
NLM screen
Using a Parameterized Query
Using Access Rights
Using Advantage
Using Cursors
Using Data Dictionaries
Using Field-Level Constraints
Using Parameterized Queries
Using RDDSetDefault to Specify the Advantage RDD
Using Record-Level Constraints
Using Referential Integrity
Using SQL Script to Write Stored Procedures
Using SQL to Access Management Information
Using SQL to Manage Tables
Using SQL to Modify Data Dictionaries
Using SQL to Perform Common Database Operations
Using SQL to Retrieve Metadata
Using Stored Procedures
Using Subqueries
Using Transactions
Using Triggers
UTF16
UTF-16LE
Utilities
Advantage Configuration Utility for Windows
Advantage Data Architect with OLE DB Provider
Advantage Environment Check Utility in Advantage Data Architect
Advantage Management Utility
Advantage Management Utility in Advantage Data Architect
Advantage NLM Management Utility for NetWare
disabling database logins
Native SQL Utility in Advantage Data Architect
non-Advantage troubleshooting tools list
SQL Debugger
- V -
VAL()
expression engine function
Valid Field Types
for full text search indexes
Validation Code
installing the Advantage Database Server for Linux
installing the Advantage Database Server Service for Windows
installling the Advantage Database Server NLM for NetWare
Value
Advantage .NET Data Provider
Variable
VB
VB.NET
VerifySQL
Advantage TDataSet Descendant
Version
Advantage TDataSet Descendant
Version Checking
Version comparison
Advantage Extended Procedures
VIEW
reserved keyword in Advantage SQL engine
Viewing
communication statistics in Advantage Data Architect
configuration parameters affecting memory in Advantage Data Architect
configuration parameters not affecting memory in Advantage Data Architect
connected users in Advantage Data Architect
Database Activity Information in Advantage Data Architect
installation information for Advantage Data Architect
open files in Advantage Data Architect
Viewing Active Queries
Views
adding tables to the ER view with Advantage Data Architect
creating or modifying in the Advantage Data Architect
deleting in Advantage Data Architect
in Advantage OLE DB Provider
in SQL
manually refreshing current view in Advantage Data Architect
properties in Advantage OLE DB Provider
supported object interfaces in Advantage OLE DB Provider
Virtual Tables
Visibility of data updates
Visit
Visual C
creating an Advantage Extended Procedure
Visual FoxPro
Cursor Adapters
Getting Started
Remote Views
SQL Pass Through
Visual Objects
- W -
WaitCursor
Advantage TDataSet Descendant
TAdsStoredProc.WaitCursor
Watch Dog
Web Assist
Web server
Web Support
WEEK
week number
What s New in Advantage
8.0
8.1
What s New in Advantage 9.0
WHEN
reserved keyword in Advantage SQL engine
When to Make Direct Calls to the Advantage Client Engine
WHERE
WHERE Clause
how indexes are used by the WHERE clause
scalar functions
WHILE
Why Create Indexes
WIN.INI
Windows registry
Windows
Advantage
Advantage configuration
Advantage ODBC Driver installation
communication issues with the Advantage Database Server
data source entries in ODBC
data source setup in ODBC
installing the Advantage Database Server service
Native SQL Utility in Advantage Data Architect
ODBC file locations for distribution
redistributing Advantage Data Architect
registry
troubleshooting
Windows 2000/2003
Windows Cluster
installing and running the Advantage Database Server
Windows Installation Notes
Windows NT 2000/2003
startup parameters
Windows NT 4.0
Windows NT/2000/2003
uninstalling
Windows Server OS Errors
WINNT
Work Areas
NLM configuration file
Number of Tables configuration parameter
Number of Work Areas configuration parameter
worker thread
Worker Threads
Express Queue
Number of Worker Threads configuration parameter
Workstation Configuration
for IP
for IPX
overview
Workstation crashes
elimination with Advantage Transaction Processing
limitations using local server
Write Locking
general performance factors
multi-user performance
performance information
proprietary locking
Write Rights
in Advantage Data Architect
WriteRecord
Advantage .NET Data Provider
Writing Code
for Advantage CA-Visual Objects RDD
Writing Data
Writing SQL Scripts
Writing Stored Procedures
Writing Triggers
- X -
Xbase
Advantage compatibility locking
Candidate Indexes
conditional indexes
DBF field types and specifications
deleted records
file format specifications
index files -- CDX: IDX: NTX
memo files -- DBT: FPT
table -- DBF
unique indexes
Xbase Candidate Indexes
Xbase DBF
Xbase File Format
supported in Advantage Client Engine
topics list
Xbase File Format Specifications
Xbase File Types
Xbase Files
Advantage compatibility locking
Advantage file formats overview
index order
performance information
preference to use the record deletion status as a filter
sharing data with non-Advantage applications
Xbase Unique Indexes
index order
overview
unpredictable results with TPS
XOR
- Y -
YEAR()
expression engine function
YYYY-DD-MM
YYYY-MM-DD
YYYY-MM-DD HH
- Z -
Zap
Advantage TPS error conditions
performance factors in non-client/server environment
ZapTable
Advantage .NET Data Provider
|