-
Daniel Ferreira
- PowerBuilder
- Wednesday, 29 October 2025 05:14 PM UTC
Hi guys,
I'm using PB 2025 3711. I'm connecting to a MySQL DB using ODBC "MySQL Connector/ODBC 8.0 (32-bit)". I was using version 8.0.37, but I've updated to the latest 32-bit available, which is 8.0.43 (PB IDE doesn't seem to be able to use the 64-bit version), but it didn't make any difference.
I have this DW that I've built some time ago, PB 2022 I think. Now, I need to alter the query, but since it's from a derived table, the new PB IDE is not being able to retrieve the columns aliases, it's renaming everything to compute_xxxx (compute_0001, compute_0002, etc).
This is my current dw, the one I'm trying to edit. It has many more columns (this example has 25), I'll print just part of it.
Currently it's all fine.
This is a snapshot of the query I'm trying to edit (I have to add some columns). Mind that the original one doesn't have all these aliases, putting aliases on everything was my first try.... but it didn't work.
SELECT
x.cod_cli AS cod_cli,
x.nome_cli AS nome_cli,
x.status AS status,
x.email AS email,
x.telefone AS telefone
FROM (
SELECT
c.cod_cli AS cod_cli,
TRIM(c.nome_cli) AS nome_cli,
c.status AS status,
c.email AS email,
c.telefone AS telefone
FROM cliente c
LEFT JOIN tab_municipios tm ON tm.cod_municipio = c.cod_municipio
WHERE c.id_empresa = :ai_empcod
UNION ALL
SELECT
c.cod_cli AS cod_cli,
TRIM(c.nome_cli) AS nome_cli,
c.status AS status,
'' AS email,
c.telefone AS telefone
FROM cliente_dependentes cd
JOIN cliente c
ON c.id_empresa = cd.id_empresa
AND c.cod_cli = cd.cod_cli
LEFT JOIN tab_municipios tm ON tm.cod_municipio = c.cod_municipio
LEFT JOIN graus_parentesco gp ON gp.id_grau_parentesco = cd.gr_parentesco
WHERE cd.id_empresa = :ai_empcod
) AS x
ORDER BY cod_cli, nome_cli DESC
And below is the DW after I return from the query editor. As you can see, it changed everything. Of course I can try and do an edit source, but it will be a pain, this is not the only dw, there are quite a few others. Another issue is that, even if I accept this, and change the columns' name on the dw, when I export to excel, it uses the dbname, so the excel sheet won't be of much use as "compute_001", etc.
Oh, and of course, all my computed fields stopped working because of the column name change.
Do you guys know any workaround for this? Is it a known bug?
Thanks a lot, your help is appreciated.
Daniel
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.