DBGRID得使用 (15分)

F

fossil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-26

• #1

怎么把查询
USE pubs
SELECT type, price, advance
FROM titles
ORDER BY type
COMPUTE SUM(price), SUM(advance) BY type
结果在DBGRID中呈现出来

 

G

GanQuan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-27

• #2

如果安装的bpl，就到component->install packet中去remove.
如果是pas,就打开你安装的packet,如默认的dclusr.dpk，delete相应的pas,重新编译。

 

F

fossil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-28

• #3

不明白，在com[ent->install里面没有remove

 

P

payer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-28

• #4

如果安装的bpl，就到component->install packet中去看清楚内容选择去remove

 

F

fossil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-03-28

• #5

bpl是什么

 

M

mickeyzy1000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-16

• #6

使用query/database/datasource即可

 

道

道长

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-16

• #7

把sql语句写到adoquery.sql里，执行之
把datasource的dataset设为query
dbgrid的datasource设为datasource即可

 

F

fossil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-17

• #8

COMPUTE SUM(price), SUM(advance) BY type这个查询结果显现不出来

 

S

soft_man

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-17

• #9

同道长

 

L

lllttt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-17

• #10

COMPUTE SUM(price), SUM(advance) BY type
这句是什么作用？

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-30

• #11

哦，刚才order by搞错了

SELECT 1,type, price, advance
FROM titles
union all
SELECT 2,type, sum(price), sum(advance)
FROM titles
group by 2,type
order by 2,1

当然，显示的时候把第一列去掉

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-30

• #12

 

P

Pipi.

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-30

• #13

 

W

weekboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-30

• #14

在DBGRID中呈现出来你要的效果(分组统计效果格式),有点不可能.

 

B

beggar

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-30

• #15

DELPHI里可以实现分组统计效果格式吗？
例如：
部门 姓名 工资
aaa name1 500.36
aaa name2 500.36
合计 1000.72
bbbb name3 2003.25
bbbb name4 2055.36
合计 4058.61
ccc ................
用别的控件可以实现吗？有谁知道吗？

 

F

fossil

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-02

• #16

接受答案了.