Home > mailing lists

Error codes from ODBC driver - Mailing list pgsql-odbc

From	dirk.jacobs@tuple.be
Subject	Error codes from ODBC driver
Date	March 13, 2002 18:20:57
Msg-id	OFCFC49AB1.E0BE7C9C-ON41256B7B.005C3C56@tuple.be Whole thread Raw
List	pgsql-odbc

Tree view

version 7.01.00.09

Hi there,

I want to detect if a table already exists or an index already exists but the driver always returns with SQLState S1000 which is a general error code.

The correct SQLstates are :

#define SQLSTATE_GENERAL_ERROR "S1000"

#define SQLSTATE_TABLE_EXISTS "S0001"
#define SQLSTATE_TABLE_NOT_FOUND "S0002"
#define SQLSTATE_INDEX_EXISTS "S0011"
#define SQLSTATE_INDEX_NOT_FOUND "S0012"

Any suggestions ?

-Dirk Jacobs

pgsql-odbc by date:

From: "Corey W. Gibbs"
Date: 13 March 2002, 17:10:01
Subject: Maybe more of a VB question, but here goes

From: Wolfgang.Fuertbauer@ebewe.com
Date: 13 March 2002, 18:46:42
Subject: Re: Problem with VB-DirectODBC selecting

Error codes from ODBC driver - Mailing list pgsql-odbc

Previous

Next