version 11
Le moteur SQL de 4D retourne des erreurs spécifiques, listées ci-dessous. Ces erreurs peuvent être interceptées à l'aide d'une méthode gestion d'erreurs installée par la commande APPELER SUR ERREUR et analysées via la commande LIRE PILE DERNIERE ERREUR.
Erreur génériques
1001 | INVALID ARGUMENT |
1002 | INVALID INTERNAL STATE |
1003 | NOT RUNNING |
Erreurs sémantiques
1101 | TABLE DOES NOT EXIST |
1102 | COLUMN DOES NOT EXIST |
1103 | TABLE NOT DECLARED IN FROM CLAUSE |
1104 | AMBIGUOUS COLUMN NAME |
1105 | TABLE ALIAS SAME AS TABLE NAME |
1106 | DUPLICATE TABLE ALIAS |
1107 | DUPLICATE TABLE IN FROM CLAUSE |
1108 | INCOMPATIBLE TYPES |
1109 | INVALID ORDER BY INDEX |
1110 | WRONG AMOUNT OF PARAMETERS |
1111 | INCOMPATIBLE PARAMETER TYPE |
1112 | UNKNOWN FUNCTION |
1113 | DIVISION BY ZERO |
1114 | ORDER BY INDEX NOT ALLOWED |
1115 | DISTINCT NOT ALLOWED |
1116 | NESTED COLUMN FUNCTIONS NOT ALLOWED |
1117 | COLUMN FUNCTIONS NOT ALLOWED |
1118 | CAN NOT MIX COLUMN AND SCALAR OPERATIONS |
1119 | INVALID GROUP BY INDEX |
1120 | GROUP BY INDEX NOT ALLOWED |
1121 | GROUP BY NOT ALLOWED WITH SELECT ALL |
1122 | NOT A COLUMN EXPRESSION |
1123 | NOT A GROUPING COLUMN IN AGGREGATE ORDER BY |
1124 | MIXED LITERAL TYPES IN PREDICATE |
1125 | LIKE ESCAPE IS NOT ONE CHAR |
1126 | BAD LIKE ESCAPE CHAR |
1127 | UNKNOWN ESCAPE SEQUENCE IN LIKE |
1128 | COLUMNS FROM MORE THAN ONE QUERY IN COLUMN FUNCTION |
1129 | SCALAR EXPRESSION WITH GROUP BY |
1130 | SUBQUERY HAS MORE THAN ONE COLUMN |
1131 | SUBQUERY MUST HAVE ONE ROW |
1132 | INSERT VALUE COUNT DOES NOT MATCH COLUMN COUNT |
1133 | DUPLICATE COLUMN IN INSERT |
1134 | COLUMN DOES NOT ALLOW NULLS |
1135 | DUPLICATE COLUMN IN UPDATE |
1136 | TABLE ALREADY EXISTS |
1137 | DUPLICATE COLUMN IN CREATE TABLE |
1138 | DUPLICATE COLUMN IN COLUMN LIST |
1139 | MORE THAN ONE PRIMARY KEY NOT ALLOWED |
1140 | AMBIGUOUS FOREIGN KEY NAME |
1141 | COLUMN COUNT MISMATCH IN FOREIGN KEY |
1142 | COLUMN TYPE MISMATCH IN FOREIGN KEY |
1143 | FAILED TO FIND MATCHING PRIMARY COLUMN |
1144 | UPDATE AND DELETE CONSTRAINTS MUST BE THE SAME |
1145 | FOREIGN KEY DOES NOT EXIST |
1146 | INVALID LIMIT VALUE IN SELECT |
1147 | INVALID OFFSET VALUE IN SELECT |
1148 | PRIMARY KEY DOES NOT EXIST |
1149 | FAILED TO CREATE FOREIGN KEY |
1150 | FIELD IS NOT IN PRIMARY KEY |
1151 | FIELD IS NOT UPDATEABLE |
Erreurs d'mplémentations
1203 | FUNCTIONALITY IS NOT IMPLEMENTED |
1204 | FAILED TO CREATE NEW RECORD |
1205 | FAILED TO UPDATE FIELD |
1206 | FAILED TO DELETE RECORD |
1207 | NO MORE JOIN SEEDS POSSIBLE |
1208 | FAILED TO CREATE TABLE |
1209 | FAILED TO DROP TABLE |
1210 | CANT BUILD BTREE FOR ZERO RECORDS |
1211 | COMMAND COUNT GREATER THAN ALLOWED |
1212 | FAILED TO CREATE DATABASE |
1213 | FAILED TO DROP COLUMN |
1214 | VALUE IS OUT OF BOUNDS |
1215 | FAILED TO STOP SQL_SERVER |
1216 | FAILED TO LOCALIZE |
Erreurs d'analyse
1301 PARSING FAILED
Erreurs d'accès au langage runtime
1401 | COMMAND NOT SPECIFIED |
1402 | ALREADY LOGGED IN |
1403 | SESSION DOES NOT EXIST |
1404 | UNKNOWN BIND ENTITY |
1405 | INCOMPATIBLE BIND ENTITIES |
1406 | REQUEST RESULT NOT AVAILABLE |
1407 | BINDING LOAD FAILED |
1408 | COULD NOT RECOVER FROM PREVIOUS ERRORS |
1409 | NO OPEN STATEMENT |
1410 | RESULT EOF |
1411 | BOUND VALUE IS NULL |
1412 | STATEMENT ALREADY OPENED |
1413 | FAILED TO GET PARAMETER VALUE |
1414 | INCOMPATIBLE PARAMETER ENTITIES |
1415 | PARAMETER VALUE NOT SPECIFIED |
1416 | COLUMN REFERENCE PARAMETERS FROM DIFFERENT TABLES |
1417 | EMPTY STATEMENT |
1418 | FAILED TO UPDATE VARIABLE |
1419 | FAILED TO GET TABLE REFERENCE |
1420 | FAILED TO GET TABLE CONTEXT |
1421 | COLUMNS NOT ALLOWED |
1422 | INVALID COMMAND COUNT |
1423 | INTO CLAUSE NOT ALLOWED |
1424 | EXECUTE IMMEDIATE NOT ALLOWED |
1425 | ARRAY NOT ALLOWED IN EXECUTE IMMEDIATE |
1426 | COLUMN NOT ALLOWED IN EXECUTE IMMEDIATE |
1427 | NESTED BEGIN END SQL NOT ALLOWED |
1428 | RESULT IS NOT A SELECTION |
Erreurs d'analyse de date
1501 | SEPARATOR_EXPECTED |
1502 | FAILED TO PARSE DAY OF MONTH |
1503 | FAILED TO PARSE MONTH |
1504 | FAILED TO PARSE YEAR |
1505 | FAILED TO PARSE HOUR |
1506 | FAILED TO PARSE MINUTE |
1507 | FAILED TO PARSE SECOND |
1508 | FAILED TO PARSE MILLISECOND |
1509 | INVALID AM PM USAGE |
1510 | FAILED TO PARSE TIME ZONE |
1511 | UNEXPECTED CHARACTER |
1512 | FAILED TO PARSE TIMESTAMP |
1513 | FAILED TO PARSE DURATION |
Erreur de formatage de date
1551 FAILED
Erreurs lexer
1601 | NULL INPUT STRING |
1602 | NON TERMINATED STRING |
1603 | NON TERMINATED COMMENT |
1604 | INVALID NUMBER |
1605 | UNKNOWN START OF TOKEN |
1606 | NON TERMINATED NAME |
1607 | NO VALID TOKENS |
Erreurs de cache
2000 | CACHEABLE NOT INITIALIZED |
2001 | VALUE ALREADY CACHED |
2002 | CACHED VALUE NOT FOUND |
Erreurs de protocole
3000 | HEADER NOT FOUND |
3001 | UNKNOWN COMMAND |
3002 | ALREADY LOGGED IN |
3003 | NOT LOGGED IN |
3004 | UNKNOWN OUTPUT MODE |
3005 | INVALID STATEMENT ID |
3006 | UNKNOWN DATA TYPE |
3007 | STILL LOGGED IN |
3008 | SOCKET READ ERROR |
3009 | SOCKET WRITE ERROR |