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

Reply via email to