> > Why not carry on using AUTONUMBER, and convert > > that field to IDENTITY if upsizing? > > Ordinarily I'd say that was what you should do (see below) > The trouble comes in when you have to pull the number out again,
You mean if you're doing SELECT MAX(ID) *after* an INSERT, to get the ID that's just been created, instead of creating a new ID *before* the INSERT for 'manual' numbering of the PK? Couldn't you use the loop/cftry/ cftransaction combo that Steve Nelson suggests for creating a new ID? Must say I'm totally baffled. I've still found no solid reason why people even bother concocting slick and wonderful 'workarounds' for the ID-creation 'problem'. Why not use the DB's autonumber/identity feature, and use the best method available (loop/try/transaction, or @@identity I guess) for grabbing a newly created ID? There's a lot of back-and-forth in this thread, some really useful info, but no overall idea of where we stand with this - pretty fundamental! - DB issue. Anyone who could sum it all up - or just post a link to such a thing :) - would get my gratitude for one! - Gyrus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
