Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View 256 fields limitation
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01158947
Message ID:
01158973
Views:
15
>Hello everyone, I have an application that have grown beyond the
>256 fields limitation of the remote view in VFP9, have anybody work around this problem?, any ideas other than using two views linked by a key?
>
>thanks.

WOW! More than 255 fields in ONE table! No metter what the BackEnd is, are you sure you have normalized data?
Also, are you sure you need ALL 300 (:o)) fields at once?
How to split:
Build two (or more) views in each put Primary key(s) field of the table and relate views by Primary key field(s).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform