PRB: ODBC Error When Updating an Edited Record

ID: Q166882

The information in this article applies to:

SYMPTOMS

The following error occurs in the Query Designer when you move off an edited table record:

ODBC Error: Client Cursor: 12 - No key columns are specified for the update table.


CAUSE

In the Query designer, a table must have a key column specified so that you can edit the table data. The Query Designer uses SQL "Update ... Where" syntax to update the record and requires a key field in the Where clause to uniquely identify the record.


RESOLUTION

Specify a key column in your table. See the InfoView topic titled [ASCII 147]Defining a Primary Key[ASCII 148] under [ASCII 147]Microsoft Visual Database Tools, Database Designer, Working with Database Objects, Constraints[ASCII 148]


STATUS

This behavior is by design.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new table.


  2. Save the table.


  3. Open the table.


  4. Add a new record to the table.


  5. Move off the record you just added.


  6. Go back and edit a field in the new record.


  7. Move off the record. The error message described above appears.



REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/support/vinterdev/


Keywords          : kbVisDBTools kbVisID100 kbGrpASP kbDtQDesigner 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 7, 1999