SQL query based on Infopath filed value - InfoPath Dev
in

InfoPath Dev

SQL query based on Infopath filed value

Last post 04-24-2014 03:41 AM by Nandrew. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 04-24-2014 03:41 AM

    • Nandrew
    • Not Ranked
    • Joined on 09-11-2011
    • Hungary
    • Posts 11

    SQL query based on Infopath filed value

    Hello!

     

    I have a SQL database/table. In the table there are many coloums, one of them called „TD_ID”. In the infopath form, there is a ”Field1” field (xpath code: my:Fields/my:Field1).

     

    In the form, I only need thoose records, where TD_ID=Field1.

    I can write the value of td_id manually in the code, but it’s not the solution, because the value of the „Field1” dynamically change. :(

     

    Select * from TST1

    Where

    TD_ID='182005'

     

    What should I write after „Where” to run the query?

    Anyone can help me? I have no ideal at all :(

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