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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-17 : 16:50:11
|
Jos writes "Hello Sirs and Ma'ams,
First of all I am using Win2K Pro wih Acces2K.
I have made a news module so most pages can include dynamic news etc. One of the requested features was to be able to delete these news atricles after a certain amount of time. Now this time is not preset to 4 months or anything. It's when the webmaster see's fit to delete them.
As I deleted news item I noticed I used a 'browser' to goto either the next or previous news item in the list.
So let's say I have 10 news items and I deleted 3 and 7.
When starting at Item 1 and pressing next I would simply goto 2 but then when I press next it wants to goto 3 but I just deleted that item.
So my question would be then:
Is there a way to update the AutoNumber Field NewsID in my case so the numbers are 1 trough 8, or to detect if a record is empty and skips it so the next is displayed and if that one is empty find the first non empty record? I have looked on many sites and search many times. But I have not been able to find anything about this particular issue.
Thanks for reading this and for your time I hope you can provide me with a neat-o solution! :)
Jos
The Netherlands" |
|
|
|
|
|
Updating AutoNumber Fields after Delete