Multiple TSDOQuery Sequencing

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

Article #3014

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

#3014

From: Shawn Lammers
Date: Tue, 28 Jan 2003 23:00

18 lines
1880 bytes

I am having difficulties using TADOQuery. It my application I use a
TADOQuery object to insert records into a database (Access) using SQL
commands. I then immediately read out all the records from the table to
populate a combo box again using SQL select commands.

This used to work great when the same TADOQuery object was used for both the
insert and the select queries. I have change the program so that the
TADOQuery object that performs the insert is a different object than the one
that performs the select to populate the combo box. It seems that after the
insert query is run and competed the select query does not see the new
record. It seems to take a couple seconds before the newly inserted record
is available.

Is there a way to get the first query to purge its data so the second one
will see this record?

Thanks
Shawn

Technical Details

Message-ID: <3e370aff@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ec72ddc8bdddb23c,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-01-28 15:10:07 PST
From: "Shawn Lammers" <slammers@no-spam.smartre.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Multiple TSDOQuery Sequencing
Date: Tue, 28 Jan 2003 15:00:42 -0800
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 64.114.43.82
Message-ID: <3e370aff@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1043794687 64.114.43.82 (28 Jan 2003 14:58:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail