On 04/07/2022 16:21, Rick Hillegas wrote:
I'm afraid I don't understand your results. When I run your experiment,
"2" is the name and label of the second column of the query "SELECT
country,count(*) FROM customer GROUP BY country ORDER BY country". Does
the following give you what you want:
SELECT country,count(*) AS "count(*)" FROM customer GROUP BY country
ORDER BY country
What I'm after if I have "x AS y" is a way of getting "x". I understood
(incorrectly as it seems) that getColumnName() would give "x" and
getColumnLabel() would give "y".
As far as I can tell from experiments, both methods ALWAYS produce
identical results. So I'm no longer sure why two different methods exist.
This email has been checked for viruses by AVG.