|
Returns an associative array of status and return codes for the last SQL query/statement/command. Elements of the array are:
Tabela 1. Status information returned by sesam_diagnostic()
Element | Contents |
---|---|
$array["sqlstate"] | 5 digit SQL return code (see the SESAM manual for the description of the possible values of SQLSTATE) |
$array["rowcount"] | number of affected rows in last update/insert/delete (set after "immediate" statements only) |
$array["errmsg"] | "human readable" error message string (set after errors only) |
$array["errcol"] | error column number of previous error (0-based; or -1 if undefined. Set after errors only) |
$array["errlin"] | error line number of previous error (0-based; or -1 if undefined. Set after errors only) |
In the following example, a syntax error (E SEW42AE ILLEGAL CHARACTER) is displayed by including the offending SQL statement and pointing to the error location:
See also: sesam_errormsg() for simple access to the error string only
Poprzedni | Spis treści | Następny |
sesam_connect | Początek rozdziału | sesam_disconnect |
Hosting by: Hurra Communications Sp. z o.o.
Generated: 2007-01-26 18:02:54