Dim adoCon As New ADODB.Connection
Dim adoCom As ADODB.Command
Dim adoPar As ADODB.Parameter
adoCon.ConnectionString = "DSN=DSN01;UID=USER01;PWD=PASS01"
adoCon.Open
adoCon.BeginTrans
Set adoCom = New ADODB.Command
adoCom.ActiveConnection = adoCon
adoCom.CommandText = "UPDATE RT_TBL SET C_NUM=? WHERE C_KEY=1"
adoCom.CommandType = adCmdText
'Parameteroオブジェクトの設定
Set adoPar = adoCom.CreateParameter("", adNumeric, , , 333.33)
adoPar.Precision = 5 '●精度の設定
adoPar.NumericScale = 2 '●位取りの設定
adoCom.Parameters.Append adoPar
adoCom.Execute
adoCon.CommitTrans
adoCon.Close
Set adoCom = Nothing
Set adoCon = Nothing
|