Re: update error

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

Article #207

Back to comp.lang.pascal.delphi.databases Previous Next

#207

From: 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

Technical Details

Message-ID: <7e06v5$6r5$1@srv4-poa.nutecnet.com.br>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <37037375.E6B28ABC@pl.jaring.my>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb0ea,4aa9420c14f90659
X-Google-Attributes: gidfb0ea,public
X-Google-Thread: ffff5,4aa9420c14f90659
X-Google-Attributes: gidffff5,public
From: "Levi Junior" <zaith@mandic.com.br>
Subject: Re: update error
Date: 1999/04/01
Message-ID: <7e06v5$6r5$1@srv4-poa.nutecnet.com.br>
X-Deja-AN: 461641245
References: <37037375.E6B28ABC@pl.jaring.my>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Complaints-To: abuse@zaz.com.br
X-Trace: srv4-poa.nutecnet.com.br 922984229 7013 200.246.247.88 (1 Apr 1999 16:30:29 GMT)
Organization: Zaith Informatica
X-MSMail-Priority: Normal
Reply-To: "Levi Junior" <zaith@mandic.com.br>
NNTP-Posting-Date: 1 Apr 1999 16:30:29 GMT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.vcl.components.using

Reply to Parent Message