After creating an Infopath form thru' the method of File > Design a form,
then selecting New from data connection, I still do not have the option of
Submitting to database when I add a command button. Why is that so? The
only options available are "Email, Web Service, SharePoint form Library, Web
Server (http), Custom submit using form code and Custom submit using rules"
Sundar Narasiman - 05 Nov 2007 13:29 GMT
When you design a form template based on the Database schema, using File -->
'Design a Form' . You'll get the following 2 options
a) New Record
b)Run Query
The 'New Record' has the built-in action to update the database. If you want
to write the same action using actions option it's not provided out-of-box.
You can call a web service or write the custom code using web services to do
the job.
This is how the product is designed currently.

Signature
----
Sundar Narasiman,
http://dotnetbuzz.spaces.live.com/
--
----
Sundar Narasiman,
http://dotnetbuzz.spaces.live.com/
> After creating an Infopath form thru' the method of File > Design a form,
> then selecting New from data connection, I still do not have the option of
> Submitting to database when I add a command button. Why is that so? The
> only options available are "Email, Web Service, SharePoint form Library, Web
> Server (http), Custom submit using form code and Custom submit using rules"
K.Ramana Reddy(GGK Tech) - 05 Nov 2007 13:30 GMT
Hi,
Check Out the below links, you can get information,
http://207.46.199.254/hi-in/library/bb608316(office.11).asp
http://blogs.msdn.com/infopath/archive/2007/03/21/infopath-data-connections-part
-1.aspx

Signature
k.Ramana Reddy
http://www.GGKtech.com
> After creating an Infopath form thru' the method of File > Design a form,
> then selecting New from data connection, I still do not have the option of
> Submitting to database when I add a command button. Why is that so? The
> only options available are "Email, Web Service, SharePoint form Library, Web
> Server (http), Custom submit using form code and Custom submit using rules"
Clay Fox - 05 Nov 2007 17:46 GMT
If you are working with a database, webservices are the way to go to have the
most flexibility.
You may be interested in the Database Accelerator download from
http://www.qdabra.com
It is a whole suite of pre-built webservices for working with your database
and gives you a lot of tools for your solution.

Signature
Thanks
Clay Fox
Qdabra Software
http://www.qdabra.com
InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
> After creating an Infopath form thru' the method of File > Design a form,
> then selecting New from data connection, I still do not have the option of
> Submitting to database when I add a command button. Why is that so? The
> only options available are "Email, Web Service, SharePoint form Library, Web
> Server (http), Custom submit using form code and Custom submit using rules"