Delphi 1.0 - Oracle 7.3 problem

Johan Petersson

Delphi Developer

Fri, 04 Jun 1999 03:00:00 GMT

Delphi 1.0 - Oracle 7.3 problem

Hi!

I've got a problem... When I try to perform an edit on a TTable in
Delphi 1.0 I sometimes get the following errormessage:

'Couldn't perform the edit because another user changed the record.'

Can anyone please help me by telling me what I have done wrong, coz
only one user has access to the Oracle DB, so another user van't have
changed any record...

Thanx...
/Johan

Jasper St

Delphi Developer

Fri, 04 Jun 1999 03:00:00 GMT

Re:Delphi 1.0 - Oracle 7.3 problem

Quote

Johan Petersson <johan.peters...@notes.sema.se> wrote:
> Hi!

> I've got a problem... When I try to perform an edit on a TTable in
> Delphi 1.0 I sometimes get the following errormessage:

> 'Couldn't perform the edit because another user changed the record.'

> Can anyone please help me by telling me what I have done wrong, coz
> only one user has access to the Oracle DB, so another user van't have
> changed any record...

Except if you are that user yourself. Didn't you do anything i.e. with
Database Desktop, or SQL*Plus for that matter, while your app was
running?

Jasper

Sandy Coop

Delphi Developer

Sun, 06 Jun 1999 03:00:00 GMT

Re:Delphi 1.0 - Oracle 7.3 problem

On 16 Dec 1996 20:53:34 GMT, dirks...@euronet.nl (Jasper Stil) wrote:

Quote

>Johan Petersson <johan.peters...@notes.sema.se> wrote:

>> Hi!

>> I've got a problem... When I try to perform an edit on a TTable in
>> Delphi 1.0 I sometimes get the following errormessage:

>> 'Couldn't perform the edit because another user changed the record.'

>> Can anyone please help me by telling me what I have done wrong, coz
>> only one user has access to the Oracle DB, so another user van't have
>> changed any record...

>Except if you are that user yourself. Didn't you do anything i.e. with
>Database Desktop, or SQL*Plus for that matter, while your app was
>running?

>Jasper

I have been plaqued by this problem for a while now, I bumped into it
a few weeks ago then ,as it happened, I was changing the program quite
significantly and it went away. It is now back with a vengance so if
any one has ideas I'm listening too!!

=============================================
Sandy Cooper Software Specialists
MOSSL Aberdeen
=============================================

Jose Lope

Delphi Developer

Mon, 07 Jun 1999 03:00:00 GMT

Re:Delphi 1.0 - Oracle 7.3 problem

Quote

> >> 'Couldn't perform the edit because another user changed the record.'

> >> Can anyone please help me by telling me what I have done wrong, coz
> >> only one user has access to the Oracle DB, so another user van't have
> >> changed any record...

I have seen this error in a MSSQL environment also, and I think it will
occur on every SQL Database. The fact is that if you have any fields that
are cumplimented in the server side (for example, a timestamp field, or an
auto-increment field), then Delphi will have an outdated copy of the record
after posting it. As Delphi uses an "optimistic locking" schema, when it
has to update again the record, it compares the values of its fields, with
the values in the server ... and they are different ... so " ... another
user changed the record". Try using "UpdateMode=WhereKeyOnly", and be aware
of any field that is cumplimented by the server.

Other Threads

1. Problem mit Delphi 1.0 und Oracle 7.3

2. problem with Delphi 1.0 and Oracle 7.3

3. delphi 1.0 and oracle 7.3 problems

4. Delphi 1.0 => Oracle 7.3

5. Delphi 1.0 with Oracle 7.3 in Netware 3.12

6. Oracle 7.3 and Delphi 1.0

7. Delphi 1.0 and Oracle 7.3

8. Q: Delphi 1.0 Client/Server and multirow fetching from Oracle 7.3 Stored Procedures

9. URGENT: Delphi 1.0 x Oracle 7.3

10. Delphi 1.0 and ORACLE 7.3 Stored Procs