我要查询数据库数据的最大值,使用如下语句:
On Error Resume Next
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strCnn As String
strCnn = "Driver=sqlserver};server=localhost;uid=sa;pwd=sa;" & _
"database=Example"
Dim selStr As String
selStr = "select MAX(Founds) from Founds where Year='" & year & "'" & _
"and DepartmentID='" & departmentID & "'"
cnn.Open strCnn
rs.Open selStr, cnn
If Not rs.EOF Then
getFounds = rs!founds
End If
rs.Close
cnn.Close
返回0,请指教!
On Error Resume Next
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strCnn As String
strCnn = "Driver=sqlserver};server=localhost;uid=sa;pwd=sa;" & _
"database=Example"
Dim selStr As String
selStr = "select MAX(Founds) from Founds where Year='" & year & "'" & _
"and DepartmentID='" & departmentID & "'"
cnn.Open strCnn
rs.Open selStr, cnn
If Not rs.EOF Then
getFounds = rs!founds
End If
rs.Close
cnn.Close
返回0,请指教!
解决方案 »
- VB中控制WEBBrowser滚动条向右滚动
- 为什么我的子窗体里的按钮,选项卡无法拖动了?
- 如何得知VSFLEXGRID中某行发生改变,需要UPDATE数据库。。。。
- 关于datareport的参数,如果我想查询某条件的纪录,怎么实现呢?
- 问:API是什么东东??
- 奇怪的问题,当我在VB中使用MediaPlayer6.4的控件时,如我指定文件名为“http://192.168.11.221/xxx/aaa.avi",也就是说为一url时,却无法
- 请问各位大侠哪里有下载msxml4及其以上版本的
- 我这个例子里缺了什么?”以及“我应该检查什么 ,为什么不对呢?
- 我想下载,刚注册还不是VIP会员,哎
- 在自己写的程序里经常要用到app.path,可是经常变成其他的东西.
- 在线等待,谢谢!
- datalist问题?在线等!!!!!!!!
selStr = "select MAX(Founds) from Founds where Year='" & year & "'" & _
"and DepartmentID='" & departmentID & "'"
cnn.Open strCnn
rs.Open selStr, cnn
If Not rs.EOF Then
getFounds = rs!founds
End If你的记录集里没有founds字段,你怎么取值呢,修改如下
selStr = "select MAX(Founds) as 最大值 from Founds where Year='" & year & "'" & _
"and DepartmentID='" & departmentID & "'"
cnn.Open strCnn
rs.Open selStr, cnn
If Not rs.EOF Then
getFounds = rs!最大值
End If试试
If Not rs.EOF Then
getFounds = rs!founds
End If
修改为
If Not rs.EOF Then
getFounds = rs.fields(0)
End If
就行了
"and DepartmentID='" & departmentID & "'"
Founds是表名吧
语句错
编程序时最好不使用
可以发现错误