<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>We are having problems reading decimal/numeric column types with TSQLQuery. It appears if the precision of a decimal/numeric is more than 4 (for instance, DECIMAL(12,8) or DECIMAL(18,10) or DECIMAL(10,6) TSQLQuery raises an exception on reading - <span class="Apple-style-span" style="font-family: Courier; font-weight: bold; ">EDatabaseError : Unknown field type : COLUMN_NAME. <span class="Apple-style-span" style="font-family: Helvetica; font-weight: normal; ">However, using the established (informal) money-types for Firebird - DECIMAL(18,4) or DECIMAL(10,4) are OK, and multiple other variations are OK if precision is 4 or less. </span></span></div><div><br></div><div>Questions:</div><div>1) is this a bug, or a known "feature" or limitation of the FPC Firebird library?</div><div>2) is there a workaround? We require a decimal with at least 9 decimal places precision (?perhaps DOUBLE PRECISION)</div><div>3) the issue with negative numerics with TSQLQuery being treated as unsigned, described in the bug list as fixed in FPC 231 - has this fix been moved to FPC 224?</div><div><br></div><div>Thank you.</div><div>Regards,</div><div>Andrew Hall. </div><div><br></div>[Using Firebird 211 with FPC 224 on MacOSX 10.5 with XCode 311]</body></html>