Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - .NET Programming » UltraLite .NET 2.0 API Reference

 

ULSQLCode enumeration

UL Ext.: Enumerates the SQL codes that may be reported by UltraLite.NET.

Syntax
Visual Basic

Public Enum ULSQLCode 
C#

public enum ULSQLCode 
Members
Member name Description Value

SQLE_AGGREGATES_NOT_ALLOWED

See Invalid use of an aggregate function.

-150

SQLE_ALIAS_NOT_UNIQUE

See Alias '%1' is not unique.

-830

SQLE_ALIAS_NOT_YET_DEFINED

See Definition for alias '%1' must appear before its first reference.

-831

SQLE_AMBIGUOUS_INDEX_NAME

See Index name '%1' is ambiguous.

-678

SQLE_ARGUMENT_CANNOT_BE_NULL

See Argument %1 of procedure '%2' cannot be NULL.

-90

SQLE_BAD_ENCRYPTION_KEY

See Incorrect or missing encryption key.

-840

SQLE_BAD_PARAM_INDEX

See Input parameter index out of range.

-689

SQLE_CANNOT_ACCESS_FILE

See Cannot access file '%1' -- %2.

-602

SQLE_CANNOT_ACCESS_FILESYSTEM

See Unable to access the filesystem on the device.

-1108

SQLE_CANNOT_ACCESS_SCHEMA_FILE

See Cannot access schema file '%1'.

-951

SQLE_CANNOT_CHANGE_ML_REMOTE_ID

See Cannot change the MobiLink remote id when the status of the last upload is unknown.

-1118

SQLE_CANNOT_EXECUTE_STMT

See Statement cannot be executed.

111

SQLE_CANNOT_MODIFY

See Cannot modify column '%1' in table '%2'.

-191

SQLE_CANNOT_OPEN_LOG

See Cannot open transaction log file -- %1.

-106

SQLE_CANNOT_REGISTER_LISTENER

See The specified listener could not be registered.

-992

SQLE_CLIENT_OUT_OF_MEMORY

See Client out of memory.

-876

SQLE_COLUMN_AMBIGUOUS

See Column '%1' found in more than one table -- need a correlation name.

-144

SQLE_COLUMN_CANNOT_BE_NULL

See Column '%1' in table '%2' cannot be NULL.

-195

SQLE_COLUMN_IN_INDEX

See Cannot alter a column in an index.

-127

SQLE_COLUMN_NOT_FOUND

See Column '%1' not found.

-143

SQLE_COLUMN_NOT_INDEXED

See Column '%1' not part of any indexes in its containing table.

-1101

SQLE_COLUMN_NOT_STREAMABLE

See The operation failed because column '%1''s type does not support streaming.

-1100

SQLE_COMMUNICATIONS_ERROR

See Communication error.

-85

SQLE_CONNECTION_ALREADY_EXISTS

See This connection already exists.

-955

SQLE_CONNECTION_NOT_FOUND

See Connection not found.

-108

SQLE_CONNECTION_RESTORED

See UltraLite connection was restored.

133

SQLE_CONSTRAINT_NOT_FOUND

See Constraint '%1' not found.

-929

SQLE_CONVERSION_ERROR

See Cannot convert %1 to a %2.

-157

SQLE_CORRUPT_ULTRALITE_DATABASE

See Database page validation failed with code: %1.

-1186

SQLE_CORRUPT_ULTRALITE_INDEX

See Index validation failed for table %1, index %2 with code: %3.

-1185

SQLE_COULD_NOT_FIND_FUNCTION

See Could not find '%1' in dynamic library '%2'.

-621

SQLE_COULD_NOT_LOAD_LIBRARY

See Could not load dynamic library '%1'.

-620

SQLE_CURSOR_ALREADY_OPEN

See Cursor already open.

-172

SQLE_CURSOR_NOT_DECLARED

See Cursor has not been declared.

-170

SQLE_CURSOR_NOT_OPEN

See Cursor not open.

-180

SQLE_CURSOR_RESTORED

See UltraLite cursor (or result set or table) was restored.

134

SQLE_CURSOROP_NOT_ALLOWED

See Illegal cursor operation attempt.

-187

SQLE_DATABASE_ERROR

See Internal database error %1 -- transaction rolled back.

-301

SQLE_DATABASE_NAME_REQUIRED

See Database name required to start server.

-87

