VbzCart/queries/qryCbx Items for sale
Jump to navigation
Jump to search
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)
- ????-??-?? Added more fields for forms which want to display Descr from this query but also need those fields (e.g. Restock Items form):
SQL
<mysql>CREATE OR REPLACE VIEW qryCbx_Items_for_sale AS SELECT ID, Descr FROM qryCbx_Items_data WHERE isForSale ORDER BY CatNum;</mysql>