General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rebuilding Database
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only