Using one field to update another and submit to SQL - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Using one field to update another and submit to SQL

Last post 09-26-2011 04:55 AM by Mnutty. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 09-26-2011 04:55 AM

    • Mnutty
    • Not Ranked
    • Joined on 09-21-2011
    • Posts 2

    Using one field to update another and submit to SQL

    Hi

    I can read and write to an sql database no problems.

    In my form I pull back an id, name, price, date and type from a db in a repeating section. I want to then update the date and price for that one product, but in my section it puts every item as the same price as it only sees one id (the first one)

     What I want is:

    Current information

     id = 1

    name = blah

    price = 12

    date = 01/08/2011

    New information

    id = 1

    date = 01/09/2011

    price = 13

    Current information

    id = 2

    name = blah blah

    price = 12

    date = 01/08/2011

    New information

    id = 2

    date = 01/09/2011

    price = 13

    What I'm getting is

    Current information

    id = 1

    name = blah

    price = 12

    date = 01/08/2011

    New information

    id = 1

    date = 01/09/2011

    price = 13

    Current information

    id = 2

    name = blah blah

    price = 12

    date = 01/08/2011

    New information

    id = 1

    date = 01/09/2011

    price = 13

     How do I get around this?

    Mike

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