OracleDataSet . GetUpdatingAlias

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
 
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.
 
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
 
Back
Top