Data Connections

Re: Newbie - Edit SQL

Lolly — Mon, 17 Aug 2009 20:45:03 GMT

Thank you very much. Works great now.

Re: Newbie - Edit SQL

Hilary Stoupa — Mon, 17 Aug 2009 18:24:23 GMT

Something like:

select "empID","fName","lName","employmentStatusCode", "fName" + ' ' + "lName" AS FullName from "dbo"."Employee" as "Employee"

You'll get an InfoPath warning that the SQL can't be represented as a tree, tell the warning box you are okay with that. You'll also get a warning about potentially unsafe queries, you can tell InfoPath that you are okay with that too....

Newbie - Edit SQL

Lolly — Mon, 17 Aug 2009 14:48:13 GMT

I want to edit the SQL to concatenate lastName and fName so it would be Doe, John. Is that possible and what is the correct syntax?

Current Query:

select "empID","fName","lName","employmentStatusCode" from "dbo"."Employee" as "Employee"