VbzCart/queries/qryCtg Titles active
< VbzCart | queriesJump to navigation Jump to search
Revision as of 19:55, 30 November 2008 by Woozle (moved from single-page listing)
- 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
<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>