On Thu, 2 Feb 2012 16:05:02 +0100, Jiri Cincura <disk...@cincura.net> wrote: > On Wed, Jan 18, 2012 at 11:08 PM, Ivan Prenosil <ivan.preno...@seznam.cz> > wrote: >> NumericField(9, 2) + 1 -> result is .. ehm ... Num/Dec(18, 2) (API >> will return zero as subtype) > > That's the point. What is/should be the "real" result in this case? > > I'm happy with conclusion that if field_scale is < 0 and no particular > sub_type, imply i.e. numeric. Probably somebody from core devs should > tell us.
That is what is done in Jaybird right now. See getDataType(...) and getDataTypeName(...) in http://firebird.cvs.sourceforge.net/viewvc/firebird/client-java/src/main/org/firebirdsql/jdbc/AbstractDatabaseMetaData.java?view=markup Mark ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
