VbzCart data views

Woozle — Sat, 04 Oct 2008 19:57:30 GMT

qryOrdLines_to_restock - fixed MS Access dependencies

←Older revision		Revision as of 19:57, 4 October 2008
(One intermediate revision not shown.)
Line 800:		Line 800:
	SELECT		SELECT
	ID_Item,		ID_Item,
-	nz(i.ID_OrdLine) AS ID_OrdLine,	+	i.ID_OrdLine,
-	nz(i.ID_Order) AS ID_Order,	+	i.ID_Order,
	Sum(i.QtyOrd) AS QtyOrd,		Sum(i.QtyOrd) AS QtyOrd,
	Sum(i.QtyDone) AS QtyDone,		Sum(i.QtyDone) AS QtyDone,
Line 807:		Line 807:
	Sum(i.QtyOnHand) AS QtyOnHand,		Sum(i.QtyOnHand) AS QtyOnHand,
	Max(i.QtyMin) AS QtyMin,		Max(i.QtyMin) AS QtyMin,
-	Max(CLng(nz(i.QtyMin)))+Sum(nz(i.QtyOrd)-nz(i.QtyOnRstk)-nz(i.QtyOnHand)) AS QtyToGet,	+	Max(IFNULL(i.QtyMin,0))+Sum(IFNULL(i.QtyOrd,0)-IFNULL(i.QtyOnRstk,0)-IFNULL(i.QtyOnHand,0)) AS QtyToGet,
-	Sum(nz(i.QtyOrd)-nz(i.QtyOnRstk)-nz(i.QtyOnHand)) AS QtyShort,	+	Sum(IFNULL(i.QtyOrd,0)-IFNULL(i.QtyOnRstk,0)-IFNULL(i.QtyOnHand,0)) AS QtyShort,
	Min(i.WhenOldestOrder) AS WhenOldestOrder,		Min(i.WhenOldestOrder) AS WhenOldestOrder,
	Min(i.WhenSoonestDue) AS WhenSoonestDue,		Min(i.WhenSoonestDue) AS WhenSoonestDue,
	Count(ID_RstkItem) AS RstkLines		Count(ID_RstkItem) AS RstkLines
	FROM qryOrdLines_ord_status AS i		FROM qryOrdLines_ord_status AS i
-	GROUP BY ID_Item, nz(ID_OrdLine), nz(ID_Order)	+	GROUP BY ID_Item, ID_OrdLine, ID_Order
-	HAVING Max(CLng(nz(i.QtyMin)))+Sum(nz(i.QtyOrd)-nz(i.QtyOnRstk)-nz(i.QtyOnHand))>0;</mysql>	+	HAVING Max(IFNULL(i.QtyMin,0))+Sum(IFNULL(i.QtyOrd,0)-IFNULL(i.QtyOnRstk,0)-IFNULL(i.QtyOnHand,0))>0;</mysql>
	<section end=sql />		<section end=sql />
		+
	====qryFrm_OrdLines_to_restock====		====qryFrm_OrdLines_to_restock====
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryFrm_OrdLines_to_restock AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryFrm_OrdLines_to_restock AS
Line 825:		Line 826:
	ci.PriceSell,		ci.PriceSell,
	ci.PriceBuy		ci.PriceBuy
-	FROM qryOrderItems_toRestock AS qi	+	FROM qryOrdLines_to_restock AS qi
	LEFT JOIN qryCat_Items AS ci ON ci.ID=qi.ID_Item;</mysql>		LEFT JOIN qryCat_Items AS ci ON ci.ID=qi.ID_Item;</mysql>
	<section end=sql />		<section end=sql />
		+
	====qryStk_lines_Title_info====		====qryStk_lines_Title_info====
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info AS

languages for learning programming

Woozle — Sat, 04 Oct 2008 14:52:13 GMT

Languages for Kids - Scratch animation language

←Older revision		Revision as of 14:52, 4 October 2008
Line 32:		Line 32:
	* [http://www.scheme.org/ Scheme]		* [http://www.scheme.org/ Scheme]
	** references: [http://www.drscheme.org/ Dr. Scheme] \| [http://www.htdp.org/ How to Design Programs] \| [http://www.teach-scheme.org/ Teach Scheme Project]		** references: [http://www.drscheme.org/ Dr. Scheme] \| [http://www.htdp.org/ How to Design Programs] \| [http://www.teach-scheme.org/ Teach Scheme Project]
		+	* [http://scratch.mit.edu/ Scratch]: animation language. Free downloads for Windows and Mac as of 2008-10-04.
	* [http://www.squeak.org/ Squeak Smalltalk]		* [http://www.squeak.org/ Squeak Smalltalk]
	** references: [http://www.squeakland.org/ Squeakland] \| [http://www.ofset.org/freeduc-cd FreeDuc LiveCD with Squeak]		** references: [http://www.squeakland.org/ Squeakland] \| [http://www.ofset.org/freeduc-cd FreeDuc LiveCD with Squeak]

HTYP - Recent changes [en]

VbzCart data views

languages for learning programming