03-02-2015 11:05 AM
I want to know if its possible to include a macro variable into a column name in enterprise guide when using query builder. I have tried it and it does not resolve.
I know its possible via sql code.
select column_1 as test_&rep_date
The sql generated by the query builder is as below:
select column_1 as 'test_&rep_date'n
Any help would be appreciated.
03-02-2015 02:20 PM
I have users that use the query builder only. If this is done in sql then they will not be able to maintain it. I can include a program node to do this but if they continue in query builder then the column name will become static and if the macro result changes then the builder will error.
03-03-2015 02:40 AM
The query builder is good for one-off queries. Maintainable code is, well, code.
The helpers in EG are good for getting a starting point, serious work is done in a code window.
At some point your users need to come out of the nursery.