VbzCart/docs/pieces/catalog/building/2006: Revision history

25 February 2024

• curprev 01:5301:53, 25 February 2024‎ Woozle talk contribs‎ m 14,022 bytes 0‎ Woozle moved page VbzCart/VbzCart/pieces/catalog/building/2006 to VbzCart/docs/pieces/catalog/building/2006 without leaving a redirect: correct naming (was no way to import directly to this name)

1 February 2016

• curprev 20:4820:48, 1 February 2016‎ imported>Woozle‎ m 14,022 bytes 0‎ Woozle moved page VbzCart catalog building 2006 to VbzCart/pieces/catalog/building/2006 without leaving a redirect: this is where it goes in the archive
• curprev 20:4720:47, 1 February 2016‎ imported>Woozle‎ m 14,022 bytes 0‎ 61 revisions imported: moving page from VbzWiki

20 July 2007

• curprev 01:5601:56, 20 July 2007‎ imported>Woozle‎ m 14,022 bytes 0‎ VbzCart catalog building moved to VbzCart catalog building 2006: writing new version

10 November 2006

• curprev 00:3900:39, 10 November 2006‎ imported>Woozle‎ 14,022 bytes +339‎ →‎[Calc Items Avail] issues: two-stage process now

9 November 2006

• curprev 23:0223:02, 9 November 2006‎ imported>Woozle‎ m 13,683 bytes 0‎ →‎queries: fixed order of fields
• curprev 19:2819:28, 9 November 2006‎ imported>Woozle‎ 13,683 bytes +101‎ →‎Step 3: mods to first query
• curprev 19:1719:17, 9 November 2006‎ imported>Woozle‎ m 13,582 bytes −1‎ →‎Step 4: outdent
• curprev 19:1619:16, 9 November 2006‎ imported>Woozle‎ 13,583 bytes +29‎ →‎Step 4: sort existing items to update
• curprev 19:0319:03, 9 November 2006‎ imported>Woozle‎ m 13,554 bytes 0‎ →‎[Calc Items Avail] issues: redundant punctuation
• curprev 19:0219:02, 9 November 2006‎ imported>Woozle‎ 13,554 bytes +115‎ →‎Step 1: issues
• curprev 18:3718:37, 9 November 2006‎ imported>Woozle‎ 13,439 bytes +298‎ →‎Step 1: [Calc Items Avail] now permanent
• curprev 14:4914:49, 9 November 2006‎ imported>Woozle‎ 13,141 bytes −243‎ →‎Step 7: split query into select and insert-into parts, for debugging/clarity
• curprev 14:1914:19, 9 November 2006‎ imported>Woozle‎ 13,384 bytes +52‎ →‎Step 6: some wrong information fixed, and more explanation added

8 November 2006

• curprev 03:1403:14, 8 November 2006‎ imported>Woozle‎ 13,332 bytes +48‎ →‎Step 7: catext and catkey
• curprev 03:1303:13, 8 November 2006‎ imported>Woozle‎ 13,284 bytes +57‎ →‎Step 6: update catext and catkey too
• curprev 03:1203:12, 8 November 2006‎ imported>Woozle‎ 13,227 bytes +27‎ →‎Step 4: catnum needs to be updated too, because it can change
• curprev 03:1003:10, 8 November 2006‎ imported>Woozle‎ 13,200 bytes +54‎ →‎Step 4: also copy two new fields

6 November 2006

• curprev 16:4116:41, 6 November 2006‎ imported>Woozle‎ 13,146 bytes +146‎ →‎Step 3: another query for calculation(s) in Items
• curprev 03:0303:03, 6 November 2006‎ imported>Woozle‎ m 13,000 bytes +4‎ →‎Step 1: nz(catext)
• curprev 03:0003:00, 6 November 2006‎ imported>Woozle‎ 12,996 bytes −37‎ →‎Step 4: also using CatKey to join here
• curprev 02:5402:54, 6 November 2006‎ imported>Woozle‎ 13,033 bytes +52‎ →‎Step 1: CatKey field for joining (yes, another one)
• curprev 02:4602:46, 6 November 2006‎ imported>Woozle‎ 12,981 bytes +28‎ →‎Step 8: yet another field for joining
• curprev 02:4402:44, 6 November 2006‎ imported>Woozle‎ 12,953 bytes +24‎ →‎Step 3

