The support for message-strings send by triggers is not implemented.
The common error send by triggers is the -746.
In the sqlerrm is the message for the error returned from a trigger.
This driver does not take this in mind.
Sorry for my bad english...
J. Montenegro
ifx_errormsg
(PHP 4, PHP 5 < 5.2.1)
ifx_errormsg — Retourne le message d'erreur de la dernière requête Informix
Description
ifx_errormsg
([ int
$errorcode
] ) : stringRetourne le message d'erreur associé à la dernière erreur Informix.
Liste de paramètres
-
errorcode -
Si spécifié, la fonction retournera le message correspondant au code erreur spécifié.
Valeurs de retour
Retourne le message d'erreur, sous la forme d'une chaîne de caractères.
Exemples
Exemple #1 Exemple avec ifx_errormsg()
<?php
printf("%s\n<br>", ifx_errormsg(-201));
?>
add a note
User Contributed Notes 2 notes
monts at netcabo dot pt ¶
19 years ago
sven at sveni dot com ¶
19 years ago
Nice function to call. Very helpfull if you want to use in combination with an own ErrorHandler. But informix error recognition seems just to work directly after calling a informix function.
/**
* checks weater error has occured or not
* @return false if no error, else error message
*/
function db_error_occured()
{
$err_code = ifx_error();
if (substr($err_code,0,1) != ' ') {
return ifx_errormsg();
}
else {
return false;
}
} //db_error_occured
