Hello, it´s me again
Here i go and make awkward questions.
I have a query (with oracle sql i am using pivot syntax) which will give me a ‘n’ number of columns depending of distinct values populated in a table.
Because i am transforming rows into columns i will have different number of columns (depending of the DB data).
While creating .lst (in designer mode) i will have a ‘data sample’ which may not match some others DB data, but in order to create a table i will define those columns into the table.
If i run that List/Table against other DB i will get an error cause those columns do not exist.
How can i avoid that? Is there a way to have ‘dynamic columns’ defined within the designer for a table?
P.S. - Hope you understand my question. Feel free to ask all you need.