Set rs = db.Execute("select * from XXX.EXCHANGE_RATE where EXTRACT_DATE=#20020520#")
解决方案 »
- vb通过ADO COMMAND执行存储过程,“对象关闭时,不允许操作”
- 启动VB6后的那个“新建、现存、最新”的对话框,没有保存前一次关机时的状态,是怎么回事呢?
- 请问是不是每产生一个.frm窗体的同时必产生一个.frx文件呢,谢谢谢谢了!!!
- 动态绑定DataGrid的问题
- 请问从哪里下载 Microsoft Data Engine 呀!
- help me!
- 请帮忙看看下面这段代码都表示什么意思
- 菜鸟给分了!
- 为什么这的SHTML页面不响应键盘??
- 如何用API实现套印???急!急!!!!
- 怎样利用FileSystemObject来读一个文本文件,请问
- 高分求救,怎样在中文系统下VB作的应用程序的文本框中输入日文?
Public Function dbConnect() As Integer
Set dbConnection = New Connection
With dbConnection
.CursorLocation = adUseClient
.Provider = "SQLOLEDB;"
.ConnectionString = "uid=...;dsn=...;pwd=...;database=.."
.Open
End With
end Function
Public Function RecordSetOpen(strQuery As String) As Recordset
Set RecordSetOpen = New Recordset
With RecordSetOpen
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.ActiveConnection = dbConnection
.PageSize = 50
.CursorLocation = adUseClient
.Open strQuery
End With
Exit Function
Exit Function
Dim db As ADODB.Connection
Dim rs As ADODB.RecordsetSet db = New ADODB.Connection
Set rs = New ADODB.Recordsetdb.ConnectionString = "provider=ibmdadb2;dsn=...;uid=dwuser;pwd=dwuser;database=..."
db.Open
db.CursorLocation = adUserClient
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Set rs = db.Execute("select * from XXX.EXCHANGE_RATE where EXTRACT_DATE='20020520'")rs.MoveLastDim max As Integer
max = rs.RecordCount
Text1.Text = max
Text2.Text = rs.Fields("CRTYPE")rs.Close
Set rs = Nothing
db.Close
Set db = Nothing
因为令
Text2.Text = rs.Fields("CRTYPE")
有显示第一条记录正确字段值。
难道打开的记录集是循环链表,指针指在...也不对啊
sql语句错误
Set rs = db.Execute("select * from XXX.EXCHANGE_RATE where EXTRACT_DATE='20020520'")
XXX.EXCHANGE_RATE 应是表名XXX而不是字段
满意了吧!
嗯?“变量或类型不正确,或者不在可以接受的范围内...”发生在哪一行?
就是这的毛病。代码如下: Private Sub Form_Load()
Dim db As Connection
Dim rs As Recordset
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
With db
.CursorLocation = adUseClient
.Provider = "SQLOLEDB;"
.ConnectionString = "User ID=sa;Data Source = citsql;Initial Catalog = pmpdb"
.Open
End With
Set rs = db.Execute("select * from jobs") rs.MoveLast
MsgBox rs.RecordCount
rs.Close
Set rs = Nothing
db.Close
Set db = NothingEnd Sub
db.CursorLocation = adUserClient
的位置不太正确,应该在打开数据库之前定义属性。
即
db.ConnectionString = "provider=ibmdadb2;dsn=...;uid=dwuser;pwd=dwuser;database=... "
db.CursorLocation = adUserClient
db.Open
不过,同样感谢,有分相送。呵呵
呵呵,笔误,笔误。