I'm using SQL database with Delphi 7 what I need to dois filter a database, with SQL code? My current setup is TADOConnection, connected to the SQL database, then ADOTable, connected to the ADOConnection, pointed to the correct table and a Datasource. Now on the search form I want it to filter with the information selected (Field name selected from a combobox and a value entered into a editbox) I want to make use of SQL code, I need to know how do I Filter the ADOTable or do I have to make use of Tquerry? and how do I connect the querry to the SQL database and table ?
0 · ·