Board index » delphi » Delphi 1.0 - Oracle 7.3 problem

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

 

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

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
=============================================

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