PRB: Constraints, Primary Keys, and Defaults Using Recordset DTC (194015)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
This article was previously published under Q194015

SYMPTOMS

When you update or add records, using a Recordset Design-time control (DTC) with the Scripting Platform set to "Server (ASP)", it fails to validate database constraints, primary keys, or insert default values. No error messages display if the database constraints or primary keys are invalid. Additionally, default values are not applied if fields are left blank.

RESOLUTION

Validate the integrity of the record and/or set any defaults programmatically before updating or adding the records.

STATUS

This behavior is by design.
Modification Type:MinorLast Reviewed:3/16/2005
Keywords:kbCtrl kbprb kbScript KB194015
©2004 Microsoft Corporation. All rights reserved.