I need some advice.
I began using CF & SQL 6.5 about 2 years ago.
I had several occurrences of a problem when using the "Identity"
column attribute to auto-assign IDs. (a MS-SQL bug caused the
appearance of duplicate keys & would lock the database until my host
performed a maintenance procedure).
To work-around, I began assigning IDs myself using the MAX(ID)
technique from the FuseBox method.
This has worked without problem, but I have always thought that this
was a bit of a kludge.
I have recently used the identity attribute with SQL 7.0 without
problem (but on databases with few inserts).
My question is this:
Does anyone have any good reason for using MAX(ID) over "Identity" on SQL &.0?
TIA
Dick
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
