First, I'm having problems trying to use SQL with the TQuery object because my table's field name is the same as (I guess) some SQL code. My code is, Select * from Activity where ((Activity.Check)=True)); Also, I'm having problems qquerying fields that have spaces in the field names. For example, I get an invalid token when this string - SELECT Table1.(hh Name), Table1.[First Name] FROM Table1
ORDER BY Table1.(Last Name], Table1.[First Name];
How do I use the query correctly with these strings?
Secondly, how do I use the progressbar with a Query? I want to move the progress bar by the number of records the encounters until the query is finished.