Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
> The identity columns are always called ID - a habit I picked up years > ago and don't plan on breaking in the future - so you could use the > column name reliably in the code to identify them. The trick is > getting the correct one after the insert (since on a busy server many > clients may be creating rows at the same time). No, the trick is to ask the database for an ID and use this ID for the insert. The autoincrement feature of some DBs is only a convenient for this, but performs the same internally. No matter how many clients are connected, the database guarantees that a sequence-generated ID is valid. Olaf