https://www.infopathdev.com:443/forums/48.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17961.aspxTue, 27 Feb 2007 18:09:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17961Greg Collins0https://www.infopathdev.com:443/forums/thread/17961.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17961You will probably need to do this with code or rules... Set the query field before querying.https://www.infopathdev.com:443/forums/thread/17583.aspxThu, 22 Feb 2007 19:38:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17583dgibson55310https://www.infopathdev.com:443/forums/thread/17583.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17583How do you reference an InfoPath schema field in an InfoPath data connection SQL select statement ? Can't seem to get the correct syntax.<br /><br />Here's an example : Would like for the 'u799976' to be an Infopath schema variable.<br /><br />shape<br /> {select "CostCenterNumber","RoleID","UserID" from "dbo"."Users" WHERE "UserID" = 'u799976'} as "Users"<br /> append<br /> ({select "RoleID","RoleTitle" from "dbo"."Role" as "Role"}<br /> relate "RoleID" TO "RoleID") as "Role"