5 November 2006

• curprev 23:3423:34, 5 November 2006‎ imported>Woozle‎ 12,929 bytes −15‎ →‎Step 4: joining using CatExt instead of old fields
• curprev 23:0223:02, 5 November 2006‎ imported>Woozle‎ m 12,944 bytes −4‎ →‎Step 1: SQL fix
• curprev 22:3022:30, 5 November 2006‎ imported>Woozle‎ 12,948 bytes +55‎ →‎Step 1: CatExt field
• curprev 15:5615:56, 5 November 2006‎ imported>Woozle‎ 12,893 bytes +434‎ →‎Step 1: changes got overwritten
• curprev 02:5102:51, 5 November 2006‎ imported>Woozle‎ 12,459 bytes −585‎ →‎Step 4: new calc fields; cat# no longer has to match, to allow for recycling of supplier cat#s

4 November 2006

• curprev 21:0221:02, 4 November 2006‎ imported>Woozle‎ 13,044 bytes +280‎ →‎Step 1: qryVb_ItemsNeeded_Ops
• curprev 18:4318:43, 4 November 2006‎ imported>Woozle‎ 12,764 bytes +161‎ →‎Step 1: some more calculated fields

19 July 2006

• curprev 21:0521:05, 19 July 2006‎ imported>Woozle‎ 12,603 bytes +56‎ →‎Step 4: need GroupTitleDescr as part of i.ITypDescr

11 July 2006

• curprev 12:3912:39, 11 July 2006‎ imported>Woozle‎ m 12,547 bytes −3‎ →‎Step 1: null -> 0

2 July 2006

• curprev 20:5520:55, 2 July 2006‎ imported>Woozle‎ 12,550 bytes +57‎ →‎Step 1: WhenDiscont IS NULL

29 June 2006

• curprev 18:1518:15, 29 June 2006‎ imported>Woozle‎ 12,493 bytes +2,078‎ →‎The Process: updates and explanations

24 June 2006

• curprev 18:5318:53, 24 June 2006‎ imported>Woozle‎ 10,415 bytes +279‎ →‎Step 4: id_item is null; explanation
• curprev 18:4818:48, 24 June 2006‎ imported>Woozle‎ 10,136 bytes +111‎ →‎Step 4: more SQL changes
• curprev 18:1018:10, 24 June 2006‎ imported>Woozle‎ 10,025 bytes +126‎ →‎Step 4: subqueryized

17 June 2006

• curprev 23:2223:22, 17 June 2006‎ imported>Woozle‎ 9,899 bytes −24‎ →‎Step 6: removed extra SET line
• curprev 23:1023:10, 17 June 2006‎ imported>Woozle‎ m 9,923 bytes +6‎ →‎Step 8: qry->qryVb_
• curprev 23:0923:09, 17 June 2006‎ imported>Woozle‎ 9,917 bytes +246‎ →‎Step 1: qryVb_ItemsNeeded_PreClean
• curprev 22:5922:59, 17 June 2006‎ imported>Woozle‎ m 9,671 bytes +258‎ →‎Step 1: small problem
• curprev 22:2322:23, 17 June 2006‎ imported>Woozle‎ 9,413 bytes +175‎ →‎Step 6: broken explanation
• curprev 22:2122:21, 17 June 2006‎ imported>Woozle‎ m 9,238 bytes −48‎ →‎Step 7: update -> append
• curprev 22:0022:00, 17 June 2006‎ imported>Woozle‎ m 9,286 bytes +3‎ →‎Step 1: qryFig -> qryVb_Fig
• curprev 21:5921:59, 17 June 2006‎ imported>Woozle‎ m 9,283 bytes +30‎ →‎Phase II: new prefix
• curprev 21:5821:58, 17 June 2006‎ imported>Woozle‎ m 9,253 bytes +4‎ →‎Step 2: new prefix
• curprev 21:5821:58, 17 June 2006‎ imported>Woozle‎ m 9,249 bytes +7‎ →‎Step 1: new prefix
• curprev 21:5321:53, 17 June 2006‎ imported>Woozle‎ m 9,242 bytes −11‎ →‎Step 3: now called qryVb_Items_ResetActive
• curprev 21:3721:37, 17 June 2006‎ imported>Woozle‎ 9,253 bytes −206‎ →‎The Process: removed step 3; moved query explanation down to step 8