On Wed, 24 Feb 2016 11:28:07 +0000, Lester Caine <les...@lsces.co.uk> wrote: > I'm finally taking the time to push the improved Firebird driver for > ADOdb in PHP over to the new development home for that project and one > of the things I decided to tidy up is the error messages which still > relate to the original FB1 list. Currently ADOdb takes the shorthand > SQLCODE and provides generic messages for errors detected, along with > many different language versions. I have a short list of error codes to > add which currently just get returned as numbers, but when scouting > around for a more up to date reference I stumbled on > http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx02-sqlcodes.html > and it's 'note' is a little concerning when the SQLCODE is used by many > third party interfaces. SO what are the current plans on this?
SQLcode has been deprecated in the SQL standard for years (in SQL92 or in SQL99) in favor of SQLstate. The SQLstate consists of 5 characters: 2 characters error class and 3 characters for more specific errors within that class (with 000 representing the error class without further classification). 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. Mark ------------------------------------------------------------------------------ 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
