Difference between revisions of "VbzCart/queries/qryCtg Titles active"
Jump to navigation
Jump to search
(moved from single-page listing) |
|||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
==Details== | ==Details== | ||
− | * '''Purpose''': Brings up ''only'' | + | * '''Purpose''': Brings up ''only'' {{vbzcart|table|ctg_titles}} records which are active, making it impossible for an inactive catalog to make an active title look inactive. |
− | * '''Requires''': | + | * '''Requires''': {{vbzcart|table|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== | ==SQL== | ||
− | + | <mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS | |
SELECT | SELECT | ||
* | * | ||
Line 15: | Line 18: | ||
) | ) | ||
);</mysql> | );</mysql> | ||
− |
Latest revision as of 22:39, 2 March 2016
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>