Re: ODBC Queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hi,

FBxiii wrote:
Is it possible to refresh the form while the report is running? I have tried placing DoEvents in the code but it doesnt work.
Use ADO and execute it async.

http://groups.google.de/group/microsoft.public.de.sqlserver/browse_frm/thread/71fe930c0a21e1b5/2f51c152ae66e206?lnk=st&q=ado+connection+with+events&rnum=8#2f51c152ae66e206

The source at the end of the last posting may give you some clues.


mfG
--> stefan <--
.

Relevant Pages

  • Re: Executing UpdateBatch Asynchronously ?
    ... ADO classic does not support async operations on the Update ... While it's possible to execute virtually any COM operation ... > My Application freezes while performing UpdateBatch.. ...
    (microsoft.public.vb.database.ado)
  • Re: Problem with Deletes in code
    ... DoCmd.RunSQL to execute the delete query. ... 'All records in rsSourceProjects will be for the same project, ... problem with ADO interacting with the tables, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Vorgang ist =?ISO-8859-1?Q?f=FCr_geschlossenes_Objekt_?= =?ISO-8859-1?Q?nicht_zu
    ... ich versuche mit ADO auf eine MS-SQL 2005 Instanz zu zugreifen. ... Zeile positioniert (und ein adForwardOnly Resultset wie es Execute ... 1.: SELECT object_id ...
    (microsoft.public.de.sqlserver)
  • Re: foreign key ado syntax
    ... in my previous ado approach I was getting a "Values ..." ... Sub ToDatabase ... oBlockData .ToDatabase oDbController ... execute for each record(instead of doing a batch...which i've never done ...
    (microsoft.public.vb.database.ado)
  • Re: How do I make the ON DELETE CASCADE clause in the ALTER TABLE CON.
    ... I believe that cascading updates/deletes can only be included in your DDL ... Since the interfaces uses the native Access libraray, ... You have to execute the query from code on an ADO connection. ...
    (microsoft.public.access.modulesdaovba)