Timeline for Looking up a value in SQL to set a value on the InfoPath Form
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 8, 2011 at 11:23 | comment | added | Paul Lucas | Hmm, to be honest I'm not sure | |
| Dec 6, 2011 at 15:14 | comment | added | Amanda Porter | Sorry, I should have included the connection I saw and the query I saw run was when the form was open, not when I made a change to the field. I did not see a connection made at all when I changed the field to set the value of the other field. | |
| Dec 6, 2011 at 15:13 | comment | added | Amanda Porter | When I get to my field and make a change, I never see it try to connect to the database. Does info path require the data to be stored in the form? Or does this imply, something is wrong with my rule? Can the rule cause the query? | |
| Dec 6, 2011 at 15:08 | comment | added | Amanda Porter | I turnered on profiler and I'm very confused. I see the connection being made, the sql being passed is: select "LAST_MODIFIED","VENDOR_ID","VENDOR_NAME","NAME_UNO","VENDTYP_CODE" from "dbo"."APM_VENDOR" as "APM_VENDOR" WHERE 1 = 0 which I don't know what the 1=0 is all about. Then a little further down is the correct select: select "LAST_MODIFIED","VENDOR_ID","VENDOR_NAME","NAME_UNO","VENDTYP_CODE" from "dbo"."APM_VENDOR" as "APM_VENDOR" | |
| Dec 5, 2011 at 23:52 | history | answered | Paul Lucas | CC BY-SA 3.0 |