新年快乐！紧急求救！各位大侠，我有一个难题：我在用VC++6.0编写一个使用数据库的程序，但是无论如何都得不到SUM、COUNT等的统计结果。

[cqlzc]

[TaoJing]

我想知道你的原代码以及你的数据库结构。如果SQL语句没有问题的话应该可以检索到数据的。
不知道你是用什么方式访问数据库的。

[Frank0233]

............."$$$$$$$o...................ooooo
.............."$$$$$$$$$o.........ooo$$$$$$$$$
.......ooo$$$$$$$$$$$$$$$....oo$$$$$$$$$$$"""
.......$$$$$$$$$$$$$$$$o....o$$$$$$$"""
.........$$$$$$$"""o$$$$$$...$$$$$$
..........$$$$$$..o$$$$$"....$$$$$
..........$$$$$$.o$$$$$".....$$$$$.....ooo.oo$$$o
...........$$$$$$$$$$$$$$...$$$$$"...o$$$$$$$$$$$$
.........oo$$$$$$$$$$$""....$$$$$$$$$$$$$$$$$$$$$$
........."$$$$$$$$$$$ooo....$$$$$$$$$$$$$$$$"
..........."""$$$$$$$$$$$o..$$$$$$$$$$$$$$$$
...........oo$$$$$$$$$$$$"..$$$$.....$$$$$$$
......oo$$$$$$$$$$$$$""....o$$$$.....$$$$$$$
.....$$$$$$$$$$$$$$$$oooo..$$$$$.....$$$$$$$
.....$$$$$$$"."$$$$$$$$$$$$$$$$".....$$$$$$$
......""$$$....$$$$$$."$$$$$$$$......$$$$$$$
........$$$o..$$$$$$$......$$$$......$$$$$$$
......."$$$"oo$$$$$$$......$$$"......$$$$$$$
............$$$$$$$$"......""........$$$$$$"
.............""""....................$$$$$"
.....................................$$$$"
.....................................$$"
....................o$$$o......ooo$$$oo
..................o$$$$$$$oo$$$$$$$$$$$o
................o$$$$$$$$$$$$$$$$$$$$$$$
..............o$$$$$$"""$$$$$$$$$$$""
...........o$$$$$"".......""$$$$$$"
..........o$""".............$$$$$$ooo
......................ooooo$$$$$$$$$$$o
.....................$$$$$$$$$$$$$$$$$$
.....................$$$$$$$$$$$$$$"""
......................"""""$$$$$$$
................o$$$o......$$$$$$$.ooooooooooo
................$$$$$$oooo$$$$$$$$$$$$$$$$$$$$$
............oooo$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
.......oo$$$$$$$$$$$$$$$$$$$$$$$$$""""""""""""
.....o$$$$$$$$$$$$$$""""...$$$$$$$
.....$$$$$$$$"""...........$$$$$$$
......"""""................$$$$$$$
...........................$$$$$$$
...........................$$$$$$$
...........................$$$$$$
...........................$$$$$"
............................$$$
..............$$$$$o..........oooo
..............$$$$$$..........$$$$$o
.............o$$$$$..........o$$$$$$
.............$$$$$$..........$$$$$$$oooooo
.............$$$$$$.......ooo$$$$$$$$$$$$$$$o
.......$$o...$$$$$$$$o...$$$$$$$$$$$$$$$$$$$$
......$$$$...$$$$$$$$$..."$$$$$$$$$$$"$$$$$$"
.....o$$$$oo$$$$$$$$$......"$$$$$$"...$$$$$$
.....$$$$$$$$$$$$$$"........$$$$$"..o$$$$$"
.....$$$$$$.$$$$$..........$$$$$$$$$$$$$$$$$$$$oo
....."$$$$$.$$$$$.oooo$$$$$$$$$$$$$$$$$$$$$$$$$$$$
......""""..$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$"
............$$$$$$$$$$$$$$$$$$$""""
............$$$$$.""""""$$$$$$"
............$$$$$......o$$$$$".....oo$$oo
............$$$$$.....o$$$$$"......$$$$$$$$o
............$$$$$....o$$$$$........"$$$$$$$$o
............$$$$$...o$$$$"...........$$$$$$$$
............$$$$$...$$$"..............$$$$$$$
.............$$$$...""................"$$$$$
............."$$"......................""""
.......................$$$$o
......................o$$$$$o.........oooo
..............o$$$....$$$$$$........o$$$$$o
.............$$$$$.$$$$$$$$$$$$$o.o$$$$$$"
............$$$$$"o$$$$$$$$$$$$$$$$$$$$"oo
...........$$$$...$$$$$$$$"$$$$$$$$$$"o$$$$o
........o$$$$$..oo$$$$$$$..$$$$$$$$$$o$$$$$
........$$$$$$$$$$$$$$$$$oo$$$$$$$$$$$$$"
........"$$$$$$$$$$$$$$$$$$$$$$$$.$$$$$$$o
............o$$$$$$$$$$$$""$$$$$$$$$$"$$$$$
...........o$$$$.o$$$$$$$oo$$$$$$$$$$$$$$$$
..........o$$$$$$$$$$$$$$$$$$$$$$$$$$"$$$$"
.........o$$$$$$$"""$$$$$$$$$$$$""...."""
.........."$$""....."$$"$$$$$$ooooooo$$$$$$$$o
...............ooooo$$$$$$$$$$$$$$$$$$$$$$$$$$o
.......ooo$$$$$$$$$$$$$$$$$$$$$$$$$$""""""""""
......o$$$$$$$$$$$$$$"""$$$$$$....o$$$$o
......."$$$$$"$$$$......$$$$$$...."$$$$$$o
.........""..$$$$$......$$$$$$.....$$$$$$$o
.............$$$$$.....o$$$$$$......$$$$$$$
............."$$"...ooo$$$$$$$.......$$$$"
...................$$$$$$$$$"........"""

[cqlzc]

在DoFieldExchange函数中，RFX_Long(pFX, _T("[数量]"), m_number);可以将每一条记录中 的‘数量’字段的值放入没_m_number中，请问怎样修改
RFX_Long(pFX, _T("[数量]"), m_number）这一句，以使所有记录的‘数量’字段的值的总和放入变量m_number中。

[TaoJing]

那是不可能的，表中没有数量的字段。如果用OLE DB的话，可以使用字段帮定。如果使用ADO访问数据库的话，可以使用 _AdoRecordset,AdoFields,AdoField对象得到该字段的数据的。
你可以把你的程序发到[e-mail],我帮你看看。别忘了把数据库结构给我。

[TaoJing]

应该使用字段索引，不应该使用名称的。

[莫等闲]

第一步：把你的SQL语句放到数据库的SHEET中执行，看有没有得到正确结果
二：可以把得到的记录集合的所有字段都枚举出来，看有没有搞错