怎样用DELPHI实现模胡查找呢?
我的代码如下:
DM_main.searchDepartment.Close;
DM_main.searchDepartment.SQL.clear;
DM_main.searchDepartment.sql.Add('select *from depratment ');
DM_main.searchDepartment.sql.Add
('where DepartmentID like '+edit1.text+''+''%'' );
DM_main.searchDepartment.Prepare;
DM_main.searchDepartment.Open;为什么不能实现模糊查找呢?
大家帮忙看一下,该怎样处理,先谢了!
我的代码如下:
DM_main.searchDepartment.Close;
DM_main.searchDepartment.SQL.clear;
DM_main.searchDepartment.sql.Add('select *from depratment ');
DM_main.searchDepartment.sql.Add
('where DepartmentID like '+edit1.text+''+''%'' );
DM_main.searchDepartment.Prepare;
DM_main.searchDepartment.Open;为什么不能实现模糊查找呢?
大家帮忙看一下,该怎样处理,先谢了!
DM_main.searchDepartment.sql.Add('where DepartmentID like '''+edit1.text+'%''' );