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(3tcl), tdbc::tokenize, tdbc::connection(3tcl), tdbc::statement(3tcl), tdbc::resultset(3tcl)

KEYWORDS

       TDBC, SQL, database, state

COPYRIGHT

       Copyright (c) 2009 by Kevin B. Kenny.

Tcl                                                    8.6                               tdbc::mapSqlState(3tcl)