Microsoft KB Archive/194015

= PRB: Constraints, Primary Keys, and Defaults Using Recordset DTC =

Article ID: 194015

Article Last Modified on 3/16/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



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.

Additional query words: kbVisID600 kbDSIASPGrp

Keywords: kbscript kbprb kbctrl KB194015

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.