When is database idle after a next record ?

From: ed (edathome_at_sisac.com)
Date: 10/26/04

  • Next message: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented" 
    Date: Tue, 26 Oct 2004 14:03:27 -0400

    I have a main Database (MSSQL) that has 9 tables linked to it. Some of
    these linked tables are large, so there can be a lag between when that main
    table does a .Next and the linked tables show their data. I need to wait
    until they catch up. This program only exports the data from databases, no
    updating.

    Current I'm pausing 1 second between records which works fine, but adds 1
    minute to every 60 records I export.

    I've tried:

    If MyAdoTable.state = stFetching Then ImBusyStill := True;

    When I compile I get:
        Incompatible types: 'TDataSetState' and 'TObjectState'

    Thanks,

    Ed
    D6E, ADO

  • Next message: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented"

    Relevant Pages

    • DBConvert for Access & MSSQL 2.0.0
      ... DBConvert for Access & MSSQL is a database migration tool for data ... If a direct access to your MSSQL server is denied (insufficient ... privileges) you can save your data into a MSSQL Dump file to overcome ...
      (comp.software.shareware.announce)
    • Access2MSSQL PRO 1.2.0
      ... Access2MSSQL Pro is a database migration tool for data conversion from ... MS Access database to MS SQL Server and from MSSQL to ... privileges) you can save your data into a MSSQL Dump file to overcome ...
      (comp.software.shareware.announce)
    • Re: [PHP] text field truncation with sql server
      ... Does your database driver, whatever it is, which you've told us is not ... PDO, have any kind of limit in the buffer size of query data ... I see mssql in the code, so assume that's it, right?... ... On Thu, July 12, 2007 11:37 pm, Bruce Cowin wrote: ...
      (php.general)
    • Re: Simple TO-DO List Manager program
      ... I am doing a simple TO-DO list manager using Coldfusion 8 and the language and MSSQL as the database.? ...
      (perl.dbi.users)
    • Re: [PHP] text field truncation with sql server
      ... Does your database driver, whatever it is, which you've told us is not ... PDO, have any kind of limit in the buffer size of query data ... I see mssql in the code, so assume that's it, right?... ... the truncation. ...
      (php.general)