Issue Details (XML | Word | Printable)

Key: CORE-2890
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Paulo França Lacerda
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

SQLSTATE should also be available as a PSQL context variable like GDSCODE/SQLCODE

Created: 26/Feb/10 05:25 AM   Updated: 23/Feb/11 12:50 PM
Component/s: Engine
Affects Version/s: 2.5 RC2
Fix Version/s: 2.5.1, 3.0 Alpha 1

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

Environment:
Windows 2003 Server.
AMD Athlon 32-bit, 1.66 GHz, 1 GB RAM
Issue Links:
Relate
 

Planning Status: Unspecified

Sub-Tasks  All   Open   

 Description  « Hide
I'm getting a compile error when trying to access the new
SQLSTATE code as I usually do to SQLCODE and GDSCODE.

My test code:
------------------------------------------------
create procedure sp_Test_SqlState (
  SomeParam Integer)
returns (
  oSqlErr Integer,
  oGdsErr Integer,
  oSqlStt Char(5)) as
begin
/* do something... */

  when Any do
  begin
    oSqlErr = SqlCode;
    oGdsErr = GdsCode;
    oSqlStt = SqlState; /* ERROR: "SQLSTATE" UNKNOWN! */

    suspend;
  end
end
------------------------------------------------


I'm using:
Firedbird 2.5 RC2 on Windows 2003
EMS SQL Manager 2008
Flamerobin 0.9.3.1870

Am I using it mistankenly or perhaps those tools above
aren't yet prepared for Firebird 2.5?

Thanks in advance,
Paulo França

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Paulo França Lacerda added a comment - 14/Mar/10 10:03 PM
I think the correct issue title would be:
"SQLSTATE should also be available as Context Variable like GDSCODE."