Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuilding Database
Message
From
09/02/2000 15:55:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rebuilding Database
Miscellaneous
Thread ID:
00329687
Message ID:
00329687
Views:
53
I am trying to rebuild my database and its tables. I keep getting an error 'Rebuild found a problem it couldn't fix in file: CONTACT.DBF'

'Error #: 111 Message: Couldn't update the cursor'

Here is my code and where the error occurs...

? "Creating new structure"

select distinct * ;
from datadict ;
where datadict.d_template == template;
having datadict.field_name != "Proxy" ;
into array dbf_struc ;
order by field_ord

create cursor tempdbf from array dbf_struc
select tempdbf
go top

* Copy the data from the old table into the new structure
? "Copying old data"
if file(currdbf)
append from (currdbf) && This is where we will likely have an error
endif

* If we had an error that couldn't be fixed, Say so and exit.
if GotError <> 0
Wait Window "Rebuild found a problem it couldn't fix in file: "+upper(Currdbf) Timeout 5
wait window "Error #: "+alltrim(str(goterror))+" Message: "+alltrim(message()) Timeout 5
RETURN -1
endif

I converted the project from 2.6 to 6.0 using the functional conversion. All my forms work and they access the tables correctly. Did something happen to the contact table or any ideas how to fix this error?

TIA,
Andrews Dumith
Next
Reply
Map
View

Click here to load this message in the networking platform