progress of insert query

From: Eli Stein (estein_at_reallegal.com)
Date: 11/17/03 

Date: Mon, 17 Nov 2003 11:15:59 -0500

I'd like to show the progress of an insert query to the users on my
application. The insert query copies a bunch of records from one table to
another. Can this be done? (I know the ADO onfetchProgress method is used
for this purpose for queries that move data to the client, but this isn't
usable for insert queries.)

Relevant Pages

  • Re: DataReader - how to get record count without closing?
    ... Not really--especially when we're talking about "real" queries where the SQL ... if I have a query like Select * from A, ... For progress meters I suggest the "Access" approach. ...
    (microsoft.public.dotnet.framework.adonet)
  • Access queries have very bad manners
    ... In my long queries, if my screensaver comes on, or I open a new window (say ... the Access window does not repaint until the query has ... I am curious as to how the progress bar at the ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)