On 24/02/16 16:25, Mark Rotteveel wrote: > On Wed, 24 Feb 2016 16:43:25 +0100, Dimitry Sibiryakov <s...@ibphoenix.com> > wrote: >> > 24.02.2016 16:20, Dmitry Yemanov wrote: >>> >> If some 3rd party drivers rely on these numbers, we may >>> >> keep supporting them longer. >> > >> > Well, all versions of IBPR will stop working if isc_sqlcode() do. >> > >> > 24.02.2016 16:29, Mark Rotteveel wrote: >> > > So you should switch to SQLstate, or use the firebird >> > > error codes (aka gdscode) directly and map to the error messages in a >> > > similar way that drivers like Jaybird and Firebird .net provider do. >> > >> > In fact, it means parsing whole status vector because primary error >> > codes in most cases >> > are useless. > I think parsing the status vector is a must anyway, and the error code in > my opinion are less "useless" than the SQLCODE, as a lot of error codes at > least point to a specific problem (and the ones that have a very generic > first error code nicely map to the extremely broad SQLCODE like -104 or > -901), which can't be said about SQLCODE.
It does depend on just what you need the error message for. For a client system, where the fine detail will go over the head of the user. The SQLCODE detail is more than adequate and needs a smaller number of translations. Which is where we are at in the ADOdb driver. However that does already have a short version of the SQLSTATE list in the oracle error code array. I think the starting point is probably the PHP driver to switch it to returning SQLSTATE and perhaps gdscode ? -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
