Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create field name more than 10 chars?
Message
From
03/07/2012 10:38:34
 
 
To
03/07/2012 07:16:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01547543
Message ID:
01547560
Views:
75
Hi Tore.

>Borislav gave you the right answer. However, I strongly advice against it, since it may cause you a lot of problems later. To quote Marcia Akins: "You may do it that way, but arsenic is usually quicker".

It was actually Andy Neil who originally said that, but he was referring to fields with spaces in the names, and I agree with that. I feel a lot less strongly about field names greater than 10 characters, as the issues are few:

- Tag names don't match field names since they're restricted to 10 characters. However, it's not that big of a deal.
- If the table is removed from the database, the field names revert to 10 characters. If it happens on purpose, you can plan for how to deal with it (and this rarely happens). If it happens by accident, you have a lot of problems to deal with, this being just one of them.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform