Difference between revisions of "Error Messages: SQL"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
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