Article View: borland.public.vdbase.data.sql
Article #878Re: VdB5.6 table to SQL server 6.5 table
From: Geoff Wass
Date: Sat, 20 Jun 1998 00:00
Date: Sat, 20 Jun 1998 00:00
27 lines
1423 bytes
1423 bytes
Christopher, I have not tried any of this - I am just throwing out vague memories! I think you have to look at the default settings of BDE and avoid AutoCommit. If you have AutoCommit then each SQL command in your loop has to be "committed" before the next is done. If you turn off AutoCommit and then in your program take responsibility for beginTrans/Commit/Rollback, then you can do things in batches and then commit. I am not sure if you can do all 50,000 rows, but it should be possible in my mind (which is not saying much!). Just my 2 sen worth. -- Geoff Wass Kuala Lumpur, Malaysia ============================================================= Please respond to a newsgroup posting by posting a reply (not e-mail). In this way, all can help and all can learn! ============================================================= Triumph is in the first syllable.
Technical Details
Message-ID:
<358B11A6.7F28348@ibm.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6me4at$c441@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,aab9967d5bc578d4 X-Google-Attributes: gidff5a1,public From: Geoff Wass <gswass@ibm.net> Subject: Re: VdB5.6 table to SQL server 6.5 table Date: 1998/06/20 Message-ID: <358B11A6.7F28348@ibm.net> X-Deja-AN: 364362320 Content-Transfer-Encoding: 7bit References: <6me4at$c441@forums.borland.com> Content-Type: text/plain; charset=us-ascii Organization: Noordindarus Consultancy Sdn. Bhd. Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql