MetaDataField Size and Precision the wrong way around ?

Completed

Comments

3 comments

  • Official comment
    Avatar
    ActiveDBSoft support team

    For the numeric(10,2) type the first number is the precision (the max number of decimal digits the type can store) and the second number is scale (the number of decimal digits after the dot). These values can be found in the Precision and Scale properties of the IMetadataField interface.

    The Size property is undefined for numeric fields by SQL standard, but database drivers sometimes returns something driver-specific into this property (for example, the number of bytes this type takes on the storage).

    Comment actions Permalink
  • Avatar
    Minieggs

    For me the Numeric(10,2) is being returned as a OLEdtBCD with Size of 2, Precision of 10 and Scale is not a property of MetaDataField ? (in the activex version)


    0
    Comment actions Permalink
  • Avatar
    ActiveDBSoft support team

    I forget to export MetadataField.Scale property to the ActiveX interface. Sorry for inconvenience.

    I have added IMetadataField.Scale upstream, and the fix will be included in the next build.

    0
    Comment actions Permalink

Please sign in to leave a comment.