VbzCart/queries/qryCtg Titles active

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, 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>