Print Thread
OracleDataSet . GetUpdatingAlias
#8115 01/06/06 11:37 AM
Joined: Aug 2004
Posts: 83
Ukraine
A
Member
OP Offline
Member
A
Joined: Aug 2004
Posts: 83
Ukraine
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

Re: OracleDataSet . GetUpdatingAlias
#8116 01/06/06 08:40 PM
Joined: Aug 1999
Posts: 22,204
Member
Offline
Member
Joined: Aug 1999
Posts: 22,204
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.


Marco Kalter
Allround Automations
Re: OracleDataSet . GetUpdatingAlias
Joined: Sep 2023
Posts: 1
1
Member
Offline
Member
1
Joined: Sep 2023
Posts: 1
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


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.068s Queries: 15 (0.011s) Memory: 2.5023 MB (Peak: 3.0398 MB) Data Comp: Off Server Time: 2024-04-25 11:04:03 UTC
Valid HTML 5 and Valid CSS