>> The fact remains, some things are just that, flags... no further information necessary, no updating required. <<

I define a flag as a binary value which is set by an event. Can you
give me an example of a flag that is set without an event? People
keep trying to model yes/no questions a survey with flags. They get
screwed up when they need more status codes such as "not answered", "N/
A", "contradictory", etc. As you so nicely put it: "Real world design
and development dictates a little more flexibility than that."

--CELKO-- (jcelko212@earthlink.net) writes:
> I define a flag as a binary value which is set by an event. Can you
> give me an example of a flag that is set without an event?

Can you give example on any database column that is not set as the
result of an event.

In our database, the accounts table has an istemplate column. It never
changes during the lifetime of an account, but obviously the fact
that the account was created is an event.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx