InfoPath 2010 Form Not Displaying Decimal Fields

Hi,

I have a BCS External Content Type based on an Oracle connection via a .NET assembly.  I've used this to create an External List in SharePoint 2010.

When I try to display the fields in an InfoPath 2010 using the SharePoint External List as my data source, the fields can all be selected, except for the ones with the Decimal data field type.  They do not show up in the list to be able to be selected.

I know that I need to change the data type from decimal to something InfoPath can handle, but I don't have any ideas how to do that.  For those who might say, edit the schema, the schema does not show the fields of the decimal data type.

Any suggestions for this specific situation or advice where to make the datatype change?
wmholtAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Clay FoxConnect With a Mentor Director of Business IntegrationCommented:
InfoPath can handle decimals but for whatever reason is not detecting them properly in this case.

You should go into your BCS setup and try changing the field type there. That is the best place, then refresh your list and data connection.
0
 
wmholtAuthor Commented:
Thanks for the help!
0
All Courses

From novice to tech pro — start learning today.