General

Re: 255 Character Limit

cddaugherty — Tue, 24 Oct 2006 20:37:53 GMT

Thanks!!! This will help me a lot.

Re: 255 Character Limit

Agni Jonnalagadda — Tue, 24 Oct 2006 05:15:39 GMT

You cannot update the SharePoint list with long datatypes, but you can do the same to a DataBase of your own.
For database you either need to write a webservice to submit the data to a DB or you can buy Qdabra webservice to get this functionality.
http://www.qdabra.com/proddetail.asp?prod=QDBXL1

Re: 255 Character Limit

cddaugherty — Tue, 24 Oct 2006 03:18:00 GMT

This is a quote from InfoPath 2007 help file.

"Long data types, such as pictures, images, OLE objects, file attachments, and Access Memo or SQL data types, should be excluded from the data connection. InfoPath does not support data connections to these long data types. To exclude specific fields in the database, use the Data Connection Wizard to set up the data connection."

I found this to be true when submitting to a SharePoint list when using v.2.

I was wondering if anyone can explain why this limitation exists and if there is a possibility that the long data types can be submitted to a database or a SharePoint list?

Re: 255 Character Limit

Shiraz Cupala — Thu, 12 Oct 2006 17:33:52 GMT

On SharePoint where are you getting the limit? When you promote a property? What kind of field is it?

255 Character Limit

cddaugherty — Fri, 06 Oct 2006 16:48:17 GMT

Has anyone been able to determine if the 255 character limit when submitting to a database or SharePoint will be fixed in 2007? This is a real sticking point for my projects.

Thanks in advance for the info!

Chris