>>>Is there a practical or fixed limit as to how many fields can be shown in a VIEW?
>
>>Ooops. Never hit that limit. But practically since a view is SQL cursor then it should have the 255 fields limit.
>>Cetin
>
>A couple of people have posted questions saying they've hit a string length limit with many fields. Don't know what it WAS, but it was pretty long.
It was the "key and updatable fields" clause, which creates a very long list of Where Field1="value1" and Field2="value2" and ... for all the fields, when an update is issued. The "key and updatED fields" was the way to go.
This was a quick refresh. Good, else I'd probably forget it :)