🚀 go-pugleaf

I have been writing small builder applications for several years.  However,
these applications have not involve a database interface.  I now have an
application that requires a larger amount of data than can be handled in
memory an small data files.  I have chosen to use an Access database(or SQL
if needed) and ADO to organize the data files for retreival and processing.
I have gotten the ADO connection working through the ODBC and the ADO
components in BCB6.  I need to get some information on retreiving active
records and sorting the DBGrid to locate the desired data for processing.
In addition, I need to have the user select data files names to be added to
the database table.  Does anyone know of a good tutorial on the actual data
interface after the connection is made?  I have read about using an SQL
Query for ordering and have been considering using a hidden DBEdit to access
the data.  Is there a better way of doing this within a DBGrid?  Some of the
best information I have found so far has been the C++ Developers Guides from
1997 and 1998.

Any help or Info would be greatly appreciated!

Thanks in Advance,

Jim McBride
JMX Services, Inc.
jim@jmxservices.com