Hi, guys I am working on vb project, which will save client database.
I've done the coding of ADD, NEW, SAVE, EDIT button. Now, I am stuck at DELETE button. When I delete any particular client then I want my client_id (it's a column in my access database) should get updated (like if I have five clients in database and if I delete 3rd client, then the client_id should start from 1,2,3,4; not like 1,2,4,5)
No it shouldn't. Once assigned, a client ID should never be changed. It is their unique value used throughout the system. All records pertaining to that person should be using this number and not their name, so the change would be monumental in a 'real' database.
What do you think would happen in the real world if, when someone stops driving, all the driver's license numbers changed?
WaltP
Posting Sage w/ dash of thyme
10,507 posts since May 2006
Reputation Points: 3,348
Solved Threads: 944
WaltP is very right. Please all IDs should remain unique
Netcode
Veteran Poster
1,021 posts since Jun 2009
Reputation Points: 43
Solved Threads: 67
Hi,
Yes, Client_ID's should be Unique.
But still if, you want to renumber them, Change your code to :
Public Sub generateid()
Dim i As Integer
i = 1
If rs.State = 1 Then rs.Close
rs.Open "clientdetails", admincon, adOpenDynamic, adLockOptimistic
Do While Not rs.EOF
rs("Client_ID") = i
rs.Update
i = i + 1
rs.MoveNext
Loop
End Sub
Regards
Veena
But what about all the other database records in the other tables that have the ID in them?
WaltP
Posting Sage w/ dash of thyme
10,507 posts since May 2006
Reputation Points: 3,348
Solved Threads: 944