The predicate dberror/2 can translate an error code to an error message.
dberror(ErrorCode, ErrorMessage)/2
| func | Translate an error code to an error message |
| pre | The variable ErrorCode must contain an integer value. |
| post | If the error code was a known error code then a string was assigned to the variable ErrorMessage, else nothing was assigned and the predicate fails. |
The current defined error codes are:
dberror(0, 'success').
dberror(1, 'dll not connected').
dberror(2, 'no ODBC environment').
dberror(3, 'setting environment variable').
dberror(4, 'no memory').
dberror(5, 'release database connection').
dberror(6, 'allocating database connection').
dberror(7, 'connectiing database').
dberror(8, 'no database name specified').
dberror(9, 'changing read-write mode').
dberror(10, 'changing asynchronous mode').
dberror(11, 'changing connection timeout').
dberror(12, 'changing commit mode').
dberror(13, 'changing transaction isolation level').
dberror(14, 'allocating query').
dberror(15, 'free query').
dberror(16, 'need data').
dberror(17, 'still executing').
dberror(18, 'error executing SQL statement').
dberror(19, 'invalid handle').
dberror(20, 'error close query cursor').
dberror(21, 'unknown number result columns').
dberror(22, 'no handle').
dberror(23, 'fetching next record').
dberror(24, 'no result set').
dberror(25, 'error fetch next row').
dberror(26, 'error fetch previous row').
dberror(27, 'error fetch first row').
dberror(28, 'error fetch last row').
dberror(29, 'determining number of parameters').
dberror(30, 'error getting parameter information').
dberror(31, 'error binding parameter').
dberror(32, 'error query tables').
dberror(33, 'nothing to query').
dberror(34, 'error query table privileges').
dberror(35, 'no table name').
dberror(36, 'query column privileges').
dberror(37, 'query columns').
dberror(38, 'query primary keys').
dberror(39, 'query foreign keys').
dberror(40, 'query procedures').
dberror(41, 'query data types').
dberror(42, 'no parameters in query').
dberror(43, 'incorrect parameter index').
dberror(44, 'no parameter value').
dberror(45, 'resetting parameter bindings').
dberror(46, 'unbinding columns').
dberror(47, 'query procedure columns').
dberror(48, 'error setting ODBC cursors to if needed').
dberror(49, 'set query to srollable').
dberror(50, 'error quering if forward only').
dberror(51, 'error absolute fetch').
dberror(52, 'error relative fetch').
dberror(53, 'incorrect argument for procedure call').
dberror(54, 'no database').