ExecSQL problem !!!!!!!!!!!!

Article View: borland.public.cppbuilder.database.ado

Article #5955

Back to borland.public.cppbuilder.database.ado Previous Next

#5955

From: alexandr
Date: Wed, 29 Nov 2000 21:35

21 lines
1579 bytes

I'm using this peace of code:

 TADOQuery* qrTemp = new TADOQuery(this);
 qrTemp->ConnectionString = ReportQ->ConnectionString;
 String sql = "delete from Teable where ID = " +
  IntToStr(ID);
 qrTemp->SQL->Add(sql);
 try
 {
  qrTemp->ExecSQL();
 }
 catch(...)
 {
  ShowMessage("DELETE failed");
 }
 delete qrTemp;

but it seems to me that REAL delete of record occurs only after maybe 2 or 3
seconds, so if I'll perform immediately Select from database, than I'll see
the 'dead' record and only after second or third attempts it will be really
deleted. Could anyone explain this a situation.

Technical Details

Message-ID: <3a2576b5_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!news-fra1.dfn.de!news-koe1.dfn.de!do.de.uu.net!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.belnet.be!news.belnet.be!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!207.244.76.96

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2e4b31401192d9f7,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-11-29 13:38:10 PST
From: "alexandr" <alexandr_1@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ExecSQL problem !!!!!!!!!!!!
Date: Wed, 29 Nov 2000 16:35:26 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 207.244.76.96
Message-ID: <3a2576b5_2@dnews>
X-Trace: 29 Nov 2000 13:35:49 -0800, 207.244.76.96
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!news-fra1.dfn.de!news-koe1.dfn.de!do.de.uu.net!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.belnet.be!news.belnet.be!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!207.244.76.96