DragonFly On-Line Manual Pages

Search: Section:  

tdbc::mapSqlState(n)       Tcl Database Connectivity      tdbc::mapSqlState(n)

______________________________________________________________________________


NAME

       tdbc::mapSqlState - Map SQLSTATE to error class


SYNOPSIS

       package require tdbc 1.0

       tdbc::mapSqlState sqlstate
______________________________________________________________________________


DESCRIPTION

       The tdbc::mapSqlState command accepts a string that is expected to be a
       five-character 'SQL state' as returned from a SQL database when an
       error occurs. It examines the first two characters of the string, and
       returns an error class as a human- and machine-readable name (for
       example, FEATURE_NOT_SUPPORTED, DATA_EXCEPTION or
       INVALID_CURSOR_STATE).

       The TDBC specification requires database drivers to return a
       description of an error in the error code when an error occurs. The
       description is a string that has at least four elements: "TDBC
       errorClass sqlstate driverName details...". The tdbc::mapSqlState
       command gives a convenient way for a TDBC driver to generate the
       errorClass element given the SQL state returned from a database.


SEE ALSO

       tdbc(n), tdbc::tokenize, tdbc::connection(n), tdbc::statement(n),
       tdbc::resultset(n)


KEYWORDS

       TDBC, SQL, database, state


COPYRIGHT

       Copyright (c) 2009 by Kevin B. Kenny.

Tcl                                   8.6                 tdbc::mapSqlState(n)

Search: Section: