infopath xml datatype

Discussion in 'InfoPath' started by fermat, Aug 20, 2011.

  1. fermat

    fermat

    Joined:
    Aug 20, 2011
    Messages:
    1
    Likes Received:
    0
    At my organization the infopath developers have built a data capture system that feeds xml files generated by infopath forms to an SQL server. It loads the form data in one column in in an SQL database. SQL query language is used to extract the data but all the fields are read as character (string), so all the work of specifying the data type in the Infopath form is lost and all numeric data must be converted again. It seems that the xml string does not contain any information about datatype. I'm wondering if there is a way to force Infopath to put the data type information along with the values in the xml files it produces when forms are complete so that SQL can later use that information to maintain the formats in the SQL database. This seems like a very inefficient system design that I would like to somehow improve and save myself and others a lot of work.
     
    fermat, Aug 20, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. larthur

    InfoPath 2007 Footer

    larthur, Aug 26, 2010, in forum: InfoPath
    Replies:
    0
    Views:
    714
    larthur
    Aug 26, 2010
  2. sfcalex

    InfoPath Save Errors

    sfcalex, Mar 2, 2011, in forum: InfoPath
    Replies:
    1
    Views:
    1,098
    sfcalex
    Mar 2, 2011
  3. EAK
    Replies:
    0
    Views:
    621
  4. anuarna
    Replies:
    0
    Views:
    637
    anuarna
    Apr 17, 2011
  5. JaumeBertos

    TreeView and Infopath

    JaumeBertos, May 12, 2011, in forum: InfoPath
    Replies:
    0
    Views:
    748
    JaumeBertos
    May 12, 2011
  6. niyaz.syed

    Browse Button in infopath Form

    niyaz.syed, Dec 20, 2011, in forum: InfoPath
    Replies:
    0
    Views:
    1,145
    niyaz.syed
    Dec 20, 2011
  7. sumeeth
    Replies:
    0
    Views:
    803
    sumeeth
    Dec 20, 2011
  8. vblack
    Replies:
    0
    Views:
    1,504
    vblack
    Feb 17, 2012
Loading...