Databases in Delphi - Filter

How to filter specific data in a database table via a Delphi program by using the Filtered and Filter methods of the ADO table component.

Databases in Delphi Series (Basic)
#MrLongEducation #Programming #Databases

[MrCraigster]

Ur gonna be the reason I pass grade 12😂😂

[jerbear]

How would you use the one filter procedure to filter a text field ignoring case, and the same filter to filer on a >= on a numeric field..
I used a combobox to allow user to selct a field to filter on and a memo to allow the user to enter the filter string.
I can get it to work for either one but have to change the code to do so. I'd like it to work for both, or am I going to have to write procedures for
different filter types..
SelectedField := cbFilterField.Value;
tblUser.Filtered := False;
ShowMessage('FILTER : '+SelectedField+' '+FilterMemo.Text);
tblUser.Filter := SelectedField+' '+FilterMemo.Text;
tblUser.Filtered := True;


This will work for SelectedField >= 100 but not on a text field.
I Tried to use this by typing in the memo field QuotedStr(FullName)


Had to modify this line to .... tblUser.Filter := SelectedField+' = '+QuotedStr(FilterMemo.Text);

[cameron_blackwell_]

I have a feeling that you really like the artist Muse 😂

[sidali_informatique]

if u write muse never you see result
how to filter a table by respecting uppercase and lowercase in delphi

[mofoundolacedric]

hello sir please could you help me solve this problem, I would like to do a filter:
on the list of Algerian consumables
and the list of items with a higher purchase price than a given price

thank you in advance

[dillonward]

how to we delete the records but still keep the IDs in the correct order

[gertdupreez]

I have a delema. In my PAT I have key words for articles in a database and the title, author and date in another. I have combo boxes that contains all the keywords available but I dont know how to code to let people choose a keyword that is in one database and display the title and date and author that is in another, in a DBGrid can you please help me?