SQLE_DATABASE_NOT_CREATED

See Database creation failed: %1.

-645

SQLE_DATABASE_STATE_RESTORED

See UltraLite database state was restored.

142

SQLE_DATATYPE_NOT_ALLOWED

See Expression has unsupported data type.

-624

SQLE_DBSPACE_FULL

See A dbspace has reached its maximum file size.

-604

SQLE_DESCRIBE_NONSELECT

See Can only describe a SELECT statement.

-160

SQLE_DEVICE_ERROR

See I/O error %1 -- transaction rolled back.

-305

SQLE_DEVICE_IO_FAILED

See File I/O failed for '%1'.

-974

SQLE_DIV_ZERO_ERROR

See Division by zero.

-628

SQLE_DOWNLOAD_CONFLICT

See Download failed because of conflicts with existing rows.

-839

SQLE_DOWNLOAD_RESTART_FAILED

See Unable to retry download because upload is not finished.

-1102

SQLE_DROP_DATABASE_FAILED

See An attempt to delete database '%1' failed.

-651

SQLE_DUPLICATE_CURSOR_NAME

See The cursor name '%1' already exists.

-683

SQLE_DUPLICATE_FOREIGN_KEY

See Foreign key '%1' for table '%2' duplicates an existing foreign key.

-251

SQLE_DUPLICATE_OPTION

See Option '%1' specified more than once.

139

SQLE_DYNAMIC_MEMORY_EXHAUSTED

See Dynamic memory exhausted.

-78

SQLE_ENCRYPTION_INITIALIZATION_FAILED

See Could not initialize the encryption DLL: '%1'.

-984

SQLE_ENCRYPTION_NOT_ENABLED

See Encryption has not been enabled.

-1143

SQLE_ENCRYPTION_NOT_ENABLED_WARNING

See Encryption has not been enabled.

140

SQLE_ENGINE_ALREADY_RUNNING

See Database server already running.

-96

SQLE_ERROR

See Run time SQL error -- %1.

-300

SQLE_ERROR_CALLING_FUNCTION

See Could not allocate resources to call external function.

-622

SQLE_ERROR_IN_ASSIGNMENT

See Error in assignment.

-641

SQLE_EXPRESSION_ERROR

See Invalid expression near '%1'.

-156

SQLE_FEATURE_NOT_ENABLED

See The method you attempted to invoke was not enabled for your application.

-1092

SQLE_FILE_BAD_DB

See Unable to start specified database: '%1' is not a valid database file.

-1006

SQLE_FILE_IN_USE

See Specified database file already in use.

-816

SQLE_FILE_NOT_DB

See Unable to start specified database: '%1' is not a database.

-1004

SQLE_FILE_VOLUME_NOT_FOUND

See Specified file system volume not found for database '%1'.

-1112

SQLE_FILE_WRONG_VERSION

See Unable to start specified database: '%1' was created by a different version of the software.

-1005

SQLE_FOREIGN_KEY_NAME_NOT_FOUND

See Foreign key name '%1' not found.

-145

SQLE_IDENTIFIER_TOO_LONG

See Identifier '%1' too long.

-250

SQLE_INCORRECT_VOLUME_ID

See Incorrect volume ID for '%1'.

-975

SQLE_INDEX_NAME_NOT_UNIQUE

See Index name '%1' not unique.

-111

SQLE_INDEX_NOT_FOUND

See Cannot find index named '%1'.

-183

SQLE_INDEX_NOT_UNIQUE

See Index '%1' for table '%2' would not be unique.

-196

SQLE_INTERRUPTED

See Statement interrupted by user.

-299

SQLE_INVALID_CONSTRAINT_REF

See Invalid reference to or operation on constraint '%1'.

-937

SQLE_INVALID_DESCRIPTOR_INDEX

See Invalid descriptor index.

-640

SQLE_INVALID_DESCRIPTOR_NAME

See Invalid SQL descriptor name.

-642

SQLE_INVALID_DISTINCT_AGGREGATE

See Grouped query contains more than one distinct aggregate function.

-863

SQLE_INVALID_FOREIGN_KEY

See No primary key value for foreign key '%1' in table '%2'.

-194

SQLE_INVALID_FOREIGN_KEY_DEF

See Column '%1' in foreign key has a different definition than primary key.

-113

SQLE_INVALID_GROUP_SELECT

See Function or column reference to '%1' must also appear in a GROUP BY.

