|
You should be able to do this with an explicit
select from the other table. E.g.
update turq_bills set
bill_document_no=(SELECT turq_bill_commons.bill_document_no
FROM turq_bill_commons
where turq_bill_commons_id=turq_bill_commons.id);
Fred ----- Original Message -----
Sent: 04 April 2005 16:36
Subject: [Hsqldb-developers] Update
Problem
Hi,
I searched the bug
database but could not find something relevant..
I am using 1.7.2
and
could not run the update statements like
following..
update turq_bills set
bill_document_no=turq_bill_commons.bill_document_no
where turq_bill_commons_id=turq_bill_commons.id;
It gives the below error..
Column Not Found : ID / ERROR
CODE :-28 / STATE : S0022
if this is a known issue, can
you suggest a workaround ?
Thanx in
advance...
--
Önsel
Armağan
[EMAIL PROTECTED]
Computer Science http://www.turquaz.com
& Mathematics
Tel:90-216-483 9000 /2320
|
