Code

Re: Submitting to more than one SQL table

Patrick Halstead — Tue, 06 Dec 2005 04:54:27 GMT

Hi Vidette,
The link is below but I just realized that we have to extend the time bomb as it has recently expired. Please send me e-mail separately, and I'll let you know when the updated version is ready.

http://www.infopathdev.com/downloads/free/EvalTools/InfoPathDev.com%20Tools%20-%20Forms%20Database%20Accelerator.%20v1.0.zip

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Submitting to more than one SQL table

vapires — Mon, 05 Dec 2005 19:13:12 GMT

Thanks Patrick,
Where do I download this?
-vapires

VidetteP

Re: Submitting to more than one SQL table

Patrick Halstead — Fri, 02 Dec 2005 09:36:48 GMT

Hi Vidette,
Try our Database Accelerator. A free download is available. You can shred to 3 tables without writing any code and you can do it from your ownXML schema.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Submitting to more than one SQL table

vapires — Thu, 01 Dec 2005 20:32:53 GMT

Hi,
I need to submit a form that updates 3 tables. When I add a submit to SQL server Dataconnection infopath automatically makes my dataconnection a retrieve only dataconnection as there is more that one table involved. How do I add an update and retrieve dataconenction to more than one table in infopath?

I have tried manually entering my SQL statement under dataconenction (edit sql statement) but this did not work. Your input is appreciated.

Cheers,
Vidette

VidetteP