On Tue, Nov 24, 2015, at 19:30, Mark Rotteveel wrote: > What is the query you use?
select sum(field1 * (field2 + field3)) from ... But basically any operation with these fields gives me subtype 0. > I know that Firebird sometimes doesn't reports the subtype for > decimal/numeric, and then you only have the scale to go on. Or at least, > Jaybird has code to handle cases like this (subtype 0, negative scale) so > I assume Firebird does or has done this, I have never actually seen a > case myself. I have similar code in FirebirdClient as well. It defaults to DECIMAL. Not sure if it's correct (or where I found that information ;)). -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
