sql = "select bookid,name,Author,Times ,rr ,inbillno from BookDetail WHERE inbillno < #"&search_text4&"# or inbillno > #"&search_text3&"# and name like '%"&search_text1&"%' and rr like'"&search_text2&"'"
...全文
307打赏收藏
请高手来看看,错误在那里
sql = "select bookid,name,Author,Times ,rr ,inbillno from BookDetail WHERE inbillno #"&search_text3&"# and name like '%"&search_text1&"%' and rr like'"&search_text2&"'"
sql = "select bookid,name,Author,Times ,rr ,inbillno from BookDetail WHERE inbillno < '"+search_text4+"' or inbillno > '"+search_text3+"' and name like '%"+search_text1+"%' and rr like'"+search_text2+"'"