VB中 sql="INSERT INTO t1(姓名,成绩)VALUES('" &n&"',这儿是数字变量怎么办

[ComeFromBeijing]

dim mid1 as integer
mid1=20
sql="INSERT INTO t1(姓名,成绩)VALUES('" &n&"',mid1 ）
高手应该怎么处理这个整型变量？

[bing71]

int型字段也可以放在sql="Insert into t1(姓名,成绩) VALUES('" & n &"'," & mid1 & "）"
的。

[shines77]

应该是：

Private Sub Form_Load()
Dim sql As String
Dim n As Long
Dim mid1 As Integer
n = 5
mid1 = 20
sql = "Insert into t1(姓名,成绩) VALUES('" & n & "'," & mid1 & ")"
End Sub

[Again]

这样写看行不行：
sql="Insert into t1(姓名,成绩) VALUES('" &n&"'," & mid1 & "）"

[ComeFromBeijing]

可成绩是个int型字段呀

[ComeFromBeijing]

高手您给俺一个确切的回答吧，我现在没有办法实验，等实验不行我又
得出来上网！谢谢！

[bryan]

用 " & mid1 & "

[fans]

用sql="INSERT INTO t1(姓名,成绩)VALUES('" &n&"'," & Cstr(mid1) &"）"

[xmao]

数字变量可以直接写，
shines的写法是对的。

[skt642]

96122关注！

[ciml]

对