Data Connections

Re: T-SQL Possible in .UDCX?

fuzzbear — Thu, 02 Aug 2018 18:35:02 GMT

This was a secondary data source. I ended up using a translate in the form so that it was able to normalize the data and do the comparison.

I'd still love to know if T-SQL is possible, I couldn't find anything in the DOCS. it doesn't seem like it works at all though.

Re: T-SQL Possible in .UDCX?

Hilary Stoupa — Fri, 20 Jul 2018 22:00:45 GMT

Can you switch your query to use a View? Or is this a main data source query?

T-SQL Possible in .UDCX?

fuzzbear — Wed, 18 Jul 2018 20:36:20 GMT

I have a successful data connection, and in the udcx file, I have a SQL query that is successful, however i would like to use a T-SQL function LOWER() to return one particular column back in all lower case. When I try to do this, the column does not return any data. After some googling I have come up with zero leads on if it's even possible to do this. If this doesn't work, is there some way to have InfoPath parse the returned data from that query/column as lower case.. I'm trying to match an accountID in a person field with an Active Directory name in the SQL database, but the SQL table has a mixture of upper / lower case entries that im trying to normalize. Thanks RM