>I get a 'SQL Statement too long error' when I try to update a view with >TableUpdate().
Yup, this is a documented problem - See Knowledge Base(Q169367).
- BUG - Updating a view w/more than 23 fields produces SQL Line too Long error.
They recommend changing the WhereType of the view to 1. This can be done in the View Designer or with programatically.
I think there was also a tip/trick in FPA(can't find the issue), that suggested writing back before the limit of 23 is reached.
Or possibly you could break it up into two smaller views.
Not great solutions, I agree.... Possibly this is fixed in VFP6.0?
HTH -
ellen
ellen whitney
EPS Software Corp