| Subject | RE: [firebird-support] Design Question: Storing and using generic text "tags" |
|---|---|
| Author | Jarrod Hollingworth |
| Post date | 2009-06-26T13:02:03Z |
Kjell wrote:
a) Allows the use of a trigger to do the tag creation work. ie. Use a simple
insert statement for a single ITEM row and the trigger gets the tags from
the TAGNAMES column.
b) Preserves the originally entered tags as typed by the user (for
presentation and editing for example).
Regards,
Jarrod Hollingworth
Complete Time Tracking
http://www.complete-time-tracking.com/
> What is the purpose of ITEM.TAGNAMES?It has two purposes:
a) Allows the use of a trigger to do the tag creation work. ie. Use a simple
insert statement for a single ITEM row and the trigger gets the tags from
the TAGNAMES column.
b) Preserves the originally entered tags as typed by the user (for
presentation and editing for example).
Regards,
Jarrod Hollingworth
Complete Time Tracking
http://www.complete-time-tracking.com/