Newbie Questions

Re: Text box size

ducecoop — Thu, 30 Aug 2007 15:19:32 GMT

Thank you both

Dave

Re: Text box size

Patrick Halstead — Thu, 30 Aug 2007 00:55:24 GMT

Here's a link to some overview documentation:

http://www.qdabra.com/Content/ProdInfo/DBXLv2/Qdabra-DBXLBusinessValue.pdf

Re: Text box size

davidair — Thu, 30 Aug 2007 00:46:34 GMT

InfoPath has limitations when creating direct connections to a database:

http://office.microsoft.com/en-us/infopath/HP100950831033.aspx

Quoting the article (I've underlined memo):

None of the data fields in the main data source of the form store a large binary data type InfoPath will disable the submit data connection if the query includes fields that can store a large binary data type, such as pictures, images, OLE objects, file attachments, the Office Access memo data type, or the SQL Text data type.

I think your best bet is to communicate to the database via a webservice. Although this requires extra work (and you need an IIS server running ASP.NET) you are much more flexible on what you can build.

QDabra's DBXL makes connecting your forms to databases easier as the webservice is already provided to you (http://www.infopathdev.com/files/folders/dbxldownload/entry19957.aspx).

Text box size

ducecoop — Thu, 30 Aug 2007 00:30:05 GMT

Can you make access memo fields (memo - data type) work with InfoPath 2003?

Seems like it is limited to text box constraints (256 characters) , but I gotta believe I am just missing how to get them to work togather because I can not imagine a product like this being this limited (even in its first version)

Thanks for reading

Dave