Question

vb中如何在sql语句中插入数值变量

Adodc1.RecordSource = "select * from 房产证 where 面积>='" & val(Text1.Text) & "' and 面积<='" & val(Text2.Text) & "'"
或都
dim a,b as integer
a=val(text1.text)
b=val(text2.text)
Adodc1.RecordSource = "select * from 房产证 where 面积>='" & (a) & "' and 面积<='" & (b) & "'"
上面的代入数字就行，变量就出错
哪位高手帮解决下！怎么改才好

Answer 1

Adodc1.RecordSource = "select * from 房产证 where 面积>=" & (a) & " and 面积<=" & (b)
这样就可以了

Answer 2

dim a,b as integer
a=val(text1.text)
b=val(text2.text)
Adodc1.RecordSource = "select * from 房产证 where 面积>=" & (a) & " and 面积<=" & (b)