VbzCart/docs/procs/update cat items fr qryCtg build: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (rescued from database, and dropped) |
m (Woozle moved page VbzCart/VbzCart/procs/update cat items fr qryCtg build to VbzCart/docs/procs/update cat items fr qryCtg build without leaving a redirect: part 2) |
(No difference)
| |
Latest revision as of 01:55, 25 February 2024
About
- Status: Apparently disused.
- Requires: Template:Vbzcart, Template:Vbzcart/query
- History:
- 2010-11-09 Found this procedure in the database, but could not identify where it was being used. As there was no documentation of it either, I am documenting it here and removing it from the database.
SQL
<mysql> DROP PROCEDURE IF EXISTS `update_cat_items_fr_qryCtg_build`; CREATE PROCEDURE `update_cat_items_fr_qryCtg_build`()
UPDATE qryCtg_build AS r LEFT JOIN cat_items AS i ON r.ID_Item=i.ID SET i.CatNum = r.CatNum, i.isForSale = r.isForSale, i.isInPrint = r.isInPrint, i.isCloseOut = r.isCloseOut, i.isPulled = FALSE, i.isDumped = FALSE, i.ID_ItTyp = r.ID_ItTyp, i.ID_ItOpt = r.ID_ItOpt, i.ItOpt_Descr = IFNULL(r.ItOpt_Descr,i.ItOpt_Descr), i.ItOpt_Sort = r.ItOpt_Sort, i.ID_ShipCost = r.ID_ShipCost, i.PriceBuy = r.PriceBuy, i.PriceSell = r.PriceSell, i.PriceList = r.PriceList, i.GrpCode = r.GrpCode, i.GrpDescr = r.GrpDescr, i.GrpSort = r.GrpSort, i.CatSfx = r.CatSfx WHERE r.ID_Item IS NOT NULL;</mysql>