Simple TADOQuery is not live

From: Andrew (someone_at_nospam.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 10:22:31 +0100

I am in the process of moving from DAO (using OpusDirectAccess) to ADO using
ADOExpress using Delphi 7.

Take the following situation:
1. Open a simple query, just select * from table where code = .....
2. Someone else modifies this record.
3. Do query.Edit.

With DAO when doing the Edit I get the latest data in the record. The data
that was written in step 2.

With ADO (server side cursor) when doing the Edit I just get the original
data from step 1 !! Surely this is not a "live" query just an updateable
historic query. In a multi user situation this is useless.

I can make this work by doing a .Refresh just before the .Edit but what is
the refresh actually doing ? Is it just opening the query again ? If so
this will be very slow especially as this could be in a loop posting
hundreds of accounting transactions.

Are there any settings I need to alter to make it work correctly like DAO ?

Can anyone recommend a good book that covers Delphi, ADO and this multiuser
situation well ?

Thanks

Relevant Pages

  • Re: Running a query to check data entry
    ... The default version for Access 2000 or less is DAO. ... For ADO, make ... Set rst = New Recordset ... > run a query to find the Latest one. ...
    (microsoft.public.access.formscoding)
  • Re: New Info on Stupid Error Im not Seeing
    ... > I want to do away with DAO altogether because in Access 2003, ... Access 2003 *does* include a default reference set to DAO. ... I want to use ADO not DAO. ... > was written in my code as opposed to an Access Query Design. ...
    (microsoft.public.access.forms)
  • Re: Create View, Index
    ... Some of these depend on the library you use to execute the query, i.e. they might work only if executed under ADO (not DAO.) ... Here's an exmaple of how to create a view with ADO: ...
    (microsoft.public.access.queries)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)
  • Re: CREATE TABLE...
    ... without changing setting) the Access Query designer uses ... DAO instead of ADO and thus, has the same problem than DAO on some ... Is there any way to just do it using query, ie, just CREATE TABLE... ...
    (microsoft.public.access.queries)