Re: Oracle ADO query shows deleted records

From: Jerry Pisk (jerryiii_at_hotmail.com)
Date: 08/24/04

  • Next message: Jerry Pisk: "Re: Query tables across multiple databases with sql" 
    Date: Tue, 24 Aug 2004 16:36:54 -0700

    You need to be a little more specific. "Delete a record from a table" is
    such a vague statement that you will probably not get any response to it.

    The short answer is no, ADO doesn't cache anything. The long answer is yes,
    it does cache records. It all depends on what you're doing.

    Jerry

    "Steve W" <BunnyBoy@community.nospam> wrote in message
    news:uG6sT$fiEHA.1348@tk2msftngp13.phx.gbl...
    > From an ASP.NET application (or a .Net component called by an ASP.NET
    > application) I connect to Oracle via ADO and delete a record from a table.
    >
    > If I look via Oracle's SQL plus the record has gone.
    >
    > If I then query the table, the row still seems to be there. Is ADO
    > caching
    > this data somehow ?
    >
    > Thanks
    >
    > Steve
    >
    >

  • Next message: Jerry Pisk: "Re: Query tables across multiple databases with sql"

    Relevant Pages

    • Re: Newbie: Data storage and manipulation speed
      ... Thanx for your kind response! ... plan to call DoEvents about 3-5 times per second. ... Access Table through ADO manipulations. ... But, if memory is insuficient, you'll ...
      (microsoft.public.vb.general.discussion)
    • Re: Access SQL Server Express over the Internet
      ... Very interesting - any reasons why not ADO? ... central server - everything works like a charm since two years. ... SET NO_BROWSETABLE ON [TDS RPC format] ... Some response (ack) ...
      (borland.public.delphi.database.ado)
    • RE: SQL Syntax Problem
      ... Thanks for the response, John, ... I tried changing the name of the work sheet to 'Eighty' to see if that was ... I could try ADO, but in this case I am not sure how to tell Access to use ... > contain invalid characters or punctuation.... ...
      (microsoft.public.access.externaldata)
    • Indexing Question
      ... I have a VB6 application in which I access a FP6 DB with ADO. ... As one of the tables gets bigger My response is degrading. ...
      (microsoft.public.fox.vfp.queries-sql)
    • Indexing Question
      ... I have a VB6 application in which I access a FP6 DB with ADO. ... As one of the tables gets bigger My response is degrading. ...
      (microsoft.public.data.ado)