![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211200.webp)
Examples
SECTION 12 Databases
199
COMPUTE rsOrders,
SUM(rsOrders.OrderTotal) AS CustTotal,
ANY(rsOrders.contactname) AS Contact
BY customerid
12-10-6 Multiple Groupings example:
SHAPE
(SHAPE {select customers.*, od.unitprice *
od.quantity as ExtendedPrice from (customers inner
join orders on customers.customerid =
orders.customerid) inner join [order details] as
od on orders.orderid = od.orderid} AS rsDetail
COMPUTE ANY(rsDetail.contactname) AS Contact,
ANY(rsDetail.region) AS Region,
SUM(rsDetail.ExtendedPrice) AS CustTotal, rsDetail
BY customerid) AS rsCustSummary
COMPUTE rsCustSummary
BY Region
12-10-7 Grand Total example:
SHAPE
(SHAPE {select customers.*, od.unitprice *
od.quantity as ExtendedPrice from (customers inner
join orders on customers.customerid =
orders.customerid) inner join [order details] as
od on orders.orderid = od.orderid} AS rsDetail
COMPUTE ANY(rsDetail.contactname) AS Contact,
SUM(rsDetail.ExtendedPrice) AS CustTotal, rsDetail
BY customerid) AS rsCustSummary
COMPUTE SUM(rsCustSummary.CustTotal) As GrandTotal,
rsCustSummary
12-10-8 Grouped Parent Related to Grouped Child example:
SHAPE
(SHAPE {select * from customers} APPEND ((SHAPE
{select orders.*, year(orderdate) as OrderYear,
month(orderdate) as OrderMonth from orders} AS
rsOrders
COMPUTE rsOrders BY customerid, OrderYear,
OrderMonth) RELATE customerid TO customerid) AS
rsOrdByMonth ) AS rsCustomers
COMPUTE rsCustomers BY region
Note:
The inner SHAPE clause in this example is identical to the statement used in
the Hierarchy with Aggregate example.
Note:
The missing BY clause in the outer summary. This defines the Grand Total
because the parent rowset contains a single record with the grand total and a
pointer to the child recordset.
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...