AnsweredAssumed Answered

SQLBlockFetch & SQL Literals

Question asked by Rob McBride on Jul 30, 2015
Latest reply on Feb 18, 2016 by Rob McBride

Just getting on with the SQLBlockFetch and everything works great except for the lack of return of SQL literals.

 

For instance:

 

Select FNAME as FirstName, LNAME as LastName, 'Manager' as Type, RPRTSTO as ReportsTo

From EMP WHERE EMPTYPE = 'M'
UNION ALL
Select FNAME as FirstName, LNAME as LastName, 'Employee' as Type, RPRTSTO as ReportsTo

From EMP WHERE EMPTYPE = 'E'
Order by Type, LastName, FirstName


The values for all the columns come back except for the literal column (Type).  Anyone ever try something like this with the SQLBlockFetch Pattern?

Outcomes