Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is 78 fields per table too much??
Message
 
 
To
15/06/2004 07:34:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00913804
Message ID:
00914046
Views:
10
While VFP allows up to 254 fields per table, if you create an updatable view of that table you can run into problems before reaching that number of fields. The reason is the WHERE clause of the view is dynamically constructed when a view is saved and this can put you beyond the 8192 limit for a SQL statement.
Del
Previous
Reply
Map
View

Click here to load this message in the networking platform