Error $2eb9, update on primary key of master table

Richard Biffl

Delphi Developer

Fri, 19 Jul 2002 03:00:00 GMT

Error $2eb9, update on primary key of master table

Using BDE 5.10 with 11/19/99 Local SQL driver update.

Two Paradox tables linked with referential integrity, with cascade
updates. Primary key of master is Alpha field ("Name") and the RI link
is on this field. Trying to execute the following Local SQL query:

UPDATE "MyMaster.db" M
SET M."Name" = UPPER(M."Name")

generates BDE error $2eb9, "Update on Primary Key of a Master Table may
modify more than one record."

It looks to me like this query SHOULD work. The new key value should
cascade to the detail tables. Is this a known bug? Is there a
workaround?

Richard

Other Threads

1. Master has detail records updating a non-primary key field

2. How to update primary and foreign keys in referenced tables

3. MSSQL: Cascade Updating a Primary Key on Foreign Tables

4. Cascade Updating a Primary Key on Foreign Tables

5. Detail table key field updates on a Master/Detail relation

6. Primary key or not primary key.........

7. Number out of range error on Pdox table create w/autoinc primary key

8. change Primary Key when duplicate key error during post

9. Primary Keys modified in Master/Detail datasets

10. Master/Detail (primary key:3 fields)