>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?

Hola Hector,

There is a bug in VFP 5.0 and 3.0 that got fixed in 6.0 and that's related to the length of the WHERE clause in the SQL statement when your clause is set as "Key and modified fields".

The problem usually shows up when you are updating more than 24 fields at a time and there is no real solution that I know of, except a move to VFP6.

We now have the new SYS(3055) to correct this.

More details in the September 98 issue of FoxPro Advisor.

José