David - you might want to change your quote setting strings to those suggested by Dennis McGrath:
SET QUOTES=''''
SET QUOTES=""""
That's four in a row after the equals. Apparently, sometimes it won't set properly with only one symbol. Note that these must be set after connecting, not before.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of David Brown
Sent: Tuesday, May 22, 2001 2:59 PM
To: 'RBase List'
Subject: Who Wants to Load a Million Rows?
Hello all,
We've encountered an unusual problem for the second time in 3 months, so I
thought I'd ask if anyone knows what could be happening.
When we post a cheque run in a non-R:Base accounting program, we create an
ASCII file that can be loaded into our Cash database, which uses RB6.5Dos.
This has loaded without a problem every time but two. In these two
situations, the resulting error was very unusual and quite distressing. We
end up with over 3,000,000 rows in one table, with every column null. This
last time it inflated the size of the RB2 file from a normal 33MB up to
406MB, at which point it filled all available space on the hard disk, which
caused problems in all other databases.
To load the file, we create a variable for the filename (vfile), and we need
to change the quotes, but other than that it's pretty straightforward.
SET QUOTES = "
LOAD cheques FRO .vfile AS ASCII
SET QUOTES = '
I cleared out the null rows and reloaded the database and we were up and
running again. I tried tracing the program to load the same file again and
it worked!
Has anyone seen this before, or knows what I should be looking for to
prevent this from happening again? Thanks in advance for your assistance.
David Brown
Systems Manager
Regis Pictures & Frames Ltd.
Vancouver, BC, Canada
(604) 327-3447 ext. 28
Shop Regis online at www.regispictures.com
