VbzCart/docs/queries/qryCtg Titles active

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

SQL

<section begin=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>

<section end=sql />