DBGrid1 is linked to DataSource1 and DataSource1 is linked to Query1

Now j filter the table with the Query1.Sql and the line is :

Query1.SQL.Add('Select * FROM '+TT.TableName+' WHERE Brand' Like '
+QuotedStr(FilterEdit.Text));

Where :
TT.TableName is the table name (MyTable.DB)
Brand                is one record's field
FilterEdit           is the TEdit component (the value is 'band%')

When j run the query j will find about 1000 record ( given by
Qurey1.RecordCount ).
At this point j need to refilter the query ..... but how is possible ??????

If j try to do this

Query1.SQL.Add('Select * FROM Query1  WHERE Brand' Like '
+QuotedStr(FilterEdit.Text));

when j run the query j will get this error
File or directory does not exist :
C:\......\.....\Query1.DB
C:\.......\.....\Query1.DBF
C:\........\.....\Query1.TXT

What j can do to refilter this table ???

Thanks for your help

Bye

One option you have is to add the new criteria to the existing SQL
statement and execute it again.

Another option is to save the result set to a (local) base table using the
BDE API function DbiMakePermanent. Then, you can execute the second SELECT
statement against that new table.

If the original statement is executed against a local table (dBASE,
Paradox, FoxPro), you can use the local SQL equivalent of a VIEW. Save the
first statement to a text file (with a .SQL extension) and execute the
second statement against that file. This is more akin to the first choice,
above, as the first query ends up being executed again.

If the SQL is on an SQL database, you can use a VIEW based on the first
statement to derive the second result set.