Insert data from infopath to SQL database - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Insert data from infopath to SQL database

Last post 09-04-2005 08:52 AM by Kiptodd. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-03-2005 08:02 AM

    Insert data from infopath to SQL database

    Here is what I am trying to do-
    My form contains a repeating Table with 3 feilds. Feild one is a autonumber incrementing by 1 (ie 1001,1002,1003...) Feild 2 is a Pull down used for a Document selecting,It connects to the sql database and extract documents names. Feild 3 is a Pull down feild
    to Select users. This form is a way to assign partnumbers to documents in sharepoint document libraries.

    Sql datadase is connected to sharepoint to which it stores all of the documents in Document Libraries. I know how to access.

    I want to be able to connect to the sql database and insert the partnumber assigned by the form to the document selected from the sql database.

    Kip Bautista
    KTB Dezines
  • 09-03-2005 10:30 PM In reply to

    Re: Insert data from infopath to SQL database

    Hi Kip,
    Why are you adding 3 posts for this. One ought to do no? Anyway, I am a bit confused by your description. I assume you are trying to connect to SQL form the InfoPath form and write the partnumber to a column in a row in a table in the database. Is that correct? Do you have a relational schema for your SQL database? How are you creating a relational database for this project? Have you looked at our Database Accelerator. It will allow you to save data to SQL and use it as a store for all of your forms. I look forward to hearing more from you about your problem.

    Patrick Halstead [InfoPath MVP]
    Patrick Halstead
    Project Manager at Qdabra
  • 09-04-2005 08:52 AM In reply to

    Re: Insert data from infopath to SQL database

    Sorry for the multiple post I did'nt know where to post.

    your assumsion was correct. The database is connected to sharepoint,
    the form is then connected to the user data table, it allows me to filter and retrieve all document names from all doc libs in a shrepoint site.

    the trick is the get that assigned number into the user data table and connect it to the document selected in the form.

    The Relational schema is created as a sharepoint custom intergration plugin.when documents are added to the libraries metadata from the document is placed into the sql db, I use the document apps SDK's to expose metadata I need to put into the userdata table.

    Kip Bautista
    KTB Dezines
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.