>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?
Hi Hector,
If you'r now worried about 'Update Conflict' on the network, Change View's update type property to 'Key Fields Only'.
Bye
Jayesh
- Jayesh