Difference between revisions of "Error Messages: SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 20: | Line 20: | ||
|5007||Keyword PRECISION was expected | |5007||Keyword PRECISION was expected | ||
|- | |- | ||
| − | |5008||Cannot create table <table name> | + | |5008||Cannot create table <nowiki><table name></nowiki> |
|- | |- | ||
|5009||Invalid table specification | |5009||Invalid table specification | ||
|- | |- | ||
| − | |5010||Cannot open table <table name> | + | |5010||Cannot open table <nowiki><table name></nowiki> |
|- | |- | ||
|5011||Keyword TABLE expected | |5011||Keyword TABLE expected | ||
Latest revision as of 10:42, 13 March 2009
Recital/SQL Error Messages
| ERROR() | Error Message |
|---|---|
| 5000 | Unrecognized phrase/keyword near column <expN> |
| 5001 | Table name was expected |
| 5002 | Column name was expected |
| 5003 | Column name already exists |
| 5004 | Data type was expected |
| 5005 | Unrecognized data type for column <column name> |
| 5006 | Invalid specification for column <column name> |
| 5007 | Keyword PRECISION was expected |
| 5008 | Cannot create table <table name> |
| 5009 | Invalid table specification |
| 5010 | Cannot open table <table name> |
| 5011 | Keyword TABLE expected |
| 5012 | Keyword ADD expected |
| 5013 | <command expression> - operation aborted |
| 5014 | Keyword INTO expected |
| 5015 | Keyword VALUES expected |
| 5016 | Keyword SQL expected |
| 5017 | Keyword FROM expected |
| 5018 | ’=’ expected |
| 5019 | Keyword SET expected |
| 5020 | Keyword INDEX expected |
| 5021 | Index name expected |
| 5022 | Keyword ON expected |
| 5023 | Keyword BY expected |
| 5024 | Keyword UPDATE expected |
| 5025 | FROM clause missing |
| 5026 | Bad ORDER BY clause |
| 5027 | Bad GROUP BY clause |
| 5028 | Cursor name was expected |
| 5029 | Cursor already declared |
| 5030 | Keyword CURSOR was expected |
| 5031 | Keyword FOR was expected |
| 5032 | Too many cursors declared |
| 5033 | Cursor is not open |
| 5034 | Cursor not declared |
| 5035 | Cursor is already open |
| 5036 | INTO list does not match SELECT list |
| 5037 | Specified cursor is not updateable |
| 5038 | Keyword TO expected |
| 5039 | No CURRENT record |
| 5040 | Exclusive tables cannot be locked |
| 5041 | Keyword SHARE or EXCLUSIVE expected |
| 5042 | Keyword MODE expected |
| 5043 | Keyword IN expected |
| 5044 | Keyword SELECT expected |
| 5045 | Keyword JOIN expected |
| 5046 | Invalid join expression |
| 5047 | Operation not supported on a VIEW |
| 5048 | View not declared |
| 5049 | VIEW already declared |
| 5050 | View name was expected |
| 5051 | Column ’<column name>’ not found |
| 5052 | Table privilege expected |
| 5053 | User name was expected |
| 5054 | User name <user name> was not found |
