Public Function ExecuteSQL(PsSql As String) As Boolean
Dim lErrCode As Long
Dim sMessage As String
Dim sExeSql As String
On Error GoTo ErrorHandler
sExeSql = PsSql
modbObject.LastServerErrReset
modbObject.ExecuteSQL (sExeSql)
ExecuteSQL = RESULT_BOOL_OK
ErrorHandler:
Exit Function
End Function================================================================ok?
Dim lErrCode As Long
Dim sMessage As String
Dim sExeSql As String
On Error GoTo ErrorHandler
sExeSql = PsSql
modbObject.LastServerErrReset
modbObject.ExecuteSQL (sExeSql)
ExecuteSQL = RESULT_BOOL_OK
ErrorHandler:
Exit Function
End Function================================================================ok?
解决方案 »
- 数据库的连接代码问题
- 关于取消部分键盘按键的问题
- 新手向各位高手求助!App是什么意思?
- 紧急!!!为什么在窗口load的时候读一个空文本文件会报‘输入超出文件尾’呢
- CommonDialog打开文件对话框的选择多个文件,如何得到所有文件名?
- 如何在Listview中加入Combo?
- 如何在ie工作窗体左侧显示我的程序?就像点击“历史”或者“收藏”按钮的效果
- 水晶报表中如何,在打印时不显示打印对话窗口(即:打印数页,打印范围的窗)。
- 如何使用datarepeater控件
- 请教关于如何在vb中用其他类型的数据库
- 文件操作,请问如何删除文件里面的一行内容!
- 将两条记录分别加到俩表中,如果任一表的添加过程出错,则不管另一表是否已添加
PlOraType As Long, PvVvalue As Variant) As Long
Dim lErrCode As Long
Dim sMessage As String
Dim vValue As Variant
On Error GoTo ErrorHandler
modbObject.Parameters.Add PsVname, 0, PlVtype
modbObject.Parameters(PsVname).ServerType = PlOraType
vValue = PvVvalue
If (vValue = vbNullString) Then
If (PlOraType <> ORATYPE_NUMBER) Then
vValue = " "
Else
vValue = 0
End If
End If
modbObject.Parameters(PsVname).Value = vValue
ParamAddValue = RESULT_NORMAL
ExitProcedure:
Exit Function
ErrorHandler:
End Function Public Function ParamRemove(PsVname As String) As Long
Dim lErrCode As Long
Dim sMessage As String
On Error GoTo ErrorHandler
modbObject.Parameters.Remove PsVname
ParamRemove = RESULT_NORMAL
ExitProcedure:
Exit Function
ErrorHandler:
End Function================================================================ok?
to wxyq2000(wxyq) :
以上函数如何使用呢?
我想将SQL所得结果显示在richtextbox里,应如果做?