Difference between revisions of "VbzCart/queries/qryStk lines remaining forSale"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(updated because of name-change in underlying query)
(obsolete)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
==Details==
 
==Details==
* '''Requires''': {{vbzcart/query|v_stk_lines_remaining}}
+
* '''Obsolete''': use '''VCT_StkLines::SQL_forRemaining_forSale()''' instead
 +
* '''Requires''': {{vbzcart/query|qryStk_lines_remaining}}
 
* '''Used by''': {{vbzcart/query|qryStkItms_for_sale}}
 
* '''Used by''': {{vbzcart/query|qryStkItms_for_sale}}
 
* '''Note''': Eventually rename as "qryStkLines_for_sale"
 
* '''Note''': Eventually rename as "qryStkLines_for_sale"
Line 6: Line 7:
 
** '''2009-11-29''' Updated to reflect name change of source query
 
** '''2009-11-29''' Updated to reflect name change of source query
 
==SQL==
 
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_forSale AS
+
<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_forSale AS
 
   SELECT *
 
   SELECT *
 
   FROM qryStk_lines_remaining
 
   FROM qryStk_lines_remaining
 
   WHERE QtyForSale>0;</mysql>
 
   WHERE QtyForSale>0;</mysql>
<section end=sql />
 

Latest revision as of 02:01, 31 December 2015

Details

  • Obsolete: use VCT_StkLines::SQL_forRemaining_forSale() instead
  • Requires:
  1. REDIRECT Template:l/vc/query
  • Used by: qryStkItms_for_sale
  • Note: Eventually rename as "qryStkLines_for_sale"
  • History:
    • 2009-11-29 Updated to reflect name change of source query

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining_forSale AS

 SELECT *
 FROM qryStk_lines_remaining
 WHERE QtyForSale>0;</mysql>