VbzCart/queries/qryCtgCk dup keys

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

About

  • Purpose: Verification of ctg build
  • Requires: ctg_upd2, cat_items
  • Used by: catalog building - verification stage
  • Returns: any duplicate IDS_Items (ID_Title + CatSfx) found in currently active titles in cat_items. When this happens, it is probably due to old records whose CatSfx fields weren't set (or weren't set properly) being (re)activated by being found in stock

SQL

<mysql>CREATE OR REPLACE VIEW qryCtgCk_dup_keys AS SELECT 

 i.CatNum,
 i.isInPrint,
 u.*

FROM ctg_upd2 AS u LEFT JOIN cat_items AS i ON u.ID_Item=i.ID WHERE cntDups and u.isForSale;</mysql>

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