VbzCart/queries/qryCbx Items for sale

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
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Details

  • Requires: qryCbx_Items_data
  • Used by:
  • Notes:
    • Future refinement: no need to display CatNum, Supp_CatNum, i.Descr if i.isPulled
  • History:
    • ????-??-?? Added more fields for forms which want to display Descr from this query but also need those fields (e.g. Restock Items form):
      • ID_Title, CatNum, PriceSell, QtyMin_Stk
    • ????-??-?? Added isPulled so qryCbx_Items_active can display only non-pulled items (less bandwidth = faster loading)

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_Items_for_sale AS SELECT ID, Descr FROM qryCbx_Items_data WHERE isForSale ORDER BY CatNum;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCbx_Items_for_sale&oldid=10891"