Cmd.CommandText = "Insert into CTestData values(1, 2 , 3, 4, 5, 6, 7);"
Cmd.Execute
以上语句可以成功执行,可是换成下面的语句时,就是不行
Cmd.CommandText = "Insert into CTestData values(TempDryTmpt, TempWetTmpt, TempInWaterTmpt, TempOutWaterTmpt, TempWaterFlow, TempFanFrequency, TempFanPower,1);"
Cmd.Execute提示错误为至少一个参数没有被制定值
Cmd.Execute
以上语句可以成功执行,可是换成下面的语句时,就是不行
Cmd.CommandText = "Insert into CTestData values(TempDryTmpt, TempWetTmpt, TempInWaterTmpt, TempOutWaterTmpt, TempWaterFlow, TempFanFrequency, TempFanPower,1);"
Cmd.Execute提示错误为至少一个参数没有被制定值
"Insert into CTestData values( " & TempDryTmpt & "," & TempWetTmpt & "," & _ & "," & TempInWaterTmpt & "," & TempOutWaterTmpt & "," & TempWaterFlow & "," & _ TempFanFrequency & "," & TempFanPower & ")"
注意 & 号左右要留空格
Cmd.CommandText = "Insert into CTestData values( " & TempDryTmpt & "," & TempWetTmpt & "," & _ & "," & TempInWaterTmpt & "," & TempOutWaterTmpt & "," & TempWaterFlow & "," & _ TempFanFrequency & "," & TempFanPower & ");"变量用" & 你设的变量写在这儿 & "
字符间都有空格