VbzCart/queries/qryCtg Titles active
Jump to navigation Jump to search
- Purpose: Brings up only ctg_titles records which are active, making it impossible for an inactive catalog to make an active title look inactive.
- Requires: ctg_titles
- 2009-05-03 Added to main server database (no change in design)
<mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS
SELECT * FROM ctg_titles AS tgt WHERE tgt.isActive AND ( ( tgt.WhenDiscont Is Null ) Or ( tgt.WhenDiscont>Now() ) );</mysql>