zyl910有动态释放exe的代码,据说vb有脚本执行控件。
解决方案 »
- VB能不能写所谓的绿色软件 就是不要安装的 只有一堆文件 拷贝到哪里 直接点其中的可执行文件 就可以运行的
- 用vb如何发送邮件(只需验证发送方的身份,而不需验证接收方的信息)!!请高手指点
- 注册代码VB语言 有的,分全给他
- 一个简单的问题.问一下大家
- 有没有哪位大侠知道有一种集多种控件于一体的控件??
- SQL Server数据库的ADO连接问题,怎么修改当前用户????
- Private Declare Function CreateDIBitmap Lib "gdi32"编译提示错误“用户定义类型未定义”是什么原因
- 我的VB数据库干吗不行呢
- MSHFlexGrid结合ComboBox的问题,在线等,多谢!
- '请问如何实现幸福之家效果,需要什么技巧,和知识,实现方法如何
- 关于内存错误!
- 升级了,高兴,散分拉,弟兄们快来接啊!!!
SELECT * FROM TABLE WHERE FLD1='OK' AND FLD2='KO'
但如果我对每次查询的条件需要有更灵活的组合,则:
DECLARE @FLD1,@FLD2 VARCHAR(100)
SET @FLD1='FLD1'
SET @FLD2='FLD2'
EXEC ("SELECT * FROM TABLE WHERE "+ @FLD1 + "='OK' AND " +@FLD2 + "='KO'")
怎么样?看出来了吧?这段中的两个变量可以作为存储过程的参数传递,执行起来自然功能更强劲。网页中的客户端脚本也可以用response.write的方法来动态执行,另外具我所知,VFP中也有这样的功能。VB应该是不具备这一功能的,但我想一定有人能通过各种途径来实现这样的效果,希望能不吝赐教,谢谢!
http://www.cx66.com/cxgzs/program/vb/614.htm
参考一下!
private function test(byref varOut as variant , _
optional byval strOP as variant = "tt" , _
optional byval lngOP as variant = 0) as variant
....
end function
rsR.datasource="SELECT * FROM TABLE WHERE Fld1='" & "OK' AND Fld2='" & "KO'"
rsR.Open可以把OK与KO换成变量
'Private Declare Function EbExecuteLine Lib "vba5.dll" (ByVal pStringToExec As Long, ByVal Unknownn1 As Long, ByVal Unknownn2 As Long, ByVal fCheckOnly As Long) As Long' 对于 VB6
Private Declare Function EbExecuteLine Lib "vba6.dll" (ByVal pStringToExec As Long, ByVal Unknownn1 As Long, ByVal Unknownn2 As Long, ByVal fCheckOnly As Long) As Long' 对于 Access 97/VBE.dll clients like Word 97 and Excel 97
' Private Declare Function EbExecuteLine Lib "vba332.dll" (ByVal pStringToExec As Long, ByVal Unknownn1 As Long, ByVal Unknownn2 As Long, ByVal fCheckOnly As Long) As LongPrivate Function ExecuteLine(sCode As String, Optional fCheckOnly As Boolean) As Boolean
ExecuteLine = EbExecuteLine(StrPtr(sCode), 0&, 0&, Abs(fCheckOnly)) = 0
End Function
Private Sub Combo1_Click()
Text1 = Combo1.Text
End SubPrivate Sub Command1_Click()
Dim res As Boolean
res = ExecuteLine(Text1.Text)
End Sub
Private Sub Form_Load()
' Chr$(34)是双引号
Combo1.AddItem "Var = msgbox(" & Chr$(34) & "看到了?很好用。" & Chr$(34) & " & vbCrLf & " & Chr$(34) & "是否继续实验?" & Chr$(34) & ", vbYesNo + vbInformation)" & ":" & "If var = vbNo Then End"
Combo1.AddItem "shell " & Chr$(34) & "calc.exe" & Chr$(34) & ",vbNormalFocus"
Combo1.AddItem "msgbox SecretFunction(2,2),vbInformation"
Combo1.AddItem "Form1.BackColor = vbRed"
Combo1.AddItem "var = 3^2 + sin(3.1415926/4):msgbox var"
Combo1.ListIndex = 0
End Sub
引用:microsoft script control 1.0
Private Sub Command1_Click()
Dim sc As ScriptControl
Dim str As String
Dim p As Long
Set sc = New ScriptControl
sc.Language = "vbscript"
Debug.Print sc.Eval("2+3+7-4")
str = "Private Sub Test() " & vbCrLf
str = str & "MsgBox ""hello,这是动态加载的过程"", vbOKOnly + vbInformation" & vbCrLf
str = str & "End Sub" & vbCrLf
With sc
.Language = "vbscript"
'这里相当于动态添加一个test过程
.AddCode str
.ExecuteStatement "call test()"
str = "MsgBox ""hello,这是动态加载的过程"", vbOKOnly + vbInformation"
.ExecuteStatement str
End With
Set sc = Nothing
End Sub