 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / July 2007InfoPath form connected to DB
I have an InfoPath form that submits data to DB. There is a limitation of 255 characters that DB can only accept. Is there a way to increase that limit? Hello Whats the datatype in the DB? You can make the changes in the DB If it is Char you can make it Char(8000) , Varchar(max) nvarchar(max) etc.  SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > I have an InfoPath form that submits data to DB. > > There is a limitation of 255 characters that DB can only accept. Is there a > way to increase that limit? Hi The field data type is a text which can only accommodate 255 characters. If I will to use Memo, InfoPath forms cannot submit the information. > Hello > [quoted text clipped - 5 lines] > > There is a limitation of 255 characters that DB can only accept. Is there a > > way to increase that limit? Hello This is a limitation in the Infopath. If you want to overcome this you need to have webservice between the database and the form SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Hi > [quoted text clipped - 11 lines] > > > There is a limitation of 255 characters that DB can only accept. Is there a > > > way to increase that limit? Webservice? My infoPath form is actually posted in Sharepoint and DB is in my drive > Hello > [quoted text clipped - 16 lines] > > > > There is a limitation of 255 characters that DB can only accept. Is there a > > > > way to increase that limit? Hello Yes You need webservice to submit data from Form to DB to overcome this text limitation. Since Infopath does not allow more than 255 characters to be inserted into DB directly, you need to use webservice in between form and DB. SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Webservice? > [quoted text clipped - 20 lines] > > > > > There is a limitation of 255 characters that DB can only accept. Is there a > > > > > way to increase that limit? Hi purple InfoPath has limitations working with databases that can only be overcome by using web services. I would recommend you check out the Database Accelerator product. It has a free download and provides you with pre-built web services to interact with your dataabse and gives you a host of other features. http://www.qdabra.com SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > Webservice? > [quoted text clipped - 20 lines] > > > > > There is a limitation of 255 characters that DB can only accept. Is there a > > > > > way to increase that limit? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.