> One thing to watch out for is the actual use of IDENTITY as a
> FK column in another table. If you are doing this, you have a
> disaster waiting to happen... (true for any DB, SQLSERVER,ORACLE,
> SYBASE, etc)
Do you mean that you shouldn't have a foreign key point to a primary key
that's an identity column, or that you shouldn't define a foreign key itself
as an identity column? I'd agree with the second, but not the first.
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.
