SQL error detail messages, ids, and arguments

The SQLError class represents various errors that can occur while working with an Adobe AIR local SQL database. For any given exception, the SQLError instance has a details property containing an English error message. In addition, each error message has an associated unique identifier that is available in the SQLError object’s detailID property. Using the detailID property, an application can identify the specific details error message. The application can provide alternate text for the end user in the language of his or her locale. The argument values in the detailArguments array can be substituted in the appropriate position in the error message string. This is useful for applications that display the details property error message for an error directly to end users in a specific locale.

The following table contains a list of the detailID values and the associated English error message text. Placeholder text in the messages indicates where detailArguments values are substituted in by the runtime. This list can be used as a source for localizing the error messages that can occur in SQL database operations.

SQLError detailID

English error detail message and parameters

1001

Connection closed.

1102

Database must be open to perform this operation.

1003

%s [,|and %s] parameter name(s) found in parameters property but not in the SQL specified.

1004

Mismatch in parameter count. Found %d in SQL specified and %d value(s) set in parameters property. Expecting values for %s [,|and %s].

1005

Auto compact could not be turned on.

1006

The pageSize value could not be set.

1007

The schema object with name '%s' of type '%s' in database '%s' was not found.

1008

The schema object with name '%s' in database '%s' was not found.

1009

No schema objects with type '%s' in database '%s' were found.

1010

No schema objects in database '%s' were found.

2001

Parser stack overflow.

2002

Too many arguments on function '%s'

2003

near '%s': syntax error

2004

there is already another table or index with this name: '%s'

2005

PRAGMA is not allowed in SQL.

2006

Not a writable directory.

2007

Unknown or unsupported join type: '%s %s %s'

2008

RIGHT and FULL OUTER JOINs are not currently supported.

2009

A NATURAL join may not have an ON or USING clause.

2010

Cannot have both ON and USING clauses in the same join.

2011

Cannot join using column '%s' - column not present in both tables.

2012

Only a single result allowed for a SELECT that is part of an expression.

2013

No such table: '[%s.]%s'

2014

No tables specified.

2015

Too many columns in result set|too many columns on '%s'.

2016

%s ORDER|GROUP BY term out of range - should be between 1 and %d

2017

Too many terms in ORDER BY clause.

2018

%s ORDER BY term out of range - should be between 1 and %d.

2019

%r ORDER BY term does not match any column in the result set.

2020

ORDER BY clause should come after '%s' not before.

2021

LIMIT clause should come after '%s' not before.

2022

SELECTs to the left and right of '%s' do not have the same number of result columns.

2023

A GROUP BY clause is required before HAVING.

2024

Aggregate functions are not allowed in the GROUP BY clause.

2025

DISTINCT in aggregate must be followed by an expression.

2026

Too many terms in compound SELECT.

2027

Too many terms in ORDER|GROUP BY clause

2028

Temporary trigger may not have qualified name

2030

Trigger '%s' already exists

2032

Cannot create BEFORE|AFTER trigger on view: '%s'.

2033

Cannot create INSTEAD OF trigger on table: '%s'.

2034

No such trigger: '%s'

2035

Recursive triggers not supported ('%s').

2036

No such column: %s[.%s[.%s]]

2037

VACUUM is not allowed from SQL.

2043

Table '%s': indexing function returned an invalid plan.

2044

At most %d tables in a join.

2046

Cannot add a PRIMARY KEY column.

2047

Cannot add a UNIQUE column.

2048

Cannot add a NOT NULL column with default value NULL.

2049

Cannot add a column with non-constant default.

2050

Cannot add a column to a view.

2051

ANALYZE is not allowed in SQL.

2052

Invalid name: '%s'

2053

ATTACH is not allowed from SQL.

2054

%s '%s' cannot reference objects in database '%s'

2055

Access to '[%s.]%s.%s' is prohibited.

2056

Not authorized.

2058

No such view: '[%s.]%s'

2060

Temporary table name must be unqualified.

2061

Table '%s' already exists.

2062

There is already an index named: '%s'

2064

Duplicate column name: '%s'

2065

Table '%s' has more than one primary key.

2066

AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY

2067

No such collation sequence: '%s'

2068

Parameters are not allowed in views.

2069

View '%s' is circularly defined.

2070

Table '%s' may not be dropped.

2071

Use DROP VIEW to delete view '%s'

2072

Use DROP TABLE to delete table '%s'

2073

Foreign key on '%s' should reference only one column of table '%s'

2074

Number of columns in foreign key does not match the number of columns in the referenced table.

2075

Unknown column '%s' in foreign key definition.

2076

Table '%s' may not be indexed.

2077

Views may not be indexed.

2080

Conflicting ON CONFLICT clauses specified.

2081

No such index: '%s'

2082

Index associated with UNIQUE or PRIMARY KEY constraint cannot be dropped.

2083

BEGIN is not allowed in SQL.

2084

COMMIT is not allowed in SQL.

2085

ROLLBACK is not allowed in SQL.

2086

Unable to open a temporary database file for storing temporary tables.

2087

Unable to identify the object to be reindexed.

2088

Table '%s' may not be modified.

2089

Cannot modify '%s' because it is a view.

2090

Variable number must be between ?0 and ?%d<

2092

Misuse of aliased aggregate '%s'

2093

Ambiguous column name: '[%s.[%s.]]%s'

2094

No such function: '%s'

2095

Wrong number of arguments to function '%s'

2096

Subqueries prohibited in CHECK constraints.

2097

Parameters prohibited in CHECK constraints.

2098

Expression tree is too large (maximum depth %d)

2099

RAISE() may only be used within a trigger-program

2100

Table '%s' has %d columns but %d values were supplied

2101

Database schema is locked: '%s'

2102

Statement too long.

2103

Unable to delete/modify collation sequence due to active statements

2104

Too many attached databases - max %d

2105

Cannot ATTACH database within transaction.

2106

Database '%s' is already in use.

2108

Attached databases must use the same text encoding as main database.

2200

Out of memory.

2201

Unable to open database.

2202

Cannot DETACH database within transaction.

2203

Cannot detach database: '%s'

2204

Database '%s' is locked.

2205

Unable to acquire a read lock on the database.

2206

[column|columns] '%s'[,'%s'] are not [unique|is] not unique.

2207

Malformed database schema.

2208

Unsupported file format.

2209

Unrecognized token: '%s'

2300

Could not convert text value to numeric value.

2301

Could not convert string value to date.

2302

Could not convert floating point value to integer without loss of data.

2303

Cannot rollback transaction - SQL statements in progress.

2304

Cannot commit transaction - SQL statements in progress.

2305

Database table is locked: '%s'

2306

Read-only table.

2307

String or blob too big.

2309

Cannot open indexed column for writing.

2400

Cannot open value of type %s.

2401

No such rowid: %s<

2402

Object name reserved for internal use: '%s'

2403

View '%s' may not be altered.

2404

Default value of column '%s' is not constant.

2405

Not authorized to use function '%s'

2406

Misuse of aggregate function '%s'

2407

Misuse of aggregate: '%s'

2408

No such database: '%s'

2409

Table '%s' has no column named '%s'

2501

No such module: '%s'

2508

No such savepoint: '%s'

2510

Cannot rollback - no transaction is active.

2511

Cannot commit - no transaction is active.

// Ethnio survey code removed