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.

John English

This email has been checked for viruses by AVG.

Reply via email to