Re: How to insert batch record?

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

Article #5489

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

#5489

From: Yuancai (Charlie) Ye
Date: Mon, 23 Apr 2001 01:35

25 lines
1720 bytes

Hi,
    See the site
http://www.geocities.com/oledbpro/docs/examples/multiprocs.htm.

Yuancai (Charlie) Ye
See 28 OLEDB examples at http://www.geocities.com/oledbpro
Use OleDBPro instead of ADOs and ADOExpress

"enoch" <enoch@memdb.com> wrote in message news:3ad0481d_2@dnews...
> Hello there,
>
> What is the most efficient way to insert a lot of records to the database
> using ADO?
> I have tried to use TADOTable, Insert() and Post().  I dont know why when
I
> try to insert a varchar type (string type),  an exception will be threw.
> So, I use TADOCommand and use SQL (INSERT) statement to insert the
records.
> But it take a lot of time to insert a lot of records (since it write each
> record one by one).  I want to ask if there are other good method for it?
> That is, insert records in batch.
>
> Thanks.
>
>

Technical Details

Message-ID: <3ae386c6_1@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews

References: <3ad0481d_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,43bb70b0635aed57
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-22 18:44:03 PST
Reply-To: "Yuancai \(Charlie\) Ye" <yekerui@yahoo.com>
From: "Yuancai \(Charlie\) Ye" <yekerui@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3ad0481d_2@dnews>
Subject: Re: How to insert batch record?
Date: Sun, 22 Apr 2001 21:35:39 -0400
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 38.37.88.254
Message-ID: <3ae386c6_1@dnews>
X-Trace: dnews 987989702 38.37.88.254 (22 Apr 2001 18:35:02 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews

Reply to Parent Message