以下程式碼
dim s as string, cmd as adodb.command
s = "test"
With cmd
.ActiveConnection = (略)
.CommandText = "insert table_1 values(s)"
.Execute
End With
會產生以下錯誤 "The name 's' is not permitted in this context. Only constants, expressions, or variables alloewd here. Column names are not permitted." 請問這是什麼問題?