Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JmaC
Starting Member
18 Posts |
 Posted - 2010-08-20 : 23:35:42
|
| hi all...i have registration form with button DELETE,EDIT,INSERT..All working fine...example table:i have table with 5rows...1 | Peter2 | James3 | Helen4 | Nickles5 | Johnif i delete ID 3 (3|Helen) from table...1 | Peter2 | James4 | Nickles5 | Johnnow am going to register new person...what i need is when i click INSERT button in form ID:3 have to appear automatically in textbox/dropdownlist to register new person.(use deleted ID for register new person).i write coding for get ID:6 and it's working good...can anyone help me...thanks in advanceThanks & RegardsJmaC |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-20 : 23:49:59
|
| ummm, why? just let the new person be id = 6. |
 |
|
|
JmaC
Starting Member
18 Posts |
Posted - 2010-08-21 : 00:33:27
|
| i trying to keep order in database...my customer requirement:( |
|
|
|
|
|
|
Trigger in SQL to replace deleted ID to table