How to insert batch record?

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

Article #5533

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

#5533

From: enoch
Date: Sun, 08 Apr 2001 11:18

12 lines
1342 bytes

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: <3ad0481d_2@dnews>

Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,43bb70b0635aed57,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-08 04:16:04 PST
Reply-To: "enoch" <enoch@memdb.com>
From: "enoch" <enoch@memdb.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to insert batch record?
Date: Sun, 8 Apr 2001 19:18:57 +0800
Lines: 14
Organization: MemDB Technology Company
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 202.65.199.185
Message-ID: <3ad0481d_2@dnews>
X-Trace: dnews 986728477 202.65.199.185 (8 Apr 2001 04:14:37 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews