Cyril,

There are some ways around this, but the best advice I can give would be to take a hard look at your data model. Quite possibly some of those fields should or could be part of a 1-to-1 child table. Breaking out columns to child tables either by applying normalization or simply breaking out by domain or function will not only make your updates easier, they'll make your system much more responsive.

>A table has 190 fields. In a view, I can replace up to 128 fields of an existing record and tableupdate(.t.) works. When I replace >128 fields the tableupdate fails with error 1864, SQL: Too many fields in UPDATE.
>
>I set sys(3055,2040) but that didn't overcome the 128 field limit.
>
>I can append a new record and change more than 128 fields without any problem. But when I move to an existing record and change >128 fields, the tableupdate fails.
>
>
>Is there a way to do this?
>
>TIA
>Cyril.