add float datatype in sql using DIAPI

[Former Member]

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 = ??

[Former Member · Accepted solution]

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