Charta Software
Back to the base
E-mail:
Wachtwoord:
Aangemaakt door op 2009-05-25 12:40:59
Laatst gewijzigd op 2010-01-22 09:32:47

What to do with tcoSummable?

The option tcoSummable is used in SQL table columns to indicate that values in those columns can be summed and presented as a total to the user. The question is whether a table column should hold this property. Probably a type should hold this property instead.

Currently a TSQLTableColumn holds an Options property which can contain tcoSummable and tcoNullable. The latter, tcoNullable is already deprecated in favor of letting a TType descendant determine whether the type is nullable or not.

The question here is whether we should remove tcoSummable. Should it instead be a property of a TType? And if so, is Summable the correct term to use or should it be more generic and indicate that its values can be used in arithmetic expressions such as calculating an average as well?

If we decide to remove tcoSummable we can remove the Options property of an SQL table column altogether.