I am using SharePoint 2010.
I have an External Content Type for which I have created an InfoPath form. The External Content Type is reading/writing from/to an SQL database. This is all working fine.
User feedback is that they want to enter more detail in one of the text fields - (Justification)
I have updated the SQL database for the Justification field to be nvarchar(MAX)
I have refreshed External Content Type connection. In SharePoint designer creation operation shows that Justification has a .net type of system.string. I have tried creating a new table on the ECT and new InfoPath form - but the InfoPath form kicks in with some validation on the Justification field to only allow 150 characters. (This is not validation I have put in.)
What else do I need to do to allow more data to be added to the Justification field?
Thank you
Catharine