NIPO ODIN Version 5.17

Previous Topic

Next Topic

Errors Messages Using *SQLADD

After the execution of the *SQLADD, the variable Count contains the number of successfully added records. An error message is reported No run-time error is produced and the interview can continue normally. However NIPO ODIN script writer can use this variable Count to display a warning if required.

Error messages for *SQLADD

Error code Description  

-1

Record number with the same primary key is already used in database table. The related error message is

"Database error in <Database>(<dbo>.<Tablename>) : Violation of PRIMARY KEY. Cannot insert duplicate key in object '<Tablename>'. The statement has been terminated."

-2

Record number does not meet constraints that have been set in the SQL table. The related error message is "Database error in <Database>(<dbo>.<Tablename>) : INSERT statement conflicted with COLUMN CHECK constraint '<constraintname>'. The conflict occurred in database '<database>', table '<Tablename>', column '<Column name>'. The statement has been terminated."

-3

Database field is not found in table. The related error message is "Database field <fieldname> not found."

-4

DSN is not found. If using another database, an ODBC link should be created on the NIPO CATI/Web master. The related error message is "Database error in <Database>: Data source name not found and no default driver specified."

-5

Insufficient right to insert records. The related error message is "[ERROR] Database error in <Database>(<owner>.<Tablename>) : INSERT permission denied on object '<Tablename>', database '<Database>', owner '<user>'."

See Also