For a bulk import operation I've added a utility to zap everything. This doesn't work - the DataSetCount is 0

  dm.pqDatabase.Connected := True;
  for Cntr := 0 to dm.pqDatabase.DataSetCount - 1 do begin
   if dm.pqDatabase.DataSets[Cntr] is TnlhTable
    then TnlhTable(dm.pqDatabase.DataSets[Cntr]).EmptyTable;
  end;

I've altered things to loop round components on the form

  for Cntr := 0 to ComponentCount - 1 do begin
   if Components[Cntr] is TnlhTable then TnlhTable(Components[Cntr]).EmptyTable;
  end;

so I have a working solution.

At present there are two nlhTable components (my subclassed EDBTable) on the form, and they are linked to dm.pqDatabase so why am I getting zero?

Roy Lambert

On 5/2/2018 11:28 AM, Roy Lambert wrote:
> At present there are two nlhTable components (my subclassed EDBTable) on the form, and they are linked to dm.pqDatabase so why am I getting zero?

Are they open/active ? I think only opens ones show up.

Raul

Raul


That would explain it. I thought it was just a list of everything connected to it. I've only used the approach in a couple of places and in those all the tables would have been opened.

Roy Lambert