adodc1.recordsource="select * from TABLE where f="& "'" &datalist1.boundtext & "'"
试试adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"
在table表中f是什么类型的,如果是数值那么 adodc1.recordsource="select * from TABLE where f=" & val(datalist1.boundtext) 如果是文本那么 adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"
adodc1.recordsource="select * from table where f='" & dataliset.boundtext & "'"
if IsNumeric(datalist1.boundtext) then adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext else adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext & "'" endif
if IsNumeric(datalist1.boundtext)=true then adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext else adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'" endif
adodc1.recordsource="select * from TABLE where f=" & val(datalist1.boundtext)
如果是文本那么
adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext
else
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext & "'"
endif
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext
else
adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"
endif