Print Thread
Errors in DOA 3.4.6.4
#4298 12/06/02 06:00 PM
Joined: Dec 2002
Posts: 1
F
fkemper Offline OP
Member
OP Offline
Member
F
Joined: Dec 2002
Posts: 1
Hi!
I found errors in DOA 3.4.6.4, function TOracleDataSet.GetUpdatingAlias,
what used in RefreshRecord.

1)For query

select a.*, a.rowid,
(select count(*)
from order_det b
where b.id_order = a.id_order)
from order a;

GetUpdatingAlias returns 'order_det',
but no 'order' !

2)For query

select *
from
(select count(*), id_order
from order_det
group by id_order) a,
order b
where b.id_order = a.id_order;

with inline subquery we will get ERROR.

F.Kemper

Re: Errors in DOA 3.4.6.4
#4299 12/06/02 10:04 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
We will look into this and fix it.

------------------
Marco Kalter
Allround Automations


Marco Kalter
Allround Automations

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.031s Queries: 12 (0.005s) Memory: 2.4992 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-20 11:33:17 UTC
Valid HTML 5 and Valid CSS