SQL query based on Infopath filed value

Nandrew — Thu, 24 Apr 2014 10:41:10 GMT

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 :(

SQL Database Integration

SQL query based on Infopath filed value