dBASE Bugs - Re: \"Read failure\" on large appends to heavily-indexed table

Author

Re: \"Read failure\" on large appends to heavily-indexed table

Mangetout

2006-11-22, 12:16 am

Either way; I've tried all sorts of things; including appending single rows (actually Append>Edit>field-by-field population>Post) in a Delphi executable, or appending in Dbase with Append from (unqualified) it all fails in the same sort of way at about t
he same point.

Les Shewchuk Wrote:

> How are you trying to append the records.
>
> All at once with \"Append From\"
> or one at a time with a loop?
>
> Les Shewchuk
>
>
> \"Mangetout\" < themangetout@hotmail
.com> wrote in message
> news:J018hdYDHHA.1744@news-server...
>
>

Bruce Beacham

2006-11-22, 5:24 am

Mangetout wrote:
> Either way; I've tried all sorts of things; including appending
> single rows (actually Append>Edit>field-by-field population>Post) in
> a Delphi executable, or appending in Dbase with Append from
> (unqualified) it all fails in the same sort of way at about the same
> point.

26,000 records is not that many. Have you tried the append with fewer
indexes on the target table? Perhaps try several times (as an
experiment), increasing the number of indexes that exist on the target
each time you try the exercise?

Do the indexes contain the application of functions to a datetime field?

If you do it in stages, consider closing the table and re-opening it
between each stage (ie USE, then USE <table> ).

I have no suggestions on why it's happening, though.

Bruce Beacham

Sponsored Links