ADODataSet event when new recordset loaded?

From: Philippe Auphelle (PAuphelle_at_irci.fr)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 17:07:58 +0200

Dear All,

Using D7.1, is there an event that can be used to process the
recordset of a detail ADODataSet immediately after it is loaded?
I need to perform some global calculations on the whole recordset, but
haven't been able to find a way to hook my code into this.

The closest trick I found was to use OnRecordSetChangeComplete, but it
fires (with an erClose) when we are about to *leave* the records set
rather when we just loaded it.

The AfterScroll of the master doesn't appear to be usable either,
since at the time it fires, the detail dataset record is not loaded.

Anything else I missed?...

TIA, /Ph.

Relevant Pages

  • Re: ADODataSet event when new recordset loaded?
    ... I confirm that in the AfterScroll of the master, ... detail dataset, I see the data associated with the previous master ... >>the detail recordset still contained data from the previous ...
    (borland.public.delphi.database.ado)
  • Count Number of Appended Lines for Msgbox
    ... are being appended from one table to another (from SUB to MASTER) and display ... it in a MsgBox. ... Dim myRecordset As New ADODB.Recordset ... 'SQL statement to populate Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Indicating Stored Procedure progress on Form
    ... You put this in your master procedure. ... You may also have to take a look at the state property of the recordset ... using a second connection should have worked. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Using IIF to prevent duplicate Imports
    ... > Open a recordset based on that comparison query. ... >> I have a table that is populated with data by importing a text file ... >> duplicates are found the data is imported and appended to the master ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using IIF to prevent duplicate Imports
    ... Easiest way would be to create a query that compares the temporary table to ... Open a recordset based on that comparison query. ... > duplicates are found the data is imported and appended to the master ...
    (microsoft.public.access.modulesdaovba)