is the sqlca.sqlabc value unique for each response type
Are the values that are populated in sqlca.sqlabc unique to response
type? IE, when i get a failure for 'ERROR: Cannot insert a duplicate
key into unique index "myindexname"' will the sqlca.sqlabc value always
be the same?
I'm looking for a way to determine if my failure is of this type w/o
having to to a string compare on the error message.
thanks,
reid
Date: Wed, 20 Nov 2002 22:40:59 -0500
From: Reid Thompson <reid.thompson@ateb.com>Are the values that are populated in sqlca.sqlabc unique to response
type? IE, when i get a failure for 'ERROR: Cannot insert a duplicate
key into unique index "myindexname"' will the sqlca.sqlabc value always
be the same?I'm looking for a way to determine if my failure is of this type w/o
having to to a string compare on the error message.
Why don't you check sqlca.sqlcode (or in SQL92: SQLCODE)?
It should contain a specific error code.
Christoph Dalitz
Import Notes
Reply to msg id not found: 20021121053734.72D5E4758FE@postgresql.orgReference msg id not found: 20021121053734.72D5E4758FE@postgresql.org | Resolved by subject fallback