VbzCart/queries/qryCtg Titles active
Jump to navigation
Jump to search
Details
- 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
- History:
- 2009-05-03 Added to main server database (no change in design)
- 2016-03-02 This query no longer works, and (coincidentally) should no longer be needed.
SQL
<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>