On 27-4-2012 12:03, AngelBlaZe wrote: > > for example > a decimal(10,5) column > would have using the query above: > type = 16 And subtype = 2 > precision = 10 > scale = 5
Scale is a negative value, not positive (so a DECIMAL(10,5) has scale -5 (you can interpret it as: move the decimal 5 positions to the left). > some common types: > typemap(8) = ddTypes.aInteger > typemap(37) = ddTypes.aString > typemap(7) = ddTypes.aSmallInt > typemap(16) = ddTypes.aDecimal > typemap(12) = ddTypes.aDate > typemap(35) = ddTypes.aDateTime > typemap(261) = ddTypes.aByte Table RDB$TYPES contains a mapping of ids to their type name (not just for field types btw). -- Mark Rotteveel
