⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 251.htm

📁 水木清华的BBS文章
💻 HTM
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>CTerm非常精华下载</title>
</head>
<body bgcolor="#FFFFFF">
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="577">
<tr><td width="32%" rowspan="3" height="123"><img src="DDl_back.jpg" width="300" height="129" alt="DDl_back.jpg"></td><td width="30%" background="DDl_back2.jpg" height="35"><p align="center"><a href="http://bbs.tsinghua.edu.cn"><font face="黑体"><big><big>水木清华★</big></big></font></a></td></tr>
<tr>
<td width="68%" background="DDl_back2.jpg" height="44"><big><big><font face="黑体"><p align="center">         Delphi编程                            (BM: strayli FlyingBoy)          </font></big></big></td></tr>
<tr>
<td width="68%" height="44" bgcolor="#000000"><font face="黑体"><big><big><p   align="center"></big></big><a href="http://cterm.163.net"><img src="banner.gif" width="400" height="60" alt="banner.gif"border="0"></a></font></td>
</tr>
<tr><td width="100%" colspan="2" height="454"> <p align="center">[<a href="index.htm">回到开始</a>][<a href="185.htm">上一层</a>][<a href="252.htm">下一篇</a>]
<hr><p align="left"><small>发信人: Zeemon (塞下秋), 信区: Visual <br>

标  题: Delphi3(5) <br>

发信站: BBS 水木清华站 (Tue Nov 11 19:59:08 1997) <br>

  <br>

下文由idol (沉默的人)在浙大BBS西子浣纱城站发表 <br>

  <br>

Decision Support Components <br>

--------------------------- <br>

When you use the Decision Query editor to create a query in <br>

TDecisionQuery, the query is initially handled in ANSI-92 SQL <br>

syntax, then translated (if necessary) into the dialect used <br>

by the server. The Decision Query editor reads and displays <br>

only ANSI standard SQL; the dialect translation, which is <br>

updated automatically, appears after the ANSI version in the <br>

String List editor for TDecisionQuery's SQL property. If you <br>

want to modify a query, edit the ANSI SQL. <br>

  <br>

The Decision Cube can pivot, subtotal, and drill-in correctly <br>

only for aggregators whose cells are additive. (SUM and COUNT <br>

are additive, while AVERAGE, MAX, and MIN are not additive.) <br>

Build pivoting crosstab displays only for additive aggregators; <br>

other aggregator types work correctly in static crosstab <br>

displays which do not pivot, drill, or subtotal. <br>



  <br>

Since AVERAGE can be calculated using SUM divided by COUNT, <br>

a pivoting average is added automatically whenever the COUNT <br>

and SUM aggregators for a field are included. Use this <br>

average in preference to an average calculated through an <br>

SQL statement. <br>

  <br>

Averages can also be calculated using COUNT(*). To use COUNT(*) <br>

to calculate averages, include a "COUNT(*) COUNTALL" selector <br>

in your query. If you use COUNT(*) to calculate averages, the <br>

single aggregator can be used for all fields. Use COUNT(*) in <br>

cases where none of your aggregated fields include blank values, <br>

or where a count aggregator is not available for every field. <br>

  <br>

The Decision Cube works best with a Decision Query, where the <br>

data can be traced back to database fields and aggregators. If <br>

you attempt to crosstab data from a non-query dataset (or in <br>

cases where the SQL cannot be analyzed by the Decision Cube), <br>

you may need to provide information manually about the dimension <br>

and summary fields. Fill in the Dimension Type to indicate whether <br>

a field is a dimension or provide the summary type. Since pivoting <br>

averages depend on SUM/COUNT calculations, you must also provide <br>

averages depend on SUM/COUNT calculations, you must also provide <br>

the base field name to allow the cube to match pairs of SUM/COUNT <br>

aggregators. If the base name is not available, you can use <br>

a "COUNT(*) COUNTALL" in the query to calculate averages as <br>

described above. <br>

  <br>

ActiveX and Remote Dataset Distribution <br>

--------------------------------------- <br>

If you deploy an application or library that (a) uses the StdVCL <br>

unit and the IStrings, IProvider, or IDataBroker interface, or <br>

(b) uses the Delphi font, color, strings, or picture property <br>

pages, you must also deploy the Borland standard VCL type library. <br>

This library comes in two forms: the STDVCL32.DLL library, and a <br>

stand-alone type library called STDVCL32.TLB. Both of these files <br>

are in your Windows\System directory. Applications and libraries <br>

that use the Delphi property pages must deploy STDVCL32.DLL, but <br>

applications and libraries that employ only the interfaces listed <br>

above may instead deploy STDVCL32.TLB. Once installed on the <br>

destination machine, STDVCL32.DLL or STDVCL32.TLB must be <br>

registered in the system registry. (The TRegSvr demo application <br>

provides an example of how to register DLL and TLB files.) <br>

  <br>

-- <br>



※ 来源:·BBS 水木清华站 bbs.net.tsinghua.edu.cn·[FROM: 162.105.118.41] <br>

</small><hr>
<p align="center">[<a href="index.htm">回到开始</a>][<a href="185.htm">上一层</a>][<a href="252.htm">下一篇</a>]
<p align="center"><a href="http://cterm.163.net">欢迎访问Cterm主页</a></p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -