Hi,
we run a sapdb with kernel and rte version 7.4.3 Build 025-123-046-179.
I tried an update via dbmcli which has the following syntax:
update t1set field1_1 = (
select t2.field2_1 from t2
where t2.field2_2=t1.field1_2
and t2.field2_3=t1.field1_3
and t2.field2_4=t1.field1_4)
Unnessessary to say that for each row in t1 there exists exactly 1 row in
t2 which matches the condition.
The result is: -24988,ERR_SQL: sql error / 100,Row not found
Well, I tried another variant which is as follows:
update t1set field1_1 = (
select t2.field2_1 + (t1.field1_5 * 0) from t2
where t2.field2_2=t1.field1_2
and t2.field2_3=t1.field1_3
and t2.field2_4=t1.field1_4)
The result is: "OK" which sounds very well, but in fact no single value has
been updated!!
So, can anybody advise me?
Best Regards
Heidi Rufer
Entwicklung
anTloop Technologie AG
Hildastr. 66
D-79102 Freiburg
Fon: +49-761-791 878-32
Fax: +49-761-791 878-9
[EMAIL PROTECTED]
www.antloop.de
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
