Hello to everyone
I’m trying to change some column names when trying to pull data from a mysql database, but it doesn’t.
for example
query = SELECT INVOICE_NUMBER AS NUMBER FROM sales
result = column name INVOICE_NUMBER
hmmmm… looks like an issue with our DB Query being overly aggressive in its SQL optimization. In other words, it tries to help you … but apparently fails miserably.
Using concatenation, it works. So for instance:
SELECT
EUI.LAST_NAME + "" as LASTNAME
FROM e_participant_uid
I will report this as an issue.
Thank you so much. A sufficient solution at the moment. Hopefully a study will be done to solve this situation. you are legend 