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
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 />
