If (conn.connectto("test","sa","1sa")) Then
sql1="select * from addressbook"
query.sql=sql1
Call result.execute
If result.isresultsetavailable Then
strText=doc.telnumber(0)
element1 = Evaluate(|@Explode("|+strText+|";";")|,doc)
Forall element In element1
Msgbox "element=" & element
call result.addrow
Call result.setvalue("tnumber",element)
Call result.updaterow
End Forall
不能把数据导入到数据库啊,那里有问题?原来是想用多个域来实现,但一次有多少人申请是不确定的,所以不知要建多少个域,才用现在的办法,建一个域,然后分隔开.
Sub Initialize
Dim strText As String
Dim db As notesdatabase
Dim session As New notessession
Dim doc As notesdocument
Dim result As Variant
Set doc = session.documentcontext
strText=doc.telnumber(0)
result = Evaluate(|@Explode("|+strText+|";";")|,doc)
Forall element In result
Msgbox "element=" & element
End Forall
End Sub
代理运行后提示:"variant does not contain a container",要怎么改?
给你个例子
Sub Initialize
Dim strTest As String
Dim s As New notessession
Dim doc As notesdocument
Dim result As Variant
Set doc = s.documentcontext
strText="aa;bb;cc;"
result = Evaluate(|@Explode("|+strText+|";";")|,doc)
Forall element In result
Msgbox "element=" & element
End Forall