Difference between revisions of "VbzCart/queries/qryCbx Items for sale"
Jump to navigation
Jump to search
(moved from single-page listing) |
(No difference)
|
Latest revision as of 19:10, 30 November 2008
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>