请高手指点~~~Option Compare Database
Option Explict
Public Function GetRS(ByVal strQuery As String) As ADODB.Recordset
Dim rs As New ADODB.Resordset
Dim conn As New ADODB.Connection
On Error GoTo GetRS_Error
Set conn = CurrentProject.Connection
rs.Open strQuery, conn, adOpenKeyset, adLockOptimistic
Set GetRS = rs
GetRS_Exit:
Set rs = Nothing
Set conn = Nothing
Exit Function
GetRS_Error:
MsgBox (Err.Description)
Resume GetRS_Exit
End FunctionPublic Sub ExecuteSQL(ByVal strCmd As String)
Dim conn As New ADODB.Connection
On Error GoTo ExecuteSQL_Error
Set conn = CurrentProject.Connection
conn.Execute Trim$(strCmd)
ExecuteSQL_Exit:
Set conn = Nothing
Exit Sub
ExecuteSQL_Error:
MsgBox (Err.Description)
Resume ExecuteSQL_Exit
End Sub
Option Explict
Public Function GetRS(ByVal strQuery As String) As ADODB.Recordset
Dim rs As New ADODB.Resordset
Dim conn As New ADODB.Connection
On Error GoTo GetRS_Error
Set conn = CurrentProject.Connection
rs.Open strQuery, conn, adOpenKeyset, adLockOptimistic
Set GetRS = rs
GetRS_Exit:
Set rs = Nothing
Set conn = Nothing
Exit Function
GetRS_Error:
MsgBox (Err.Description)
Resume GetRS_Exit
End FunctionPublic Sub ExecuteSQL(ByVal strCmd As String)
Dim conn As New ADODB.Connection
On Error GoTo ExecuteSQL_Error
Set conn = CurrentProject.Connection
conn.Execute Trim$(strCmd)
ExecuteSQL_Exit:
Set conn = Nothing
Exit Sub
ExecuteSQL_Error:
MsgBox (Err.Description)
Resume ExecuteSQL_Exit
End Sub
解决方案 »
- run-time error '-2147467259(80004005):[Microsoft][ODBC SQL Server Driver] [DBNET
- vb保存到注册表后备份
- 如何比较日期大小
- ■ 如何 向 数据库 中 批量 添加记录
- 关于一个水库水纹的曲线问题
- 有谁知道,当按窗口右上角的"关闭",把此主窗口和它的子窗口全部关掉的代码吗?在线等,急!
- 在datagrid没有绑定datasource的情况下如何在datagrid上直接编辑输入数据?
- 这段话看看有什么错误呀?答对100分
- 请问怎样将字符串变量变成整型从而能用INSERT INTO 插入数据库,另问插入整型怎样写?
- 一个"有一点不太规则"的txt导入access表的问题~~
- 请教各位一个关于TEXT的简单问题
- list作为参数的函数问题
拼写错误应该是
Option Explicit