Re: Faster way to just add a record

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

Article #3794

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

#3794

From: bastian.cyril
Date: Mon, 24 Jun 2002 11:33

27 lines
1693 bytes

Table->Append();

You add a record at the end of your Table.

Christian Schneider <csname@hotmail.com> a �crit dans le message :
3d16bf57$1_1@dnews...
>
> 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: <3d1704a3_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3d16bf57$1_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,245e9e27193aa62b
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-24 04:39:13 PST
From: "bastian.cyril" <bastian.cyril@cfa-arches.e-lorraine.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d16bf57$1_1@dnews>
Subject: Re: Faster way to just add a record
Date: Mon, 24 Jun 2002 13:33:14 +0200
Lines: 29
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: 213.56.180.185
Message-ID: <3d1704a3_2@dnews>
X-Trace: dnews 1024918691 213.56.180.185 (24 Jun 2002 04:38:11 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!news3.cnt.ru!srcc!newsfeed.gamma.ru!Gamma.RU!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message