English 中文(简体)
戴尔菲的支流桌子怎么编码?
原标题:How do you code a pivot table in Delphi?

我同时学习数据库(通过存取),编程界面与 db s(通过德尔斐),以及连接两个数据库(通过MS SS SQL)-所以请原谅我在这里出现任何新的混乱.我正在使用教师分级簿作为帮助我学习的榜样。我理解学生及其分级之间的关系是多方面的。我可以设置基础表格和关系,我可以查询基础数据库。

我无法理解的是,如何显示/报告学生和年级,例如,在行中电子表格学生、列中任务、单元格中分数时,如何以通常的方式显示/报告学生和年级。 加上一个加点,即任务随着课程的继续而增加;在规划数据库字段时,人们并不了解所有任务。

一种解决办法可能相当于MS spivot 表格概念。 这是否很容易用德尔菲(Delphi ) 来完成? 是否有更简单的替代方案? (也许可以用学生姓名和个别分配名称的字段单列一张表格? )

最佳回答

打开访问, 从查询向导中创建一个新查询, 然后选择 Crosstab 查询向导 。 此努力应该有助于您理解访问轴查询能力; 访问中不存在连接为连接 < em> 可 < / em > 的东西。 找出您需要的访问查询, 然后从 Delphi 中找出如何打开访问查询 。 目前您的问题是访问, Delphi 问题只是附带的 。

问题回答

暂无回答




相关问题
determining the character set to use

my delphi 2009 app has a basic translation system that uses GNUGetText. i had used some win API calls to prepare the fonts. i thought it was working correctly until recently when someone from Malta ...

Help with strange Delphi 5 IDE problems

Ok, I m going nuts here. For the last (almost) four years, I ve been putting up with some extremely bad behavior from my Delphi 5 IDE. Problems include: Seemingly random errors in coride50.bpl ...

How to write a Remote DataModule to run on a linux server?

i would like to know if there are any solution to do this. Does anyone? The big picture: I want to access data over the web, using my delphi thin clients. But i´would like to keep my server/service ...

How convert string to integer in Oxygene

In Delphi, there is a function StrToInt() that converts a string to an integer value; there is also IntToStr(), which does the reverse. These functions doesn t appear to be part of Oxygene, and I can ...

Quick padding of a string in Delphi

I was trying to speed up a certain routine in an application, and my profiler, AQTime, identified one method in particular as a bottleneck. The method has been with us for years, and is part of a "...

热门标签