Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum length fieldnames free tables 10 characters why?
Message
From
17/02/2005 16:41:32
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8
Miscellaneous
Thread ID:
00988010
Message ID:
00988115
Views:
47
Long field names are overrated anyway. I hate typing long field name when writing a SQL statment.

Yup. I'm lazy. :)



>If they have to be free tables, the 10 character limit is something you'll have to live with. As Sylvain said, it's for backward compatibility.
>
>>I'm aware of the fact you can use a dbc to put a table with field names longer than 10 characters.
>>
>>I ask this because we are using a (well known) financial modelling software that is built in Visual Foxpro. Input for these models are mostly free dbf tables, the problem what I encounter is to define understandable(unique) field names.
>>
>>
>>
>>>Because of the way the field names are stored in the header of the DBF. Modifying this would break backward compatibility. If you need field names longer than 10 characters, you need to put the table inside a database (DBC).
>>>
>>>>I started programming with VFP using version 3.0, one of the first things I noticed was that fieldnames of free tables could not be longer than 10 characters. I thought that this was due the fact we were using a relatively old version . When we upgraded to VFP 8.0, this didn't change. And this really astonishes me. Why is there a limit anyway?
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform