Lawrence Blog

目前找到的原因:大多是使用like語法，所造成的。 下面紅色字體部份改成藍色字體部份就可以解決這樣的問題 strSql = "select * from Info where name like '%" + txtSearch.Text + "%' or note like '%" + txtSearch.Text + "%' order by autocount desc"; strSql = "select * from Info where InStr(1,LCase(name),LCase(\'" + txtSearch.Text + "\'),0) <> 0 or InStr(1,LCase(note),LCase(\'" + txtSearch.Text + "\'),0) <> 0 order by autocount desc";

Access對於SQL的語法較為嚴謹， Num1 && Amt9 兩個欄位型態為數值，請注意以下差別 --使用Access Num1 & Amt9 兩個欄位型態為數值 select [name],dept,a.* from GDEPTF d right join ( select left(dept,2) as SQ1, sum(num1) as N1 from GPRSNF where yy='097' and (num1 0 or amt9 0) group by left(dept,2) ) a on a.SQ1=left(d.dept,2) where right(d.dept,3)='000' --使用SQL Server 型態方式寫成字串一樣可以執行 select [name],dept,a.* from GDEPTF d right join ( select left(dept,2) as SQ1, sum(num1) as N1 from GPRSNF where yy='097' and (num1 '0' or amt9 '0') group by left(dept,2) ) a on SQ1=left(d.dept,2) and right(dept,3)='000'