Faster way to just add a record

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

Article #3793

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

#3793

From: Christian Schneider
Date: Mon, 24 Jun 2002 06:42

21 lines
1485 bytes

I just want to add a record to a table. I am now
using something like this:

AdoDataSet->CommandText = "SELECT * FROM Customer";
AdoDataSet->Open();
AdoDataSet->Insert();
AdoDataSet->FieldByName(...) = ...
AdoDataSet->Post();
AdoDataSet->Close();

The problem is, that Open() can take very long if the 
table is large. It would be much faster to use an
"INSERT INTO"-Statement, but I can't use it because
my record contains BLOB-Fields.

It there really no other way to just add
a record to a table without waiting several seconds?


Christian Schneider

Technical Details

Message-ID: <3d16bf57$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!proxad.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,245e9e27193aa62b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-24 00:09:16 PST
From: "Christian Schneider" <csname@hotmail.com>
Sender: "Christian Schneider" <csname@hotmail.com>
Reply-To: "Christian Schneider" <csname@hotmail.com>
Subject: Faster way to just add a record
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 80.130.91.156 80.130.91.156    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3d16bf57$1_1@dnews>
Date: 23 Jun 2002 23:42:31 -0700
X-Trace: dnews 1024900951 207.105.83.65 (23 Jun 2002 23:42:31 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!proxad.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews