Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE error
Message
From
02/04/2002 17:49:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
ALTER TABLE error
Miscellaneous
Thread ID:
00640123
Message ID:
00640123
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform