SQL data not updating with submit - InfoPath Dev
in

InfoPath Dev

Now you can find InfoPathDev on YouTube and Twitter!

SQL data not updating with submit

Last post 01-21-2010 01:06 PM by imstac. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-21-2010 12:34 PM

    • imstac
    • Top 150 Contributor
    • Joined on 01-13-2010
    • Austin, TX
    • Posts 44

    SQL data not updating with submit

    I went through the Getting started manual for DBXL and was able to get the expense report to post data to my dummy tables.  Now, I have moved on to one of my actual forms and am having difficulty getting the data to post into my SQL tables.  With the data post I will be posting to multiple tables.  I am able to get the data to post to the main table by itself.  However, when I start to add the child tables the data will not post anymore.  I'm not sure what I'm doing wrong.  I've made sure that all the mappings were complete in my configuration.  I've attached a snapshot of my configuration.  The two SQL tables that I'm testing are below.  

    Main table:

    ID bigint 8 0
    EmployeeNo char 10 1
    EmployeeName varchar 50 0
    Email varchar 70 1
    Work_Summary varchar 1000 1
    Accreditation_Affliation varchar 50 1
    PE_Certification bit 1 1
    LEED_Certification bit 1 1

    Child table:

    EmployeeID bigint 8 0 (Foreign key to main table)
    EducationID bigint 8 0 (Identity set to Yes)
    School_Facility varchar 50 1
    Degree_Completed varchar 4 1
    Completion_Date datetime 8 1

    Stacie
    Filed under: ,
  • 01-21-2010 12:45 PM In reply to

    Re: SQL data not updating with submit

    Which one is the repeating (child) node? That repeating node needs to be used for the child table Employee_Education. Can you attach a screenshot of the schema (from InfoPath) so we can verify this?

    Also, does the event viewer (on the machine where DBXL is installed) provide any additional clues (errors, warnings, etc.)?

    Thanks,

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 01-21-2010 01:06 PM In reply to

    • imstac
    • Top 150 Contributor
    • Joined on 01-13-2010
    • Austin, TX
    • Posts 44

    Re: SQL data not updating with submit

    Thanks for the tip on looking at event viewer.  After looking at the error I discovered that I had one of my fields in the Employee_Education table with a 4 character limit. 

    Stacie
Page 1 of 1 (3 items)
Copyright © 2003-2010 Qdabra Software. All rights reserved.
View our Terms of Use.