Difference between revisions of "VbzCart/queries/qryCtg Titles active"
Jump to navigation
Jump to search
(moved from single-page listing) |
(added to main server database) |
||
| 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) | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Titles_active AS | ||
Revision as of 21:39, 3 May 2009
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)
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>