From: Sean O'Dell Date: 2004-07-29T10:29:03+09:00 Subject: Re: Stupid ODBC! On Wednesday 28 July 2004 18:04, Carl Youngblood wrote: > Why not take the approach of using a autoid function if you have it > but creating an extra table for storing counters if you don't? This > seems like a perfectly acceptable solution. If portability is not much of an issue, and the autoid implementation works properly (i.e. doesn't just +1 to the highest ID), this should be fine. If you ever expect to port it to other engines, or the autoid is like MySQL's is, or at least used to be, autoid is pretty dicey. Sean O'Dell