RecordChangeComplete and Primary Key constraint

From: Olivier Matrot (olivier.matrot_at_online.nospam)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 12:28:56 +0200

Hello,
Correct me if I'm wrong but it seems that the status of a field that is
underlying a primary key constraint is not set to an ERROR value in the the
RecordChangeComplete Event when the record in error violates the primary key
constraint.
My tests shows that only the pError parameter is set.

The problem here is because pError is specific to the OLE DB Provider used,
there is no simple way to determine that a constraint Error has occured.

TIA.

Relevant Pages

  • Re: Create Table Issues
    ... unique index on BookID. ... > CONSTRAINT PubPK PRIMARY KEY ... > CONSTRAINT PubFK FOREIGN KEY REFERENCES Publisher ...
    (microsoft.public.access.gettingstarted)
  • Re: Naming conventions for special database objects
    ... If you want it to be required, why not use a DEFAULT and a NOT NULL constraint? ... identifier (VIN), and add two mutually exclusive sub-classes, Sport ... utility vehicles and sedans ... NOT NULL PRIMARY KEY, ...
    (comp.databases)
  • Re: SQL Subquery on Max(date)
    ... The overall query I'm trying to insert this select into ... LEFT OUTER JOIN ... CONSTRAINT pk_oncd_company ... PRIMARY KEY, ...
    (microsoft.public.access.formscoding)
  • Re: orace sql query
    ... "Oracle enforces all PRIMARY KEY constraints using indexes. ... believe otherwise but were that not true you could not enforce ... For example, a PRIMARY KEY constraint ... Puget Sound Oracle Users Groupwww.psoug.org ...
    (comp.databases.oracle.server)
  • Re: orace sql query
    ... "Oracle enforces all PRIMARY KEY constraints using indexes. ... believe otherwise but were that not true you could not enforce ... For example, a PRIMARY KEY constraint ...
    (comp.databases.oracle.server)