Re: Significance of 628 records in INSERT INTO statement

Article View: borland.public.vdbase.data.sql

Article #876

Back to borland.public.vdbase.data.sql Previous Next

#876

From: Keith G. Chuvala (TeamB)
Date: Fri, 19 Jun 1998 00:00

16 lines
1319 bytes

Christopher F. Neumann wrote:

> Is there a way to dislodge the LOYAL ORDER OF THE 628?

I don't know if this is a BDE issue or something in 5.6 itself, but I've seen
it (too much so!) and have never found a good away around it.  Happens with
UPDATEs, too.  Workaround?  CLOSE DATABASES every 600 or so records, then
reopen and pick up where you left off.  I tried for days to lay the blame an
an ODBC vendor for this one some time last year, as I'd get this when I used
UPDATE to modify tables on our AS/400.  Of course the vendor was utterly
ignorant about VdB, and suggested I try a large update routine using Access. 
Used the same ODBC driver with Access and the problem did not occur.  Egg
*all* over my face with that one....

kgc

Technical Details

Message-ID: <358ADB7B.C5BFE411@DELETE_THIS.hit.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6m63tr$5bq9@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,40b0ad00a6b1ddcc
X-Google-Attributes: gidff5a1,public
From: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: Significance of 628 records in INSERT INTO statement
Date: 1998/06/19
Message-ID: <358ADB7B.C5BFE411@DELETE_THIS.hit.net>
X-Deja-AN: 364312346
Content-Transfer-Encoding: 7bit
References: <6m63tr$5bq9@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message