SQL Database Integration

Re: Working with Repeating Tables

ssaral — Wed, 04 Jan 2006 17:42:55 GMT

I'm looking to both write and read from SQL...I have it working now the data sources were not setup correctly and there was an issue with the way the table keys were defined...thanks.

Re: Working with Repeating Tables

shailaja — Tue, 03 Jan 2006 15:08:20 GMT

Hello Ssral,
One question that I have for you is - are you trying to just retrieve data or to both retrieve and submit data to the DB. If you are trying to just retrieve data from the DB you can create a new data connection using Tools -> Data connections to the specific SQL DB. To show this data in a repeating table format, drag drop the repeating table from the Controls task pane and then bind it to the secondary data connection just created.

If on the other hand you are trying to both retrieve and submit data, then you would have to create an InfoPath form which has the SQL connection as the main Data connection. To do this please follow the steps below
1. In Design a Form task pane, click on New from Data connection
2. Create a data connection to the specific SQL DB in the data connection wizard that comes up. In the last window of the data connection wizard you will be told if Submit is allowed or not to this specific table in the database.
3. This will create some default UI to be able to insert.
4. If submit is allowed based on text shown in the last window in the wizard - you will be able to enable submission of forms using Tools -> Submitting forms. This will allow you to update existing data in the database.

Hope this helps!

Shailaja
InfoPath Dev India

Working with Repeating Tables

ssaral — Fri, 30 Dec 2005 16:08:32 GMT

Hi Guys,

I'm new to Infopath and I'm trying to create a repeating table to hold Revision History data for a document and link that to an SQL database. I was able to link other text boxes to my SQL data source, but can't get the repeating table to work with my SQL tables.

My SQL table for Revision History is a called SME9_RevHist, with the following columns:

S90Key is the Primary Key for the table
S91Ver is for the version number
S92VerDate is for the Date the version was updated
S93Auth is for the Author name who made the version update
S94Comm is for Additional comments

Next I created a repeating group called RevInfo with the following elements:
Ver
VerDate
Auth
Comm

So, how can I now connect the elements in the repeating group the my SQL table and be able to store and retrive information typed into these fields when using the form or do I need to go down a different path...

thanks, a bunch
ssaral