User contributions for Woozle

30 November 2008

• 18:4918:49, 30 November 2008 diff hist −6,367 VbzCart/queries moved everything from "Catalog" section to separate pages
• 18:4818:48, 30 November 2008 diff hist +255 N VbzCart/queries/qryCbx Titles moved from single-page listing current
• 18:4718:47, 30 November 2008 diff hist +522 N VbzCart/queries/qryCat Titles web moved from single-page listing current
• 18:4518:45, 30 November 2008 diff hist +749 N VbzCart/queries/qryCat Titles Item stats moved from single-page listing
• 18:4318:43, 30 November 2008 diff hist +739 N VbzCart/queries/qryCat Titles moved from single-page listing
• 18:4018:40, 30 November 2008 diff hist +260 N VbzCart/queries/qryItTypsDepts ItTyps moved from single-page listing
• 18:4018:40, 30 November 2008 diff hist +408 N VbzCart/queries/qryItTypsDepts grpItems moved from single-page listing
• 18:3918:39, 30 November 2008 diff hist +262 N VbzCart/queries/qryTitles ItTyps Titles moved from single-page listing
• 18:3818:38, 30 November 2008 diff hist +350 N VbzCart/queries/qryTitles ItTyps ItTyps moved from single-page listing
• 18:3418:34, 30 November 2008 diff hist +1,769 N VbzCart/queries/qryTitles ItTyps grpItems moved from single-page listing
• 18:2818:28, 30 November 2008 diff hist +1,068 N VbzCart/queries/deprecated moved from single-page listing
• 18:2518:25, 30 November 2008 diff hist +493 N VbzCart/queries/qryCat Depts moved from single-page listing
• 18:2318:23, 30 November 2008 diff hist +29 N VbzCart data views VbzCart data views moved to VbzCart/queries: reorganizing current
• 18:2318:23, 30 November 2008 diff hist 0 m VbzCart/queries VbzCart data views moved to VbzCart/queries: reorganizing
• 17:2717:27, 30 November 2008 diff hist +1,399 VbzCart/queries →qryRstks_active: qryRstks_info
• 16:0216:02, 30 November 2008 diff hist +97 VbzCart/tables →cat_supp: +Notes field
• 02:5302:53, 30 November 2008 diff hist +686 MS Access and MySQL/connecting →Update error: subroutine code

25 November 2008

• 23:1923:19, 25 November 2008 diff hist +71 VbzCart/tables →Restocking: rstk req item minima
• 23:1823:18, 25 November 2008 diff hist +547 N VbzCart/tables/rstk req item minima New page: ==About== category:VbzCart/tables * '''History''': ** '''2008-11-25''' migrated from MS Access ==SQL== <section begin=sql /><mysql>CREATE TABLE `rstk_req_item_minima` ( `ID_ItemType`... current
• 14:4614:46, 25 November 2008 diff hist −419 m video sharing Reverted edits by C4tcdElrel (Talk); changed back to last version by Woozle
• 14:1814:18, 25 November 2008 diff hist +104 N RTP New page: category:acronymsRTP can stand for: * Research Triangle Park (in North Carolina) current
• 14:1614:16, 25 November 2008 diff hist +21 N Research Triangle Park Redirecting to RTP, NC current
• 02:0602:06, 25 November 2008 diff hist +80 VbzCart/queries →qryRstkItms_en_route: QtyRecd falls back on QtyFiled if null

24 November 2008

• 17:3817:38, 24 November 2008 diff hist −68 VbzCart/queries →qryRstks_active: got rid of JOIN -- further testing showed no clear advantage
• 12:1312:13, 24 November 2008 diff hist +55 m VbzCart/queries →qryRstkItms_active: requirements list
• 12:1212:12, 24 November 2008 diff hist +67 m VbzCart/queries →qryRstkItms_en_route: requirements list
• 12:1012:10, 24 November 2008 diff hist +38 m VbzCart/queries →qryItms_to_restock_union: completed "requires" list

23 November 2008

• 17:3917:39, 23 November 2008 diff hist +62 VbzCart/queries →qryRstkReq_Item_status_Req_info: +WhenMade
• 17:2317:23, 23 November 2008 diff hist −13 m VbzCart/queries →qryRstkReq_Item_status_Req_info: corrected "used by"
• 15:1315:13, 23 November 2008 diff hist +20 m VbzCart/queries →qryRstkReq_Item_status_Req_info: sorting
• 15:0615:06, 23 November 2008 diff hist +723 VbzCart/queries →qryRstkReq_Item_status: qryRstkReq_Item_status_Req_info
• 14:0614:06, 23 November 2008 diff hist +539 VbzCart/queries →qryRstkReq_Item_Rcd_status: WhenOrdered -> WhenFirstOrder (MIN), WhenFinalOrder (MAX)
• 02:4802:48, 23 November 2008 diff hist −28 VbzCart/queries →qryItms_to_restock: no longer to check QtyOnOrder for negativity: is now taken care of in source

22 November 2008

• 16:5116:51, 22 November 2008 diff hist +174 VbzCart/queries →qryItms_to_restock: QtyOnOrder should never be negative
• 16:4416:44, 22 November 2008 diff hist +49 m VbzCart/queries →qryItms_to_restock: a bit of documentation (requires qryItms_to_restock_union)
• 16:3916:39, 22 November 2008 diff hist +7 m VbzCart/queries →qryItms_to_restock_w_info: closed mysql tag, oops
• 16:3916:39, 22 November 2008 diff hist +99 VbzCart/queries →qryItms_to_restock_w_info: +ID_Supplier; using qryCat_Items instead of cat_items + cat_titles (+cat_depts)
• 16:2716:27, 22 November 2008 diff hist +230 VbzCart/queries →qryCat_Items: +isInPrint and some documentation
• 16:1916:19, 22 November 2008 diff hist +288 VbzCart/queries →qryOrdLines_PkgdQtys: 11/21 - added some fields and documentation
• 03:0003:00, 22 November 2008 diff hist +1,705 VbzCart/queries →v_rstk_lines_wItemInfo: more restock queries
• 00:3600:36, 22 November 2008 diff hist +418 VbzCart/queries →qryOrders_Active: alternate version

21 November 2008

• 02:1002:10, 21 November 2008 diff hist +133 VbzCart/queries →qryOrders_Active: WhenClosed (new field) must also be null
• 01:4501:45, 21 November 2008 diff hist +677 VbzCart/tables →core_orders: field reshuffling

20 November 2008

• 23:1923:19, 20 November 2008 diff hist +44 VbzCart/queries →qryItms_to_restock_w_info: more fields: in print, prices
• 20:0520:05, 20 November 2008 diff hist −62 m Help:Sandbox removing test text
• 19:5819:58, 20 November 2008 diff hist 0 m Help:Sandbox testing again
• 19:5519:55, 20 November 2008 diff hist +11 m Help:Sandbox testing spam regex
• 16:1116:11, 20 November 2008 diff hist +189 m VbzCart/queries →qryItms_to_restock_w_info: specs
• 16:1016:10, 20 November 2008 diff hist +323 VbzCart/queries →qryItms_to_restock: qryItms_to_restock_w_info
• 14:2314:23, 20 November 2008 diff hist +10 m VbzCart/queries →qryItms_to_restock: updated history