RE: RE: What are you using instead of IDENTITY?

[Dave Watts]

> In my code as of late, I've grown distasteful of Identity
> fields, doing the best I can to find a Primary Key by any
> other means.  Identity fields are a last resort.

Distaste for a development practice, by itself, is not an adequate
justification for advocating an alternative development practice. What
caused this distaste?

> I remember one time I actually concatenated 7 fields of a 10
> field table to do a primary key. While it seemed weird, it
> worked wonderfully!

Did you have any foreign dependencies on that table?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.