偶想从数据库里统计一个字段的和.就用了下面的句子(库名stat)
dim dbs as database
dim rs as recordset
dim sql as string
dbs=opendatabase(app.path+"/test.mdb",false,false,";pwd=123")
sql="select sum(成绩) as suma from stat where 姓名 like '王%'"
rs=dbs.openRecordset(sql,dbOpenDynaSet)
text1.text=rs("suma")-------出错了,没有取到值,到底是哪里出错了啊?请各位大侠赐教哈
dim dbs as database
dim rs as recordset
dim sql as string
dbs=opendatabase(app.path+"/test.mdb",false,false,";pwd=123")
sql="select sum(成绩) as suma from stat where 姓名 like '王%'"
rs=dbs.openRecordset(sql,dbOpenDynaSet)
text1.text=rs("suma")-------出错了,没有取到值,到底是哪里出错了啊?请各位大侠赐教哈
sql="select sum(成绩) as suma from stat where 姓名 like '王*'"
将SQL语句导出来,用查询编辑器执行一下!!
试试看啊
dim rs as new adodb.recordset
conn.open"XXXXXXXXXXXXXX"
rs.open"select sum(成绩) as suma from stat where 姓名 like '王%'"
set text1.text=rs.fileds("suma")