General

Re: InfoPath - SQL: Character Limitations Within InfoPath

ZaiZai — Thu, 11 Dec 2008 12:12:38 GMT

Thanks for the reply. I just tried the nvarchar(MAX) and InfoPath still disables the submit feature of my main data connection. InfoPath stills sees it as a long data type. Is there something else that I was supposed to set up? I redid the data connection but still no luck. How did you get the connection to retrieve and submit in InfoPath using nvarchar(MAX)?

Re: InfoPath - SQL: Character Limitations Within InfoPath

Anuma — Thu, 11 Dec 2008 05:49:15 GMT

Hi,

You can use nvarchar(MAX) data type in the SQL.

InfoPath - SQL: Character Limitations Within InfoPath

ZaiZai — Wed, 10 Dec 2008 17:02:09 GMT

Anyone know a workaround to InfoPath's limitations to only except vchar(8000) data type for a text field? Anything larger like vchar(MAX) InfoPath thinks that it is a long text type object and doesn't allow the form to submit correctly.

How do I allow InforPath 2003 with a main data connections to a SQL Server 2005 table to allow more than 8000 characters?

Or maybe the question should be: What data type within SQL should I use in the form to allow more than 8000 characters?

vchar(8000) is the best that I can come up with....was hoping vchar(max) would work..but no dice.

Thoughts?