A B C D E F G H I J K L M N
O P Q R S T U V W X Y Z

- -

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