Jump to content

PjDS

Members
 View Profile  See their activity

  • Content Count

    1

  • Joined

  • Last visited

Posts posted by PjDS

  1. Posted

    Dear Sirs,

    in my Delphi 10.4 Form1 there are: ADOConnection1, ADOQuery1, DataSource1, DBGrid1 (TDBGrid component) and ADOConnection2, ADOQuery2, DataSource2, DBGrid2 (TDBGrid component). I use ADOConnection1, ADOQuery1, DataSource1 for polupate DBGrid1 and the other ones for populate DBGrid2. ADOConnection1 and 2 use the same access database (DB1.accdb). I would like to filter the DBGrid2 records using the selection of one record over the DBGrid1. The filter must use a Field of the selectd record (row) in DBGrid1. Questions:

      • Is it possible and Is the correct approach?
      • It would be preferable to create the connection to the database and manage it via code (runtime) without using components on the form (ADOConnection, ADOQuery, etc)?
      • Is it necessary to use two adoconnections if the database to which they are connected is the same?

    Thanks!

×