Hi *, I have a query where (only) one field (expression) is this: OUTPUT SQLDA version: 1 sqln: 20 sqld: 1 01: sqltype: 581 INT64 Nullable sqlscale: -9 sqlsubtype: 0 sqllen: 8
When I do "show view ..." the datatype is reported as BIGINT. Is that correct? Looks like it should be NUMERIC/DECIMAL based on `scale`, but the `subtype` has confusing value. All fields in the query's expression are DECIMAL(18,4). Thanks JC. -- 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