InfoPath Dev

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

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

Thanks Patrick,
Where do I download this?
-vapires

VidetteP

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