Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE error
Message
De
02/04/2002 17:49:07
Tim Muller
Innovative Solutions, Inc.
West New York, New Jersey, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
ALTER TABLE error
Divers
Thread ID:
00640123
Message ID:
00640123
Vues:
57
I am moving an application from VFP 6 to VFP 7. The app has the following code:

USE data\sam EXCLUSIVE
= AFIELDS (temp)
CREATE CURSOR cursam FROM ARRAY temp
ALTER TABLE cursam ADD coup_val C(30)

Everything works fine in VFP 6.

If all the field names in SAM are less than 11 characters in length, this works fine in VFP 7 too. If one or more field names are more 10 characters long the ALTER TABLE fails with the message "Invalid operation for the cursor".

Any thoughts on what the problem might be.

In VFP 6 the ALTER TABLE truncates all of the field names longer than 10 characters to 10 characters.

Tim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform