January 05, 2009, 04:10 PM
kfr104Variables in SQL to label column titles
Does anyone know if you can use a variable table to name your columns in WebFocus?
For example in SQL, I have a table that has three listings for 2005, 2006, and 2007. I want to label the columns in several reports to have each one of those variables as the title. This way I can just update the SQL table when I want to change titles.
Thanks
January 05, 2009, 04:21 PM
FrankDutchYou can table the title database and put the results in amper variables with a -READ.
January 05, 2009, 09:05 PM
WazDitto with Frank.
You just need to handle if its a variable number of titles, etc.
January 07, 2009, 12:28 PM
Darin LeeIf you're having to remember to update a database with column titles, hold them, then read them again using &vars, seems like it would just be easier to remember to change the TITLE= attribute in the MFD ( unless, as Waz mentions, they are really all the same field with a variable number of titles).
