Skip to Content
author's profile photo
Former Member

add float datatype in sql using DIAPI

hi

what would be the combination of <b>"datatype and subdatatype"</b> to add a field of float type in database using DI.

SAPbobsCOM.BoFieldTypes = ??

SAPbobsCOM.BoFldSubTypes = ??

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Sep 30, 2005 at 11:45 AM

    Hi Pnakaj,

            Dim oField As SAPbobsCOM.UserFieldsMD
            oField.Type = SAPbobsCOM.BoFieldTypes.db_Float
            oField.SubType = SAPbobsCOM.BoFldSubTypes.???

    The last value depends on how many decimal places you require. Any one of the following is valid:

    st_Measurement

    st_Percentage

    st_Price

    st_Quantity

    st_Rate

    st_Sum

    You can see in Administration > System Initialization > General Settings > Display Tab how many decimals each of them has.

    Fields are created as numeric and not float SQL type.

    Hope it helps,

    Adele

    Add comment
    10|10000 characters needed characters exceeded