Added: 2 years ago
From: MOSSBCSTeam
Views: 9,145
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (4)

Sign In or Sign Up now to post a comment!
  • Great Tutorial!!!

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

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

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more