Re: reusing unique id's when deleting/inserting?

2001-03-19 Thread Tõnu Samuel
"Peter R. Wood - Mailing Lists" wrote: > When he deletes an assignment from the class, it deletes it from both tables. > > However, after this, if he adds an assignment again, the unique ID generated > by insertion into the assignment table is one greater than it should be - > i.e., it auto incr

reusing unique id's when deleting/inserting?

2001-03-18 Thread Peter R. Wood - Mailing Lists
Hi all, Here are two tables I'm working with. I apologize if you are not using a monospaced font and they are messed up. This is used by a gradebook program. When a professor adds an assignment to a class he teaches, it inserts the information about the assignment into the assignments table,