How can I Manipulate GENERATORS?

[popovski]

DESCRIPTION
I' ve written a Delphi Application which includes a database.
This database contains three generators (NB_CD,NB_SONG,NB_ARTIST), they increase(+1) each time I add a cd,song,artist.
PROBLEM
I must now manage to reassign old values of NB_CD, NB_SONG, NB_ARTIST from cd,songs,artist which have been deleted.
EXEMPLE
I introduce 4 CD in my database:
CD number 1(<-NB_CD!),CD number 2,...
Then I delete CD number 2 (1,3,4 left!)
HOW can I now add a new CD WITH NUMBER 2(not forgetting next CD 'll be number 5)

 

[jhall156]

It'll help me if you can tell me why you would want to do this. If you're using these ID's as surrogate keys then I would think the missing values would not concern you very much. So to what end are you using these ID's ?