Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'Alter Table' bug ?
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00777625
Message ID:
00778269
Views:
38
>Hi Sergey,
>
>>>It's not a bug but behavior change in VFP7 (and later). You cannot use ALTER TABLE on cursor with long field names because it truncates long field names to 10 characters.
>
>Yup - I went back and checked in VFP6 - the long field name gets truncated but no error is generated. Since the app wasn't actually accessing the truncated field there was no problem. But I don't see the behaviour change listed in the VFP7 documentation?
>
>Regards,
>Viv

Yea, they missed this one. They also didn't correct help for ALTER TABLE. It still says (even in VFP8) :

ALTER TABLE might not produce consistent results when used with Visual FoxPro cursors created by the CREATE CURSOR command. In particular, you can create a Visual FoxPro cursor with features, such as long field names, that are normally available only with tables that are part of a database container. ALTER TABLE saves a temporary copy of the cursor, so the rules that apply to free tables also apply, and any features requiring database support are lost or changed in an unpredictable manner. Therefore, you should generally avoid using ALTER TABLE with Visual FoxPro cursors unless you have tested and understood the outcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform