System.Data.SQLite

View Ticket
Login
2020-05-24
23:07
Update the expected results for the [71bedaca19] ticket test case. Closed-Leaf check-in: 5ae8a13833 user: mistachkin tags: core-3.32.0
2015-07-13
22:41
Add tests for ticket [71bedaca19]. check-in: 1ddef23eb9 user: mistachkin tags: trunk
19:51 Closed ticket [71bedaca19]: Add enumeration for extended return codes plus 4 other changes artifact: 3fef8b81ec user: mistachkin
19:51
Add extended return codes to the SQLiteErrorCode enumeration. Pursuant to [71bedaca19]. check-in: 42798551ca user: mistachkin tags: trunk
17:19 Ticket [71bedaca19] Add enumeration for extended return codes status still Open with 3 other changes artifact: 66b76b63f3 user: mistachkin
11:33 Ticket [71bedaca19]: 3 changes artifact: 6ae7c2c197 user: anonymous
2015-06-03
16:35 Open ticket [71bedaca19]. artifact: 1a6b119f5b user: mistachkin
2015-06-02
07:37 New ticket [71bedaca19]. artifact: a0d81bde40 user: anonymous

Ticket Hash: 71bedaca19d94cb6b6c6c2f3deb293b71a2b3133
Title: Add enumeration for extended return codes
Status: Closed Type: Feature_Request
Severity: Minor Priority: Medium
Subsystem: Convert Resolution: Fixed
Last Modified: 2015-07-13 19:51:41
9.77 years ago
Created: 2015-06-02 07:37:38
9.89 years ago
Version Found In: 1.0.98.0
User Comments:
anonymous added on 2015-06-02 07:37:38:
<p>I think there should be an enum SQLiteExtendedResultCode mapping to those described <a href="https://www.sqlite.org/rescode.html#extrc">here</a>.</p> 
<p>It's rather cumbersome to be able to write<br />
<code>SQLiteErrorCode errorCode = myConnection.ExtendedResultCode();<br />
if (errorCode == SQLiteErrorCode.Constraint)<br />
    doSomething();</code><br />
but then having to write<br />
<code>if ((int)errorCode == 1555 /* SQLiteExtendedResultCode.ConstraintPrimaryKey */)<br />
    doSomething();</code></p>
<p>It would also be nice to have SQLiteException.ErrorCode being an SQLiteErrorCode instead of an int.</p>

anonymous added on 2015-07-13 11:33:19:
Moreover: even after setting myConnection.SetExtendedResultCodes(true) I would have expected myConnection.ResultCode() to still deliver one of the 31 <b>Primary Result Codes</b> - why else should there be a method myConnection.ExtendedResultCode()? The documentation here is by the way erroneous because it says for all three methods "Enables or disable<u>d</u> extended result codes returned by SQLite". <br/>
Regards, Bernd

mistachkin added on 2015-07-13 19:51:41:
Fixed on trunk via check-in [42798551ca].  Instead of creating a new enumeration,
the existing one was updated to include the extended return codes.