Difference between revisions of "VbzCart/queries/qryCtg Titles active"
Jump to navigation
Jump to search
(moved from single-page listing) |
(No difference)
|
Revision as of 19:55, 30 November 2008
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
<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>