General

Re: How to submit a "long" type data

Patrick Halstead — Thu, 20 Oct 2005 06:19:07 GMT

Hi M2Land,
Check out our Database Accelerator in the Downloads-Free section. There's a free eval version you can use to do this. No coding required! :)

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: How to submit a "long" type data

m2land — Wed, 19 Oct 2005 04:08:15 GMT

Thanks for your help!My problem is that if you created an Infopath form based on a Database Connection and the database you used contains any BLOB type datafield.The "Submit" function Infopath should support will be useless and the "Submit" icon on the toolbar will be gray too.
I have checked some MSDN documents and solved that problem by writing a WebService.
This is the link of onehttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_ta/html/odc_InfoPath_image_objects.asp

Re: How to submit a "long" type data

vt_asparagus — Wed, 19 Oct 2005 02:15:03 GMT

Hi there...Did I read this correctly, are you trying to insert an image into a field defined as a long type in SQL Server? If you need to store an image in the DB, use BLOB type. There are several discussion threads here discussing that topic.

How to submit a "long" type data

m2land — Tue, 18 Oct 2005 08:44:34 GMT

When I used a SQL 2000 table as datasource I found that "Submit" function is useless because one of datafield of that table is "image" type. So how can I submit a Infopath form with "long" type datafield?