Use QueryTransformer to replace SQL expression for the query output columns
I assume I probably need to use query transformer for this but what is the best approach for taking an SQL query created by the user using the control and adding RTrim to all of the string columns in the select query ?
I can see QT has a Columns property but how do I update the columns like this
Select string1,number1,string2 from x where .....
Select RTrim(string1),number1,RTrim(string2) from x where .....
Sorry, this is not possible in ActiveX version of the component. QueryTransformer cannot perform such a transformation.