PRB: Constraints, Primary Keys and Defaults Using Recordset DTC

ID: Q194015

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

SYMPTOMS

When updating or adding 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

You need to validate the integrity of the record and/or set any defaults programmatically before updating or adding the records.

STATUS

This behavior is by design.

Additional query words: kbVisID600 kbDSIASPGrp

Keywords : kbASPObj kbCtrl kbScript kbVisID600 kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbprb