Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rebuilding tables
Message
De
10/02/2000 12:16:53
 
 
À
27/01/2000 12:16:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00323249
Message ID:
00330107
Vues:
38
I finally got the rebuild to work. The problem was the datadict table. I converted the project from 2.6 to 6.0. The data dictionary needs to have all the fields that are required to define a table in the version of Fox that you are using.

* Create the new structure in memory
? "Creating new structure"
select distinct * ;
from datadict ;
where alltrim(datadict.d_template) == template;
having datadict.field_name != "Proxy" ;
order by field_ord;
into array dbf_struc

*!* This won't work if the structure isn't correct in the data dictionary
*!* CREATE CURSOR CursorName FROM ARRAY ArrayName
*!* Specifies the name of an existing array whose contents are the

*!* ---->>>> name, type, precision, and scale

*!* for each field in the temporary table.
*!* See AFIELDS( ) for the proper format for the contents of the array.

create cursor tempdbf from array dbf_struc

So once I made sure I had all the correct fields in the datadict, it worked.

Thanks,
Tyler
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform