>>>So... It seems 40 fields is limitation for single tableupdate??
No. When you do a TABLEUPDATE(), VFP internally executes an INSERT SQL command, using the fields of the view. The limit for any VFP command (including SQL Statements) is 8192 characters.
Take a look at this link:
http://fox.wikis.com/wc.dll?Wiki~VFPVersion10WishList~VFPSearch for the expression:
Extend 8192 statement limit
Despite Microsoft's claims of taking the limits off SQL Statements in VFP9, this limitation still exists. One thing you can try is to shorten your field names. Another thing is to create more than one view, each containing different fields and update the table peicemeal. Neither of these alternatives is very appealing.
When I sense that a view might be getting too large, I break it up into two and create a one to one relationship between them. The framework I use (Visual FoxExpress) makes this easy to do.
Del
