InfoPath Dev

Well not sure if this was the best way to do it, but it worked. I am sure if anyone had any C# training at all they would have known this right off the bat :) since you have to put a + after each new line and each line has to be inclosed in " for the statement  "shape {select * from InspectionReports where IRid = " + IRlookup ...

I am trying to see how to format the SQL statement for a button that will query based on another field in my form. I know how to write sql queries normally but the c# is throwing me off. If anyone has any links to examples or tutorials that would be helpful. Thanks. Here is what Infopath says the sql is on my secondary datasouce I am using when I ...