Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long field name bug
Message
From
24/11/2006 05:26:06
 
 
To
23/11/2006 06:23:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01171727
Message ID:
01172220
Views:
14
>>>As stated before in this thread, this is NOT a bug. From help on Alter table:
>>>
>>>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...>
>>
>>Pretext explanation. If long field name doesn't supported for cursors VFP should give an error "You cannot use long field names with cursors". That would be clearly.
>>
>>VFP behaviour strange with this issue. gives different unrelative erros with different conditions...
>>
>>It's a bug for me.
>
>You can in deed use long field names in cursors, but you can not alter the structure of a cursor which has long field names. This is documented, and thus not a bug.

I agree that it's not a bug, as I already pointed out here: Re: Long field name bug Thread #1171727 Message #1171795, because it actually is documented.

However, the behavior is troublesome and should be addressed by the vfp-devteam anyway. Arguments:

- The developer is not always aware of the exceptions. Perhaps the ALTER TABLE is even done in a generic routine that cannot possibly be aware of the exceptions unless it extensively tests for them.

- It must be doable for the devteam to alter a cursor that has long fieldnames or other exceptions.

- If altering cursors is really troublesome in some conditions for the devteam, then they should have decided to not let ALTER TABLE support cursors in any condition.
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform