OracleDataSet1.SQL.Text =>
select * from "ZAKAZ_CEX"
where 1=2
OracleDataSet.GetUpdatingAlias => ZAKAZ_CEX

OracleDataSet1.SQL.Text =>
select * from "ZAKAZ"
where 1=2
OracleDataSet.GetUpdatingAlias => 1 Why????

DOA 4.0.6, Delphi 7
Posted By: Marco Kalter Re: OracleDataSet . GetUpdatingAlias - 01/06/06 08:40 PM
I'm not sure yet what causes this bug, but it has something to do with the quotes. If you replace "ZAKAS" with ZAKAS, the results are okay.

We'll fix this.
Posted By: 1andreymx Re: OracleDataSet . GetUpdatingAlias - 09/28/23 07:14 PM
good afternoon, it's Andrey again
DOA 411 Delphi 7

ods.UpdatingTable := '';
ods.sql.text := 'select * from table tbl';
ShowMessage(ods.GetUpdatingAlias); => tbl

ods.UpdatingTable := '';
ods.sql.text := 'select * from owner.table tbl';
ShowMessage(ods.GetUpdatingAlias); => tbl

ods.UpdatingTable := 'table';
ods.sql.text := 'select * from owner.table tbl';
ShowMessage(ods.GetUpdatingAlias); => TABLE
© Allround Automations forums