|
Home > Archive > Programming with dBASE > June 2005 > Database engine error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database engine error
|
|
| Paul Farr 2005-06-07, 3:23 am |
| My application selects data from a dbf file. I copy the database to a temp
file then delete records that are not required. The database contains
480,000 records.
When I select 1/8th of the database by using copy after a "set range to"
command and then delete my records I have no problems. When I select the
whole database by just copying the data with "copy all to" and then delete
my records it crashes with database engine error:Access to table disabled
due to previous database error. The only difference is in the first part of
selecting 1/8th of the records or copying all the records.
I use dbase plus 2.02 on windows xp with table version 5.
How do I tell what the previous database error is?
| |
| *Lysander* 2005-06-07, 3:23 am |
| In article <i3kqL1waFHA.432@news-server>, paulfarr@brunnet.net says...
> How do I tell what the previous database error is?=20
How do we know which weather will be tomorrow?? :)
Can you post here some lines of code which are representing your two=20
different methods of selecting the data to be processed?
Otherwise it will be difficult here for anybody to help you.
--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de
| |
| Gerald Lightsey 2005-06-07, 7:23 am |
| On Mon, 6 Jun 2005 23:58:47 -0300, in the dbase.programming group, Paul
Farr said...
> My application selects data from a dbf file. I copy the database to a temp
> file then delete records that are not required. The database contains
> 480,000 records.
>
> When I select 1/8th of the database by using copy after a "set range to"
> command and then delete my records I have no problems. When I select the
> whole database by just copying the data with "copy all to" and then delete
> my records it crashes with database engine error:Access to table disabled
> due to previous database error. The only difference is in the first part of
> selecting 1/8th of the records or copying all the records.
>
> I use dbase plus 2.02 on windows xp with table version 5.
>
> How do I tell what the previous database error is?
Some previous problems with operations involving a large number of
records have been solved by using a qualifier in the command that does
not actually affect the records output.
For example, try...
copy to temp for true
Gerald
| |
| Todd Kreuter [dBVIPS] 2005-06-14, 3:23 am |
| "Paul Farr" <paulfarr@brunnet.net(noSPAM)> wrote in message
news:i3kqL1waFHA.432@news-server...
> My application selects data from a dbf file. I copy the database to a
temp
> file then delete records that are not required. The database contains
> 480,000 records.
Not sure about the error, but you may want to take a look at the updateset
class to create your table from the source table.
Todd Kreuter [dBVIPS]
|
|
|
|
|