Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuilding Database
Message
 
To
09/02/2000 15:55:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00329687
Message ID:
00329880
Views:
22
>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,

In most cases, this is because the table has been included in the EXE and is therefore readonly.

José
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform