I get a 'SQL Statement too long error' when I try to update a view with TableUpdate().
My view is really simple:
SELECT * FROM mytable WHERE primarykey='fixedvalue'
however, mytable has a lot of fields (about 120).
The view is updatable.
The problem only occurs when I modify MOST OF THE FIELDS in the view and then I try to update the view. The problem does not occur when I change only a few fields.
Any ideas?
Hector Correa