Submit to a Database - Option missing?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ElScrimmo - 04 May 2007 16:14 GMT

I have an InfoPath2003 form which has a SQL Server 2005 Data Source. All
controls have nice Green binding status, but when I try to set the Submit
Options, I only have Web Service, script or HTTP. I was expecting to see
Database.

Is something missing, or do I have steps that I have missed?

Thanks

Richard

Reply to this Message

benoitc@gmail.com - 04 May 2007 20:11 GMT

I'm pretty sure you're only allowed one "submit" action per form, even
if you have more than one button. If you set them both as
action=submit, they will both be set to the most recent data
connection you've defined as submit. This is why when you checked
your form again, they were both attached to "Main Submit 2", since
that was the last one that was specified.

What you can do is have the button action be "rules and custom code",
and then use the data connection from script, like this:

XDocument.DataObjects["MyDataConnection"].Query();

On May 4, 11:14 am, ElScrimmo <ElScri...@discussions.microsoft.com>
wrote:

> I have an InfoPath2003 form which has a SQL Server 2005 Data Source. All
> controls have nice Green binding status, but when I try to set the Submit
[quoted text clipped - 6 lines]
>
> Richard

Reply to this Message