I have had this happen when there is a garbage character at the end of file
----- Original Message -----
From: "David Brown" <[EMAIL PROTECTED]>
To: "'RBase List'" <[EMAIL PROTECTED]>
Sent: Tuesday, May 22, 2001 3:58 PM
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
