How to access different columns with the same name in COS?

Question

Freddy Baier · Jan 11, 2023

I have this code:

SELECT id,room,client->name,functionary->name FROM rooms ORDER BY idSQL
SQL

What i do to access the "client" name?

set rs = $SYSTEM.SQL.Execute("SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id")

zw rs.%Get("name")
"return functionary name"ObjectScript
ObjectScript

Product version: Caché 2018.1

$ZV: Cache for Windows (x86-64) 2018.1.5 (Build 659U) Mon Mar 22 2021 07:03:57 EDT

Discussion (2)2

Danny Wijnschenk · Jan 11, 2023

You can use 'client->name as clientname' and .%Get("clientname") or use .%GetData(columnnumber)

2 0

Cristiano Silva · Jan 12, 2023

HI @Freddy Baier

You can change your query, given alias to the columns:

SELECT id,room,client->name as ClientName,functionary->name as FunctionaryName FROM rooms ORDER BY idSQL
SQL

Then in COS you access the columns by name:

Write rs.%Get("ClientName")
Write rs.%Get("FunctionaryName")ObjectScript
ObjectScript

1 0