[求助]奇怪的问题
<P> 请看下面代码,用like进行匹配查询时,如果指定精确值,正常,而指定像"一*"或"孙*"等值时会出错,<BR>其中数据库名db5,表renshi,字段id(自动编号),number(数字),name(文本),</P><P>正常代码;<BR>Dim db As Connection<BR> Set db = New Connection<BR> db.CursorLocation = adUseClient<BR> db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db5.mdb;"</P>
<P> Set adoPrimaryRS = New Recordset<BR> strcn = "SELECT * FROM renshi WHERE id Like '11';"<BR> adoPrimaryRS.Open strcn, db, adOpenStatic, adLockOptimistic<BR> <BR>MsgBox adoPrimaryRS.Fields("name")</P>
<P>出错代码;即无记录<BR>Dim db As Connection<BR> Set db = New Connection<BR> db.CursorLocation = adUseClient<BR> db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db5.mdb;"</P>
<P> Set adoPrimaryRS = New Recordset<BR> strcn = "SELECT * FROM renshi WHERE id Like '一*';"<BR> adoPrimaryRS.Open strcn, db, adOpenStatic, adLockOptimistic <BR>MsgBox adoPrimaryRS.Fields("name")<BR><BR>是不是有些参数不正确,请各位高手指教,谢谢!</P>
页:
[1]