update error

Thread View: comp.lang.pascal.delphi.databases

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by S.C. Tan Thu, 01 Apr 1999 00:00

#206

Author: S.C. Tan
Date: Thu, 01 Apr 1999 00:00

48 lines
2311 bytes

--------------704BDB2E6178838A9A38DCCD
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hi,

i am working with delphi 4 and btrieve files via ODBC interface. i have
a problem with updating or
deleting a record from a table using dbnavigator. error message being
'couldn't perform edit because
another user changed the record' this doesn't seems to make sense as i
am working in a single user
environment. could anyone help me? thanks in advance!!


------------------------------------------
Siew Cheng, Tan
Analyst Programmer
ACNielsen, Systems Asia Pacific
Email: siewcheng@acnielsen.com.my

--------------704BDB2E6178838A9A38DCCD
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>


<P>hi,

<P>i am working with delphi 4 and btrieve files via ODBC interface. i have
a problem with updating or
<BR>deleting a record from a table using dbnavigator. error message being
'couldn't perform edit because
<BR>another user changed the record' this doesn't seems to make sense as
i am working in a single user
<BR>environment. could anyone help me? thanks in advance!!
<BR>&nbsp;

<P><FONT FACE="Arial,Helvetica"><FONT SIZE=-1>------------------------------------------</FONT></FONT>
<BR><FONT FACE="Arial,Helvetica"><FONT SIZE=-1>Siew Cheng, Tan</FONT></FONT>
<BR><FONT FACE="Arial,Helvetica"><FONT SIZE=-1>Analyst Programmer</FONT></FONT>
<BR><FONT FACE="Arial,Helvetica"><FONT SIZE=-1>ACNielsen, Systems Asia
Pacific</FONT></FONT>
<BR><FONT FACE="Arial,Helvetica"><FONT SIZE=-1>Email: siewcheng@acnielsen.com.my</FONT></FONT></HTML>

--------------704BDB2E6178838A9A38DCCD--

Re: update error

#207

Author: Levi Junior
Date: Thu, 01 Apr 1999 00:00

47 lines
2171 bytes

Hi,

First sorry my (very) bad English.

I have experienced this exact error message.
Probably you have this situation:

  Table1 (customer)
  Fields: customer-id, etc...

  Table2 (invoice)
  Fields: customer-id, invoice-id, delivery-customer-id,
delivery-address-name, etc...
  MasterSource: Table1
  Masterfield: customer-id

  delivery-name is 'Lookup' to Table1 and table2 is table1 detail.

  Master  --------   Detail
  Table1  --------> Table2
             <-----------|  Table2 Field Lookup


This causes error!!!
Delphi abort update and delete because field lookup change table1 position
and table1 change table2 position.(Looping situation)

Levi Junior
Zaith@Mandic.com.br


S.C. Tan <tsiew@pl.jaring.my> wrote in message
news:37037375.E6B28ABC@pl.jaring.my...
hi,
i am working with delphi 4 and btrieve files via ODBC interface. i have a
problem with updating or
deleting a record from a table using dbnavigator. error message being
'couldn't perform edit because
another user changed the record' this doesn't seems to make sense as i am
working in a single user
environment. could anyone help me? thanks in advance!!

------------------------------------------
Siew Cheng, Tan
Analyst Programmer
ACNielsen, Systems Asia Pacific
Email: siewcheng@acnielsen.com.my

Re: update error

#208

Author: Oliver Townshend
Date: Fri, 02 Apr 1999 00:00

27 lines
1571 bytes

> i am working with delphi 4 and btrieve files via ODBC interface. i have a
problem with updating or
> deleting a record from a table using dbnavigator. error message being
'couldn't perform edit because
> another user changed the record' this doesn't seems to make sense as i am
working in a single user
> environment. could anyone help me? thanks in advance!!

My experience is that this happens when you edit a record twice in
succession, which as far as your database and the BDE are concerned, is two
different users.  eg:

    with Table1 do begin
        Edit;
        ...
        Post;
        Edit;
        ...
        Post;        --- crash here
    end;

the only way around this is to make sure you do a Refresh between the first
Post and the second Edit.  This could be tricky if you are talking about
DBNavigator or DBGrid doing it.  Maybe you will have to enforce a Refresh in
the AfterPost event.

Oliver

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads