Click above to get retro games delivered to your door ever month!

    0 Successful operation
    1 BTRIEVE status 1: Invalid Operation
    2 BTRIEVE status 2: I/O Error
    3 BTRIEVE status 3: No Open
    4 BTRIEVE status 4: Key not found
    5 BTRIEVE status 5: Duplicates Error
    6 BTRIEVE status 6: Invalid key number
    7 BTRIEVE status 7: Different Key number
    8 BTRIEVE status 8: Invalid Positioning
    9 BTRIEVE status 9: End of file
   10 BTRIEVE status 10: Modifiable error
   11 BTRIEVE status 11: Invalid File Name
   12 BTRIEVE status 12: File not found
   13 BTRIEVE status 13: Extension error
   14 BTRIEVE status 14: The pre-image file could not be created/opened
   15 BTRIEVE status 15: I/O error during the pre-imaging function
   16 BTRIEVE status 16: Expansion error
   17 BTRIEVE status 17: Close Error
   18 BTRIEVE status 18: Disk full
   19 BTRIEVE status 19: Unrecoverable Error
   20 BTRIEVE is not loaded
   21 BTRIEVE status 21: Key buffer error
   22 BTRIEVE status 22: Record buffer length too small
   23 BTRIEVE status 23: Position block is not 128 bytes long
   24 BTRIEVE status 24: Page size error
   25 BTRIEVE status 25: Create I/O error
   26 BTRIEVE status 26: Number of keys
   27 BTRIEVE status 27: Key position
   28 BTRIEVE status 28: Record length is greater than page size minus 6
   29 BTRIEVE status 29: Key length
   30 BTRIEVE status 30: File name specified is not a valid Btrieve file
   31 BTRIEVE status 31: File name specified is already extended
   32 BTRIEVE status 32: Extend I/O error
   34 BTRIEVE status 34: File name for the extended partition is not valid
   35 BTRIEVE status 35: Directory error
   36 BTRIEVE status 36: Transaction error
   37 BTRIEVE status 37: Transaction cannot be nested
   38 BTRIEVE status 38: Transaction control file
   39 BTRIEVE status 39: End/Abort error
   40 BTRIEVE status 40: Transaction Max Files
   41 BTRIEVE status 41: Transaction OPEN/CLOSE
   42 BTRIEVE status 42: Incomplete Accelerated Access
   43 BTRIEVE status 43: Invalid Data Record Address
   44 BTRIEVE status 44: Null Key Path
   45 BTRIEVE status 45: Inconsistent key flags
   46 BTRIEVE status 46: Access Denied
   47 BTRIEVE status 47: Maximum open files
   48 BTRIEVE status 48: Invalid alternate sequence definition
   49 BTRIEVE status 49: Key type error
   50 BTRIEVE status 50: Owner already set
   51 BTRIEVE status 51: Invalid owner
   52 BTRIEVE status 52: Error writing cache
   53 BTRIEVE status 53: Invalid interface
   54 BTRIEVE status 54: Variable page error
   55 BTRIEVE status 55: Autoincrement error
   56 BTRIEVE status 56: Incomplete index
   58 BTRIEVE status 58: Compression buffer is too short
   59 BTRIEVE data file already exists
   80 BTRIEVE status 80: Conflict
   81 BTRIEVE status 81: Lock full
   82 BTRIEVE status 82: Lost position
   83 BTRIEVE status 83: Read outside transaction
   84 BTRIEVE status 84: Record in use
   85 BTRIEVE status 85: File in use
   86 BTRIEVE status 86: File Full
   87 BTRIEVE status 87: Handle Full
   88 BTRIEVE status 88: Mode error
   89 BTRIEVE status 89: Name Error
   90 BTRIEVE status 90: Device Full
   91 BTRIEVE status 91: Server Error
   92 BTRIEVE status 92: Transaction Error
   97 Data buffer too small
   99 BTRIEVE status 99: Demo Error
  101 SET statement completed successfully
  102 Record(s) inserted
  103 Record(s) updated
  104 Record(s) deleted
  105 CREATE statement completed successfully
  106 ALTER statement completed successfully
  107 DROP statement completed successfully
  108 Statement contains variables
  109 No more records
  110 GRANT statement completed successfully
  111 REVOKE statement completed successfully
  112 START TRANSACTION statement completed successfully
  113 COMMIT WORK statement completed successfully
  114 ROLLBACK WORK statement completed successfully
  200 XQL Primitives are not loaded
  201 Invalid XQL primitive function code
  202 Invalid cursor ID
  203 Invalid master password
  204 Table is not defined in the dictionary
  205 Invalid password
  206 Maximum number of cursors has been exceeded
  207 Field does not exist in the dictionary
  208 The position parameter value is out of range for this function
  209 Invalid user or group name specified.
  210 Buffer is not large enough to hold all of the data
  211 Maximum record size has been exceeded. Increase /w parameter.
  212 Maximum index size has been exceeded
  213 Read access error
  214 Cannot change field rights while file has alter rights
  215 Invalid lock flag
  216 Maximum number of fields has been exceeded
  217 A join is not allowed on a view ordered by a user defined sort
  218 A maximum of 8 files may be joined
  219 A maximum of 24 index segments is allowed for a join
  220 No matching indexes on secondary keys
  221 Invalid syntax for expression or restriction
  222 Insufficient memory in XQL Primitives
  223 Invalid data type for expression
  224 Invalid character in numeric data
  225 A maximum of 24 fields is allowed in an ORDER BY or WITH INDEX list
  226 Record count exceeds number of records returned by last xFetch
  227 Operand must be a dictionary field
  228 Invalid data length in buffer
  229 Field already exists in this file definition
  230 Incomplete restriction statement
  231 No fields are defined in the view
  232 Field must be in view
  233 Expression or restriction statement exceeds 1000 bytes
  234 Cannot create external index file
  235 Invalid option for an I/O operation
  236 Cannot update a view with an external index defined
  237 Index descriptor missing must be specified
  238 Supplemental index does not exist
  239 File in the view definition is not in current dictionary
  240 Field in the view definition is not in current dictionary
  241 Cannot update a dictionary file
  242 User does not have write access to this file
  243 User does not have access to update a field
  244 User does not have write access to all fields in this file
  245 Data dictionary file may not be deleted
  246 User does not have file definition or change rights
  247 User does not have access for all of the fields specified
  248 Invalid size for data type
  249 Incompatible field types
  250 Cannot recall view
  251 Error reading VIEW dictionary file
  252 Operation cannot be performed until view.ddf is opened
  253 Incorrect version of stored view definition
  254 Cannot create X$VIEW dictionary file
  255 Field is not a index
  256 Relation must specify at least one file
  257 Dictionary file is already defined
  258 Error updating dictionary file definition
  259 Error inserting new dictionary file definition
  260 Error updating file rights
  261 A variable data type must be defined last in view or file definition
  262 A variable data type field may not be defined as an index
  263 A view may not be sorted by a variable data type field
  264 Cannot modify or remove the master user
  265 Invalid session identifier
  266 Only one session can be active at a time
  267 Only one dictionary can be open at a time
  269 Cannot create X$User dictionary file
  270 Cannot open X$User dictionary file
  271 Cannot create X$Rights dictionary file
  272 Cannot open X$Rights dictionary file
  273 Cannot read or update X$User dictionary file
  274 Unable to assign owner name to physical file
  275 User/Group already exists in the dictionary
  276 User is not the master user
  277 Invalid access rights code
  278 Invalid option
  279 Invalid mask for the data type specified
  281 Attribute is not in the dictionary
  282 Invalid character in data
  283 Invalid range value
  284 Specified value is not in list of valid values
  285 Error opening data dictionary file
  286 Attempt to turn off/on Security when security is already off/on
  287 Data dictionary is not assigned
  288 Data dictionary is in use
  289 Invalid dictionary name
  290 Data dictionary already exists
  291 Data dictionary does not exist in the specified directory
  292 Invalid month number
  293 Invalid day of month
  294 Invalid time range
  295 Invalid open mode
  296 Error opening data file for BTRIEVE STAT function call
  297 Field may not be deleted from the view
  298 Mismatched Quotes
  299 Invalid join index for a 'file:n.field'
  300 Missing operator for conditional, expected '::'
  301 No restriction has been defined
  302 Not a computed field
  303 Cannot update current sort index if more than one file in the view
  304 Cannot change another user's password
  305 View is not found in dictionary
  306 Error occurred while storing view definition
  307 The computed field specified for the join is not in the view
  308 I/O error
  309 Valid owner access codes are 0, 1, 2, and 3
  310 User does not have access to all of the files specified
  311 Transaction processing has not been activated
  312 Transaction was aborted
  313 Transaction processing has already been started
  314 Transaction cannot be initiated -- file recovery required
  315 Cannot change dictionary or data path within a transaction
  317 Dictionary is locked within a transaction by another user
  318 Cannot update view that has been defined in READONLY mode
  319 Value list definition error
  320 Character list definition error
  321 Default value definition error
  322 Range list definition error
  323 Cannot perform specified operation on file in a view
  324 Unbalanced parentheses in restriction or computed field
  325 Total size of fixed length fields must be greater than 3
  326 Stack overflow in XQL Primitives
  327 At least one index must be defined without the NULL attribute
  328 Syntax is invalid for expression using DATE or TIME data type
  329 Invalid number of decimal places
  330 Data is not formatted according to its defined mask
  331 Security group either does not exist or is not empty
  332 Please convert dictionary for use with XQL version 2.xx
  333 Error storing index definitions
  334 Supplemental index names must be unique
  335 Invalid join option
  336 Variable data types cannot be converted using xConvert
  337 Maximum path length has been exceeded
  338 Cannot enable or disable security when other users are logged in
  339 Operation cannot be performed on view containing self-join
  340 A field of type BIT cannot be defined as in index
  341 AUTOINC key must be unique and non-seqmented
  342 Invalid parameter for scalar function
  343 User PUBLIC cannot be removed
  344 DOS Rename function failed.
  345 Computed field names must be unique within a view
  401 Please LOGIN first
  402 Cannot open file containing stored SQL statement
  403 Error recalling the stored SQL statement
  404 Unable to store the SQL statement
  405 File name specified already exists
  406 No files found to Store, Recall or Delete
  407 Invalid file name
  408 Error writing output file
  409 Please ENTER or RECALL an SQL statement first
  410 Unable to SAVE configuration
  411 Unable to open dictionary files.
  412 Insufficient memory in XQLI
  413 Out of DOS file handles
  414 XQLI window width has been exceeded - maximum width is 1024 bytes
  415 Maximum page length cannot exceed 255 lines
  416 Maximum page width cannot exceed 255 characters
  417 Number of lines for SQL statement must be between 1 and 16
  418 Invalid command line parameter
  419 Unmatched quotes in SQL statements
  501 Invalid keyword
  502 Invalid SELECT statement
  503 Invalid function code
  504 Invalid OPEN mode
  505 Each item in the attribute list must be enclosed in quotes
  506 Invalid INSERT statement
  507 Invalid UPDATE statement
  508 Invalid DELETE statement
  509 Invalid SET statement
  510 Can only create a TABLE, VIEW, INDEX, DICTIONARY, or GROUP
  511 Index name is missing
  512 Invalid GRANT statement
  513 User name missing on GRANT/REVOKE
  514 Table name is missing
  515 TABLE keyword should follow ALTER
  516 ADD, MODIFY, or DROP keyword expected
  517 The FROM clause is missing
  518 Sort order follows field name
  519 AS expected
  520 BY expected
  521 Must supply a view name for the CREATE VIEW statement
  522 Unknown keyword
  523 GRANT/REVOKE option is missing
  524 Field list is allowed only on SELECT or UPDATE
  525 Password must be specified for SET SECURITY
  526 Name cannot be a reserved word
  527 Missing user password
  528 Must provide a character enclosed in quotes after the equal sign
  529 Must supply one or more owner names after the equal sign
  530 Must supply a dictionary path after the equal sign
  531 Must supply a data file path after the equal sign
  532 Missing '='
  533 Invalid data type specified
  534 SELECT keyword expected when creating a view
  535 Index attribute expected
  536 Dictionary field name expected
  537 Field name already exists in this definition
  538 Index name is not in the field list
  539 Index is already defined in this definition
  540 Field list expected after SELECT, ORDER BY, or GROUP BY
  541 Restrict text expected after WHERE or HAVING
  542 DICTIONARY, INDEX, TABLE, VIEW, or GROUP keyword expected
  543 Mismatched quotes
  544 Directory path must be specified
  545 INTO keyword expected
  546 Maximum string size is 255 bytes
  547 Attribute list is missing
  548 Invalid syntax: WORK or TRANSACTION keyword expected
  549 ORDER BY clause must be specified last
  550 Alias name has already been defined
  551 Invalid characters for a dictionary name
  552 A SELECT clause must follow a UNION keyword
  553 Name must not exceed 20 characters
  554 Security group name expected
  555 Expected 'IN DICTIONARY' clause
  556 Invalid CREATE parameter
  557 Unable to access alternate collating sequence file
  558 Aggregate value cannot be used in an expression
  575 Stored procedure name expected
  576 Parameter values must be preceded by a parameter name
  800 Insufficient Memory in XQL Manager
  801 Maximum number of cursors has been exceeded
  802 XQL Manager is inactive
  803 Must login first
  804 Invalid position
  805 Invalid size
  806 Invalid number of decimal places
  807 Invalid variable
  808 Unresolved variables
  809 Field in statement is not in the recalled view
  810 Invalid number
  811 Invalid month
  812 Invalid day
  813 Invalid time range
  814 Invalid secondary index
  815 Invalid join field
  816 Field name is not defined in this table
  818 Field must be a group aggregate or in GROUP BY list
  819 Invalid table name
  820 Comparison operator expected in HAVING clause
  821 Invalid cursor id
  822 Data buffer is too small
  823 Sort index must be in the view list
  824 Missing or unbalanced parentheses
  825 Cannot do AVG or SUM on STRING, DATE or TIME data types
  826 Missing or unbalanced parentheses following WHERE clause
  827 GROUP BY field must be in the view list
  828 WHERE clause must be specified last
  829 Invalid syntax for computed field
  830 Operand expected
  831 HAVING clause operand must be a group aggregate or constant
  832 Stored view buffer is inconsistent - cannot be recalled
  833 ORDER BY field must be an index or be specified in the view
  835 Invalid option for XQLStat
  836 Invalid mask for the data type specified
  837 Invalid delimiter separating size and decimal places
  838 Number of fields in all view lists must match
  839 Data type and size must match for corresponding fields
  840 Stack overflow in XQL Manager
  841 Unable to create a temporary file for DISTINCT or ORDER processing
  842 The HAVING clause may not contain a subquery clause
  843 A DOS path must be specified if ADD, MODIFY, or DROP is not entered
  845 The number of headings must match the number of fields in the view
  846 A field name must be specified
  847 Invalid syntax in WHERE clause
  848 A statement may contain only one DISTINCT keyword
  849 Insufficient buffer space for the WHERE clause
  850 Data value cannot be converted to new data type
  851 SELECT statement may not access same files as the INSERT or UPDATE
  852 Record count must be greater than zero
  853 User does not have file access for operation specified
  854 At least one index must be defined for this operation
  855 ALTER TABLE requires two views for data conversion
  856 Number of values cannot exceed number of fields in the view
  857 '= ALL' is invalid syntax
  858 CASE keyword is only allowed on string data types
  859 Field position expected in ORDER BY clause with UNION statements
  860 Application buffer size exceeded.  Cannot store view definition
  861 Field in statement is not in the stored view definition
  862 Stored procedure name is not in the dictionary

      following messages are returned only if operating under OS/2

 2001 Insufficient memory
 2002 Parameter is invalid or out of range
 2003 No local access is allowed
 2004 SPX Installation error
 2005 Incorrect SPX version
 2006 No available connections
 2007 Maximum number of windows for NetWare SQL has been exceeded
 2008 Btrieve version must be 5.0 or later
 2009 File Initialization Error
 2101 SRB buffer is too small
 2102 Maximum redirected devices is exceeded
 2103 Netware SQL is not active or session is closed
 2104 Only one login session is allowed
 2105 Server buffer is too small (/s)
 2106 Server data buffer is too small
 2107 Maximum allowed views has been exceeded
 2108 Device is not mapped to a file server
 2109 File server table is too small
 2110 Could not open server socket