Verovatno nisi search odradio kako treba?!
Probaj search ovako:
Code:
ADOTable1.Filter := 'Naziv_kolone = ' + QuotedStr(Edit1.Text);
ADOTable1.Filtered := true;
ili
Code:
ADOTable1.Filter := 'Naziv_Kolone LIKE ' + QuotedStr(Edit1.Text + '%');
ADOTable1.Filtered := true;
ili sa ADOQuery:
Code:
filter:='';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('SELECT * FROM Naziv_Tabele ');
if Edit1.Text<>'' then
if filter='' then
filter:='WHERE Naziv_Kolone LIKE ''' + Edit1.Text + '%'' '
else
filter:='WHERE Naziv_Kolone LIKE ''' + Edit1.Text + '%'' ';
ADOQuery1.SQL.Add(filter);
ADOQuery1.Open;
S tim sto moras izvrsiti deklaraciju promenljive filter:
Code:
var
filter: String;
pozzz
Someone's sitting in the shade today because someone planted a tree a long time ago.