Inserting into SQL

[Theguyinohio]

I just have a basic question regarding infopath. Can I with NO
programming (yes, I am a programmer) have infopath insert records into
a table as they are answered. I am looking for an example of a
questionaire that will pull questions from a table and insert into a
answers table with a join in the questionid. I am looking for a non-
programming solution. any out there?

Mike

 

[Clay Fox]

This can be done several ways depending on the complexity of what you want to
do.

The method with the most flexibility is using Web Services.

You can download a whole suite of them and install them without any coding
from here http://www.qdabra.com. There are several tutorials available on
how to create the data connnections too.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Theguyinohio]

This can be done several ways depending on the complexity of what you want to
do.

The method with the most flexibility is using Web Services.

You can download a whole suite of them and install them without any coding
from herehttp://www.qdabra.com. There are several tutorials available on
how to create the data connnections too.
--
Thanks

Clay Fox

Qdabra Softwarehttp://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the Worldhttp://www.infopathdev.com






- Show quoted text -

Not looking to purchase another product. I want to know if this can
be done out of the box. it seems like what MS bills this as... but I
cant find any examples. The examples I do see only update data. not
add new rows.

 

[Clay Fox]

For the basic functionality you have to design a new form from scratch as a
database form. Point it at your table and it will create the structure to
both query and submit to this table. This includes adding new rows.

The limitation is that you only get one group of related tables that you can
query and submit. So if you want to query one table and write to another one
you cannot do it without webservices. You can load other tables as secondary
but they cannot be queried and will pull in all of the rows of the table
which you then must filter.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Theguyinohio]

For the basic functionality you have to design a new form from scratch as a
database form. Point it at your table and it will create the structure to
both query and submit to this table. This includes adding new rows.

The limitation is that you only get one group of related tables that you can
query and submit. So if you want to query one table and write to another one
you cannot do it without webservices. You can load other tables as secondary
but they cannot be queried and will pull in all of the rows of the table
which you then must filter.

--
Thanks

Clay Fox

Qdabra Softwarehttp://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the Worldhttp://www.infopathdev.com






- Show quoted text -

Thank you. That makes sense. It also means that it is not the tool
for me. I can easily program something to do this and wouldnt need
the tool.

Mike