https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCbx_Items_for_sale 2026-07-08T03:33:02Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryCbx_Items_for_sale&diff=10891&oldid=prev 2008-11-30T19:10:39Z

<p>moved from single-page listing</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../qryCbx_Items_data|qryCbx_Items_data]]<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;:<br /> * &#039;&#039;&#039;Notes&#039;&#039;&#039;:<br /> ** Future refinement: no need to display CatNum, Supp_CatNum, i.Descr if i.isPulled<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;????-??-??&#039;&#039;&#039; Added more fields for forms which want to display Descr from this query but also need those fields (e.g. Restock Items form):<br /> *** &#039;&#039;&#039;ID_Title&#039;&#039;&#039;, &#039;&#039;&#039;CatNum&#039;&#039;&#039;, &#039;&#039;&#039;PriceSell&#039;&#039;&#039;, &#039;&#039;&#039;QtyMin_Stk&#039;&#039;&#039;<br /> ** &#039;&#039;&#039;????-??-??&#039;&#039;&#039; Added &#039;&#039;&#039;isPulled&#039;&#039;&#039; so [[../qryCbx_Items_active|qryCbx_Items_active]] can display only non-pulled items (less bandwidth = faster loading)<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryCbx_Items_for_sale AS<br /> SELECT ID, Descr<br /> FROM qryCbx_Items_data<br /> WHERE isForSale<br /> ORDER BY CatNum;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle