| Subject: | Query from TADOTable object |
| Posted by: | Gary Shelton (gshelton19…@gmail.com) |
| Date: | Sat, 28 Nov 2009 |
Delphi 2009
I want to perform a query from a filtered TADOTable object. How do I
set up the select statement. I have a "Books" table in database and
right now to set up Treeview I start with A TADOQuery with this
statement "Select Distinct(Author) from Books". If the user filters the
TADOTable to a particular genre I only want to include those Authors. I
see where there is a DataSource property for the TADOQuery so I have
set up a DataSource pointing to the TADOTable object. How to I set the
SQL Statement to access the filtered TADOTable instead of the Full
DataBase table??
Any help appreciated
Gary
--