Are there limitation on Decimal datatypes? I have and external SQL2008R2 database with some Decimal datatype fields. When I create the connection I get a warning "The Scale of this Datasource element can not be determined from the datasource and the decimal digits property for this datasource is configured to 4"
When I view as an external list the list ( in browser) renders with all fields. When I try and use this list as a datasource for an infopath form all decimal fields don't appear??
This has been flagged as spam show
how to access oracle data into infopath for both read and write. Thanks Scot
scotsdale2 4 months ago
Great Tutorial!!!
clstratmann 1 year ago
Are there limitation on Decimal datatypes? I have and external SQL2008R2 database with some Decimal datatype fields. When I create the connection I get a warning "The Scale of this Datasource element can not be determined from the datasource and the decimal digits property for this datasource is configured to 4"
When I view as an external list the list ( in browser) renders with all fields. When I try and use this list as a datasource for an infopath form all decimal fields don't appear??
icemannz11 1 year ago
The External content Type -Tables configured from SQL server database have columns of data type Numeric and small int.
These when used in External List has data type of Decimal.
The problem I have here is,I cannot sum the column with datatype "Decimal"(in external list).
The External list usually have "Number" as its data type.But BDC on conversion used "Decimal" and "Integer".
Any thoughts on how I can change the data type in sharepoint? or how can I get the sum of decimal columns?
vikpri20 1 year ago