VbzCart/queries/qryCbx RstkReq: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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''... |
m →About: this may actually be inferior to the one I did in Access |
||
| 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 | ||
Latest revision as of 19:03, 22 December 2008
About
- Purpose: for use in drop-down lists
- Requires: qryRstkReq_by_status, qryRstkReq_by_PurchOrd
- History:
- 2008-12-22 Adapted from the 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.
- This version may actually be inferior to the one I created (recently) in Access. There's also a version for received restocks.
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 />
