The column headings/titles revert to "A", "B", "C" whenever I begin a query with a comment (for documentation purposes) or perform a join in a query. However, if I remove the leading comment and/or join, the proper titles appear in my answerset.
How can I force the column titles/headings to always appear? I already have the answerset option "Dsiplay Column Titles rather than column Names" checked, and I'm using SQLA 7.2. Thanks.
Problem solved (sort of) . . . I was using "--" comments, and those for some reason do seem to suppress the column headings. However, when I used "/* . . . */" comments the headings now appear. So I'll just use those instead, though I'm still not sure why "--" would suppress column headings.
The "A", "B", "C" headings are displayed when ODBC returns no column titles. I think this problem has been fixed in a later version of the ODBC driver. (I know a similar case of empty headings was fixed in ODBC 12.0)