-149

SQLE_INVALID_INDEX_TYPE

See Index type specification of '%1' is invalid.

-650

SQLE_INVALID_LOGON

See Invalid user ID or password.

-103

SQLE_INVALID_OPTION

See Invalid option '%1' -- no PUBLIC setting exists.

-200

SQLE_INVALID_OPTION_SETTING

See Invalid setting for option '%1'.

-201

SQLE_INVALID_OPTION_VALUE

See '%1' is an invalid value for '%2'.

-1053

SQLE_INVALID_ORDER

See Invalid ORDER BY specification.

-152

SQLE_INVALID_PARAMETER

See Invalid parameter.

-735

SQLE_INVALID_PARSE_PARAMETER

See Parse error: %1.

-95

SQLE_INVALID_SQL_IDENTIFIER

See Invalid SQL identifier.

-760

SQLE_INVALID_STATEMENT

See Invalid statement.

-130

SQLE_INVALID_UNION

See Select lists in UNION, INTERSECT, or EXCEPT do not match in length.

-153

SQLE_KEYLESS_ENCRYPTION

See Unable to perform requested operation since this database uses keyless encryption.

-1109

SQLE_LOCKED

See User '%1' has the row in '%2' locked.

-210

SQLE_MAX_ROW_SIZE_EXCEEDED

See Maximum row size for table '%1' would be exceeded.

-1132

SQLE_MEMORY_ERROR

See Memory error -- transaction rolled back.

-309

SQLE_METHOD_CANNOT_BE_CALLED

See Method '%1' cannot be called at this time.

-669

SQLE_MIRROR_FILE_MISMATCH

See The mirror '%1' does not match database '%2'.

-1138

SQLE_NAME_NOT_UNIQUE

See Item '%1' already exists.

-110

SQLE_NO_COLUMN_NAME

See Derived table '%1' has no name for column %2.

-163

SQLE_NO_CURRENT_ROW

See No current row of cursor.

-197

SQLE_NO_INDICATOR

See No indicator variable provided for NULL result.

-181

SQLE_NO_MATCHING_SELECT_ITEM

See The select list for the derived table '%1' has no expression to match '%2'.

-812

SQLE_NO_PRIMARY_KEY

See Table '%1' has no primary key.

-118

SQLE_NOERROR

SQLE_NOERROR(0) - This code indicates that there was no error or warning.

0

SQLE_NON_UPDATEABLE_COLUMN

See Cannot update an expression.

-190

SQLE_NON_UPDATEABLE_CURSOR

See FOR UPDATE has been incorrectly specified for a READ ONLY cursor.

-813

SQLE_NOT_IMPLEMENTED

See Feature '%1' not implemented.

-134

SQLE_NOT_SUPPORTED_IN_ULTRALITE

See Feature not available with UltraLite.

-749

SQLE_NOTFOUND

See Row not found.

100

SQLE_ONLY_ONE_TABLE

See INSERT/DELETE on cursor can modify only one table.

-199

SQLE_OVERFLOW_ERROR

See Value %1 out of range for destination.

-158

SQLE_PAGE_SIZE_INVALID

See Invalid database page size.

-644

SQLE_PARTIAL_DOWNLOAD_NOT_FOUND

See No partial download was found.

-1103

SQLE_PASSTHROUGH_SQL_SCRIPT_FAILED_E

See Passthrough SQL script failed.

-1238

SQLE_PASSTHROUGH_SQL_SCRIPT_FAILED_W

See Passthrough SQL script failed.

141

SQLE_PERMISSION_DENIED

See Permission denied: %1.

-121

SQLE_PRIMARY_KEY_NOT_UNIQUE

See Primary key for table '%1' is not unique : Primary key value ('%2').

-193

SQLE_PRIMARY_KEY_TWICE

See Table cannot have two primary keys.

-126

SQLE_PRIMARY_KEY_VALUE_REF

See Primary key for row in table '%1' is referenced by foreign key '%2' in table '%3'.

-198

SQLE_PUBLICATION_NOT_FOUND

See Publication '%1' not found.

-280

SQLE_PUBLICATION_PREDICATE_IGNORED

See Publication predicates were not evaluated.

138

SQLE_RESOURCE_GOVERNOR_EXCEEDED

See Resource governor for '%1' exceeded.

-685

