VbzCart/docs/queries/qryCtg build: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(moved from single-page listing)
 
imported>Woozle
(appears to be unused)
Line 1: Line 1:
==Details==
==Details==
* '''Status''': Appears to be unused -- not found in database
* '''Requires''': [[../qryCtg_build_sub|qryCtg_build_sub]]
* '''Requires''': [[../qryCtg_build_sub|qryCtg_build_sub]]
* '''Used by''':
* '''History''':
** '''2010-11-09''' marked as unused
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS

Revision as of 01:56, 10 November 2010

Details

  • Status: Appears to be unused -- not found in database
  • Requires: qryCtg_build_sub
  • History:
    • 2010-11-09 marked as unused

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build AS

 SELECT
   *,
   isForSale And Not IFNULL(isCloseOut,FALSE) AS isInPrint,
   IFNULL(ItOpt_Descr_part,NameSng) AS ItOpt_Descr
 FROM qryCtg_build_sub</mysql>

<section end=sql />