Modifying a Record's Primary Key
Written by Eric Smith, Northstar Computer Systems LLC
A user asked if it was possible to modify the primary key of a database record. This depends on how the database table was created. If the database table uses a counter or autonumber field, you won't be able to update the key. However, if the primary key is on a field that is just a number or other modifiable value, changing the primary key is just like changing another field. Remember that once the change is into the system, you'll need to access the record with the new key and not the old one.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 5/1/2000
|