It's been OK for a long before I use D5,
and the terrible things came from an upgrade to D6 and use "doa34D6.exe". (I even upgrade to today's version.)

Every joined multiple tables in a main editable table yeilded this error if you try
to edit any main table's field.
Here is my TOracleDataset's SQL.Text:

------------------------------------
select delvmain.rowid,delvmain.invoice invoice,
delvmain.custcode custcode,delvmain.closdate closdate,
delvmain.etd etd,delvmain.bnotes bnotes,
delvmain.mnotes mnotes,e.payday payday,e.empno empno,
b.mas_amt mas_amt,c.sumout sumout,
(nvl(b.mas_amt,0)+nvl(c.sumout,0)+nvl(f.suminv,0)) sumtot,
d.sumbid sumbid,
f.suminv suminv,
(nvl(c.sumout,0)+nvl(b.mas_amt,0)+nvl(f.suminv,0)-nvl(d.sumbid,0)) sumleft
from delvmain ,
(select invoice,sum(nvl(mas_amt,0)) mas_amt from mas01 group by invoice) b,
(select invoice,sum(round(nvl(conf_qty,0)*nvl(conf_prc,0),2)) sumout from delvdetl
group by invoice) c,
(select bid_invno,
sum(nvl(bid_amt,0)-decode(bid_asid,'

Is the record locked? If it is, you should see an "ORA-00054, resource busy and acquire with NOWAIT specified" exception in the Oracle Monitor, which is translated to the "locked by another user" message. If ORA-00054 occurs, then the record is really locked, and you may want to look into the cause of this lock.

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

Why is everything went wrong since I upgraded
from D5 to D6. Your DOA componet went wrong
just because of different version! Why don't
you ever think this once? Don't ask me to
look into cause of any lock, I don't lock
anything manully, not before and now neither.
Just answer me why things went wrong from D5
to D6? The most ironic thing is we have both
version D5 and D6 ap runing under an
identical Oracle 8.17i Database for Linux. Query for the same record and one can edit
and we posted it to database, and D6 version
just got a "Record locked by another user"
error? Please show me why this happen?

------------------

The Delphi 5 and Delhi 6 version are based on the same source files, so theoretically there should not be much of a difference. Compatibility is important to us too, we don't want to break applications.

I have not had any problem report that would indicate a locking issue in the Delphi 6 version, so I would really like some additional information.

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