Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'Alter Table' bug ?
Message
 
 
À
16/04/2003 04:03:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00777625
Message ID:
00778269
Vues:
39
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform