Adodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行%' and name LIKE '% & Text1.Text & %'"dim ss as stringAdodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行%' and name LIKE '% ss %'"这2句like 模糊查询错在何处?多谢
调试欢乐多
Adodc1.RecordSource="SELECT * FROM info WHERE [name] LIKE '银行%' and [name] LIKE '% ss %'"
这个文本框错在何处
Adodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行' & * and name LIKE * & Text1.Text & *"dim ss as stringAdodc1.RecordSource = "SELECT * FROM info WHERE name LIKE '银行' & * and name LIKE * & 'ss' & * "