[thelist] Max(ID) bad, what good?

Erik Mattheis gozz at gozz.com
Wed Jan 17 22:38:31 CST 2001


For an Access DB, I read that if you insert a new row in to a table 
and then immediately follow that with another SQL statement to SELECT 
Max(ID) you're not always going to get the ID of the record you want 
...

True or not?

What would you do?

(Using a different DB is not an option.)
-- 
- Erik Mattheis
http://gozz.com/
(612) 827 3963




More information about the thelist mailing list