Woozle: /* About */ this may actually be inferior to the one I did in Access

2008-12-22T19:03:30Z

About: this may actually be inferior to the one I did in Access

← Older revision		Revision as of 19:03, 22 December 2008
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2008-12-22''' Adapted from the [[../discarded\|discarded]] query qryCbxRestock		** '''2008-12-22''' Adapted from the [[../discarded\|discarded]] query qryCbxRestock
	* '''Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.		* '''Notes''':
			** MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.
			** This version may actually be inferior to the one I created (recently) in Access. There's also a version for received restocks.

	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS

Woozle: New page: ==About== * '''Purpose''': for use in drop-down lists * '''Requires''': {{vbzcart/query|qryRstkReq_by_status}}, {{vbzcart/query|qryRstkReq_by_PurchOrd}} * '''History''': ** '''2008-12-22''...

2008-12-22T18:58:28Z

New page: ==About== * '''Purpose''': for use in drop-down lists * '''Requires''': {{vbzcart/query|qryRstkReq_by_status}}, {{vbzcart/query|qryRstkReq_by_PurchOrd}} * '''History''': ** '''2008-12-22''...

New page

==About==
* '''Purpose''': for use in drop-down lists
* '''Requires''': {{vbzcart/query|qryRstkReq_by_status}}, {{vbzcart/query|qryRstkReq_by_PurchOrd}}
* '''History''':
** '''2008-12-22''' Adapted from the [[../discarded|discarded]] query qryCbxRestock
* '''Notes''': MySQL gives a "query cancelled" error when running this SQL to create the view, but actually it creates it just fine.
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_RstkReq AS
SELECT * FROM qryRstkReq_by_status WHERE Descr IS NOT NULL
UNION
SELECT * FROM qryRstkReq_by_PurchOrd WHERE Descr IS NOT NULL;</mysql>
<section end=sql />

VbzCart/queries/qryCbx RstkReq - Revision history

Woozle: /* About */ this may actually be inferior to the one I did in Access

Woozle: New page: ==About== * '''Purpose''': for use in drop-down lists * '''Requires''': {{vbzcart/query|qryRstkReq_by_status}}, {{vbzcart/query|qryRstkReq_by_PurchOrd}} * '''History''': ** '''2008-12-22''...