string error_text
CHOOSE CASE sqlDBCode
the case 1 error_text = ‘violation of a unique index!’
case 1400 error_text = ‘field can not be empty!’
case 1407 error_text = ‘field can not be empty!’
case 1401 error_text = ‘field is too long!’
case 1438 error_text = ‘value is greater than the maximum precision of the column allows!’
the case 2291 error_text = ‘appear illegal field!’
Case 1031 error_text = ‘rights!’
Case 911 error_text = ‘registered name is invalid!’ / / permissions dedicated
case 922 error_text = ‘Invalid special characters!’ / / permissions dedicated
CASE 1017 error_text = ‘the unlawful user name or password, Login denied!’
CASE 12154 error_text = ‘can not be decomposed name!’
CASE 01005 error_text = ‘is not given the password or wrong password Login denied!’
CASE 01935 error_text = ‘items enter the name of the registered name for the system keyword is prohibited as a registered name!’
The CASE 540 error_text = ‘data table or view does not exist!’
CASE 942 error_text = ‘data table or view does not exist!’
To CASE 903 error_text = ‘illegal column name!’
CASE 1403 error_text = ‘did not find a qualified data!’
CASE -3 error_text = ‘you read into the data and save procedure, the data in the server by other users or window changes, please re-read the data and try again!’
CASE 6 error_text = ‘network with the database connection to the server has been interrupted, close the application and then re-open.’
CASE 50 error_text = ‘network with the database connection to the server has been interrupted, close the application and then re-open.’
Case 1920 error_text = ‘user name with another user or role name conflict’
the case 988 error_text = ‘the lack of a password or illegal!’
the Case 1918 error_text = ‘The Oracle user does not exist!’
case 1940 error_text = ‘operator can not give up a current connection, delete the current operator is being used!’
CASE ELSE
if isnull (sqlca.sqlErrText) or sqlca.sqlErrText =” then
error_text = ‘data operation failed!’
else
error_text = sqlca.sqlErrText
end if
END CHOOSE
return MessageBox (‘error’, error_text RetryCancel!)
/ / DBError parameters
Buffer buffer where the error occurred
Row the number of rows of the first error
The database error SqlDBCode code
The database error SqlErrText information
