Re: Row cannot be located for updating

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 09/16/04

  • Next message: Alverio: "Re: Row cannot be located for updating" 
    Date: Thu, 16 Sep 2004 09:06:40 -0500

    >I have a master table and a detail table. Relationship is between field ID
    >(autoincrement field and primary key in MasterTable) and IDMaster (numeric
    >field in DetailTable). DetailTable has an autoincrement field as primary
    >key. The relationship is created in Access as well. I'm using

    The master linking field in the detail table needs to be of type Integer to link
    to an Access autoincrment field. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Alverio: "Re: Row cannot be located for updating"

    Relevant Pages

    • Row cannot be located for updating
      ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
      (borland.public.delphi.database.ado)
    • Re: Row cannot be located for updating
      ... Both primary keys in MasterTable and DetailTable are Autoincrement field ... But the problem seems to be on the Primary key fields, ... > The master linking field in the detail table needs to be of type Integer ...
      (borland.public.delphi.database.ado)
    • Re: Modifying Sql server data through Access
      ... add a column with an identity value (or autoincrement field in SQL ... Sylvain Lafontaine, ing. ... I cannot give primary key to some of the tables as some tables are temp ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Row cannot be located for updating
      ... Value 0 appears only after posting the record, ... I didn’t write any single line of code, apart the ones in the AfterPost event. ... Setting the AutoGenerateValue of the persistent field ID (the autoincrement field in the table) to arAutoInc is totally useless. ... If the primary key is set on other kind of fields everything works. ...
      (borland.public.delphi.database.ado)
    • Re: Sort order of Access table without index
      ... Yes, Viatcheslav is correct. ... Without the autoincrement field (used as a ... primary key also), there is not real DB that guarantees it will maintain ... physical chronological order. ...
      (borland.public.delphi.database.ado)