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
(New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}} * '''Used by''': {{vbzcart/query|qryStkItms_for_sale}} * '''Note''': Eventually rename as "qryStkLines_for_sale" ==SQL...)
 
(obsolete)
 
(2 intermediate revisions 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"
 +
* '''History''':
 +
** '''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 v_stk_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>
Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryStk_lines_remaining_forSale&oldid=21377"