With cmdMod_I 'Prepare insert
.CommandText = "Insert Into DirDocRight (CompCd,DirOrDoc,DirDocCode,IDNumber,DirDocRight,TrsUserID)" & _
" Values('" & sOpCompCd & "','C',?,?,?,'" & UCase(sTrsUser) & "')"
.CreateParameter , adChar, adParamInput, 25
.CreateParameter , adChar, adParamInput, 12
.CreateParameter , adChar, adParamInput, 12
.ActiveConnection = cnMod
End
.CommandText = "Insert Into DirDocRight (CompCd,DirOrDoc,DirDocCode,IDNumber,DirDocRight,TrsUserID)" & _
" Values('" & sOpCompCd & "','C',?,?,?,'" & UCase(sTrsUser) & "')"
.CreateParameter , adChar, adParamInput, 25
.CreateParameter , adChar, adParamInput, 12
.CreateParameter , adChar, adParamInput, 12
.ActiveConnection = cnMod
End
Dim cmdMod_D As New ADODB.Command
With cmdMod_D 'Prepare Delete
.CommandText = "Delete From DirDocRight Where CompCd='" & sOpCompCd & "' And DirOrDoc='C' And DirDocCode=?"
.CreateParameter , adChar, adParamInput, 25
.ActiveConnection = cnMod
End With
cmdMod_D.Parameters(0).Value = “dddd"
cmdMod_D.Execute
create table tb(cc text null,dd varchar(20) null) -----這裡的text長度不需要給定
-----------------------------------------------------------------
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Command
Dim sql As String
sql = "provider=sqloledb.1;user id=sa;pwd=123;initial catalog=test5;data source=be122"
cn.ConnectionString = sql
cn.Open
With rs
.CommandText = "insert into tb(cc,dd) values(?,'dd')"
.CreateParameter , adChar, adParamInput, 16 ---------16就是長度足夠長了
.ActiveConnection = cn
End With
rs.Parameters(0).Value = "ppppppppppppppppppppppppppppp"
rs.Execute--------------------------------------------------------