SQLE_ROW_DELETED_TO_MAINTAIN_REFERENTIAL_INTEGRITY

See Row was dropped from table %1 to maintain referential integrity.

137

SQLE_ROW_DROPPED_DURING_SCHEMA_UPGRADE

See A row was dropped because it could not be converted to the new schema format.

130

SQLE_ROW_EXCEEDS_PAGE_SIZE

See A row cannot be stored because it exceeds the database page size.

-1117

SQLE_ROW_UPDATED_SINCE_READ

See Row has changed since last read -- operation canceled.

-208

SQLE_SCHEMA_UPGRADE_NOT_ALLOWED

See A schema upgrade is not currently allowed.

-953

SQLE_SERVER_SYNCHRONIZATION_ERROR

See Synchronization failed due to an error on the server: %1.

-857

SQLE_START_STOP_DATABASE_DENIED

See Request to start/stop database denied.

-75

SQLE_STATEMENT_ERROR

See SQL statement error.

-132

SQLE_STRING_RIGHT_TRUNCATION

See Right truncation of string data.

-638

SQLE_SUBQUERY_RESULT_NOT_UNIQUE

See Subquery cannot return more than one row.

-186

SQLE_SUBQUERY_SELECT_LIST

See Subquery allowed only one select list item.

-151

SQLE_SYNC_INFO_INVALID

See Information for synchronization is incomplete or invalid, check '%1'.

-956

SQLE_SYNC_INFO_REQUIRED

See Information for synchronization was not provided.

-1111

SQLE_SYNC_NOT_REENTRANT

See Synchronization process was unable to re-enter synchronization.

-1110

SQLE_SYNC_PROFILE_INVALID

See Synchronization profile '%1' has invalid parameter '%2'.

-1224

SQLE_SYNC_PROFILE_NOT_FOUND

See Synchronization profile '%1' not found.

-1217

SQLE_SYNC_STATUS_UNKNOWN

See The status of the last synchronization upload is unknown.

-952

SQLE_SYNTAX_ERROR

See Syntax error near '%1' %2.

-131

SQLE_TABLE_ALREADY_INCLUDED

See Table '%1' is already included.

-822

SQLE_TABLE_HAS_PUBLICATIONS

See Table '%1' has publications.

-281

SQLE_TABLE_IN_USE

See Table in use.

-214

SQLE_TABLE_NOT_FOUND

See Table '%1' not found.

-141

SQLE_TOO_MANY_BLOB_REFS

See Too many references to a BLOB.

-1107

SQLE_TOO_MANY_CONNECTIONS

See Database server connection limit exceeded.

-102

SQLE_TOO_MANY_CURSORS

See Too many open cursors.

-1230

SQLE_TOO_MANY_PUBLICATIONS

See Too many publications specified for operation.

-1106

SQLE_TOO_MANY_TEMP_TABLES

See Too many temporary tables in connection.

-817

SQLE_TOO_MANY_USERS

See Too many users in database.

-1104

SQLE_TRUNCATED

See Value truncated.

101

SQLE_ULTRALITE_DATABASE_NOT_FOUND

See The database '%1' was not found.

-954

SQLE_ULTRALITE_OBJ_CLOSED

See Invalid operation on a closed object.

-908

SQLE_UNABLE_TO_CONNECT

See Database cannot be started -- %1.

-105

SQLE_UNABLE_TO_START_DATABASE

See Unable to start specified database: %1.

-82

SQLE_UNABLE_TO_START_DATABASE_VER_NEWER

See Unable to start specified database: Server must be upgraded to start database %1.

-934

SQLE_UNKNOWN_FUNC

See Unknown function '%1'.

-148

SQLE_UNKNOWN_OPTION

See '%1' is an unknown option.

120

SQLE_UNKNOWN_USERID

See User ID '%1' does not exist.

-140

SQLE_UNRECOGNIZED_OPTION

See The option '%1' is not recognized.

-1002

SQLE_UPLOAD_FAILED_AT_SERVER

See Synchronization server failed to commit the upload.

-794

SQLE_VALUE_IS_NULL

See Cannot return NULL result as requested data type.

-1050

SQLE_VARIABLE_INVALID

See Invalid host variable.

-155

SQLE_WRONG_NUM_OF_INSERT_COLS

See Wrong number of values for INSERT.

-207

SQLE_WRONG_PARAMETER_COUNT

See Wrong number of parameters to function '%1'.

-154