Programming with dBASE - Extrange Table

Author

Extrange Table

evilaro

2005-04-22, 8:23 pm

To all:

I have a table with 12.000 records. .dbf and .mdx no .dbt
75 fields for a total of 1762 character per record.

The total of the table is 22mb.

This table, looks like is okey.. I have not been able to find a error on it
.... since it does not have a memo field it is simple.

So I copy to another location, I zap it and append from the original using
the append from.

It gives me a writting error, at about 8000 record and the procces is ended.

So I have split the table in 2 ... and append the 2 1/2 tables

NO PROBLEM

So theoretically that proves that the original tale is okay and the two 1/2
tables are also okay.

So now, I import the first table to the secon and separetelly the second
table to the first...

SAME PROBLEM

So I should think it is a problem either from the number or recors or the
size.

My BDE is (very standar judging by the comments recentelly posted)

So ... any Idea ???? 20mb table and 12.000 recors does not look like
very big ????

Any suggestion or other approach will be appreciated.

Emilio

Dennis Glowack

2005-04-22, 8:23 pm

Try appending with the reindex parameter

Append from sometable REINDEX

This will cause the indexes to be rebuilt AFTER the append has finished.

"evilaro" <buzon@evil.es> wrote in message
news:DpPcm54RFHA.1528@news-server...
> To all:
>
> I have a table with 12.000 records. .dbf and .mdx no .dbt
> 75 fields for a total of 1762 character per record.
>
> The total of the table is 22mb.
>
> This table, looks like is okey.. I have not been able to find a error on
it
> ... since it does not have a memo field it is simple.
>
> So I copy to another location, I zap it and append from the original using
> the append from.
>
>
> It gives me a writting error, at about 8000 record and the procces is
ended.
>
> So I have split the table in 2 ... and append the 2 1/2 tables
>
> NO PROBLEM
>
> So theoretically that proves that the original tale is okay and the two
1/2
> tables are also okay.
>
> So now, I import the first table to the secon and separetelly the second
> table to the first...
>
> SAME PROBLEM
>
> So I should think it is a problem either from the number or recors or the
> size.
>
> My BDE is (very standar judging by the comments recentelly posted)
>
> So ... any Idea ???? 20mb table and 12.000 recors does not look like
> very big ????
>
> Any suggestion or other approach will be appreciated.
>
> Emilio
>
>
>
>

Robert Bravery

2005-04-23, 3:23 am

Hi,

Also double check that you dont have any corrupted records.

Robert

"Dennis Glowack" < dennisglowack@dennis
oft.com> wrote in message
news:FkEJec5RFHA.444@news-server...
> Try appending with the reindex parameter
>
> Append from sometable REINDEX
>
> This will cause the indexes to be rebuilt AFTER the append has finished.
>
> "evilaro" <buzon@evil.es> wrote in message
> news:DpPcm54RFHA.1528@news-server...
> it
using[color=darkred]

> ended.
> 1/2
second[color=darkred
]
the[color=darkred]
>
>

evilaro

2005-04-23, 7:23 am

Dennis:

Great... with the reindex bit it append it correctelly....

But..

Always a but.

After this appending I would assume the table is now Okay...

So I copy the table to another folder... so both tables are good and are the
same.

I repeat the process. zap one oif them and appen from the second
Since all should be okay I do not use the REINDEX

Then I get the error again ????

If I put the Reindex bit it does it properly...

I really can not understand it ??

Thanks
It has helped a lot.

Emilio

"Dennis Glowack" < dennisglowack@dennis
oft.com> escribió en el mensaje
news:FkEJec5RFHA.444@news-server...
> Try appending with the reindex parameter
>
> Append from sometable REINDEX
>
> This will cause the indexes to be rebuilt AFTER the append has finished.
>
> "evilaro" <buzon@evil.es> wrote in message
> news:DpPcm54RFHA.1528@news-server...
> it
using[color=darkred]

> ended.
> 1/2
second[color=darkred
]
the[color=darkred]
>
>

evilaro

2005-04-23, 7:23 am

Robert..

Dennis sugestion has helped but still have the problem not
clear to me.

When you say

"Also double check that you dont have any corrupted records."

What would be the correct proces for doing this.??

I use the table without any problem
I have LIST them, no problem
I have list them to a file, no problem
I have appended the tables splitting then in two.. no problem..

IS there a really good procedure to put a table to be checked
for all possible problem...

Thanks
Emilio

"Robert Bravery" <me@u.com> escribió en el mensaje
news:HnWgwR9RFHA.320@news-server...
> Hi,
>
> Also double check that you dont have any corrupted records.
>
> Robert
>
> "Dennis Glowack" < dennisglowack@dennis
oft.com> wrote in message
> news:FkEJec5RFHA.444@news-server...
on[color=darkred]
> using
two[color=darkred]
> second
> the
>
>

Robert Bravery

2005-04-24, 3:23 am

Hi,

Not really. Its just a matter of trial and error. What you've done so far
should catch many problems. Only thing I can suggest is, if you know where
about the problems happen, can you then duplicate them to the same place all
the time, if so, check about 10 records either side of where the problems
occur

Robert

"evilaro" <buzon@evil.es> wrote in message
news:5GDV7g%23RFHA.444@news-server...
> Robert..
>
> Dennis sugestion has helped but still have the problem not
> clear to me.
>
> When you say
>
> "Also double check that you dont have any corrupted records."
>
> What would be the correct proces for doing this.??
>
> I use the table without any problem
> I have LIST them, no problem
> I have list them to a file, no problem
> I have appended the tables splitting then in two.. no problem..
>
> IS there a really good procedure to put a table to be checked
> for all possible problem...
>
> Thanks
> Emilio
>
>
>
>
> "Robert Bravery" <me@u.com> escribió en el mensaje
> news:HnWgwR9RFHA.320@news-server...
finished.[color=darkred]
error[color=darkred]

> on
is[color=darkred]
> two
or[color=darkred]
like[color=darkred]
>
>

Robert Bravery

2005-04-24, 3:23 am

Sponsored Links