Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do you have a limit regarding the # of fields in your ta
Message
 
 
To
31/07/2008 17:29:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01335646
Message ID:
01335657
Views:
12
>Granted, you want to normalize but I'm curious as to what you consider excessive when creating a table (i.e. fields). Also, with tables of many fields, isn't the process of creating data entry forms tedious?
>
>Curious to know the habits and possible similarities of others
>
>Thanks,
>
>Vernon

Hi Vernon,

The limit is 255 (or 254) fields per table if I recall correctly.

The practical limit varies. I think I never had more than 70 fields in a table.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform