كود :
function ha_FilterQuery(ADOQuery:TADOQuery;FieldName:string;SearchString:string):string;
var
RecordCount:string ;
begin
ADOQuery.Filtered := False;
if( SearchString='') or (SearchString='0') then
begin
ADOQuery.filter := FieldName+' like '+QuotedStr(SearchString +'%');
// ADOQuery.Filter := FieldName + ' = ' + QuotedStr('%' + SearchString + '%');
// I also checked instead of % but wasn't usefull .
end
else
begin
ADOQuery.Filter := FieldName + ' = ' + QuotedStr('' + SearchString +'');
end;
ADOQuery.Filtered := True;
RecordCount:=IntToStr(ADOQuery.Recordset.RecordCount);
// showmessage(RecordCount) ;
Result :=' المجموع '+RecordCount;
end;
call
RecordCount:= ha_FilterQuery(DataModule1.itname_ADOQuery,'ADOCTYP',ADOCTYPE);
