|
| |
|
|
lsfphelpls
Posts: 465
Joined: 3/16/2005
Status: offline
 |
when I add or modify a record in ado ... - 8/17/2007 15:17:10
when I add or modify a record in ado , if I have two primary keys , IF I UPDATE[MODIFY] A RECORD then primary keys override and if I add become new ones automatically ? Basically this happens [depends only] when the keys are different ?
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: when I add or modify a record in ado ... - 8/17/2007 15:26:43
If a primary key is set to Autonumber or Identity, then the PK will be created upon each sucessful add.
UPDATE's are performed based on the WHERE clause (or lack thereof) and it is extremely adviseable *not* to update your PK's.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
lsfphelpls
Posts: 465
Joined: 3/16/2005
Status: offline
|
RE: when I add or modify a record in ado ... - 8/17/2007 15:46:32
May update by
oRS.Addnew
....................
....................
oRS.update
or I must use ...... ?
primary keyis not an Autonumber ....
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
