關於SQL 語句
SELECT *
FROM access
WHERE " + Replace(Recordset1__A_MMColParam, "'", "'") + " and area between B_MMColParam and C_MMColParam and Var_room and ((rentprice >=D_MMColParam and rentprice<=E_MMColParam) or (price >=D_MMColParam and price<=E_MMColParam)) and location2 like '%" + Replace(Var_location2, "'", "''") + "%'
ORDER BY MM_A MM_B
其中的
WHERE " + Replace(Recordset1__A_MMColParam, "'", "'") + "
和
location2 like '%" + Replace(Var_location2, "'", "''") + "%'
有誰知道是什麼意識嘛?
關鍵是Replace函數的作用