Avatar of wmholt
wmholt
 asked on

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?
Microsoft SharePointInfoPathMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
wmholt

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Clay Fox

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
wmholt

ASKER
Thanks for the help!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck