Re: is the sqlca.sqlabc value unique for each response type

Поиск
Список
Период
Сортировка
От Christoph Dalitz
Тема Re: is the sqlca.sqlabc value unique for each response type
Дата
Msg-id 20021121091318.757ba208.christoph.dalitz@hs-niederrhein.de
обсуждение исходный текст
Ответ на is the sqlca.sqlabc value unique for each response type  (Reid Thompson <reid.thompson@ateb.com>)
Список pgsql-general
> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: &main::execute undefined?
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: double quotes around table and column names