Thanks for your quick reply...

I am already using sys(3055). I ran it a problem where I needed that about a month ago...

I think one of the problems was that there must be a maximum on the number of updateable fields in a view... or sql update... I could try to use a delete and reinsert method.... I reduced the number of updatable fields to less than 128 and the update seems to work ok.

I have another problem with the view now though.. when I switch from one record to the next, all of the fields get flag with a 2 in the GETFLDSTATE()... Does anyone know what would cause this?

Thanks,

Randy

>Try issuing SYS(3055, 8 * MIN(40, FCOUNT( ))) before TableUpdate(). See help of SYS(3055) for more info..
>
>>I have an updatable view I have been working on that has grown to about 130 fields. I am getting an error now that says there are too many fields to update.
>>
>>I know I should probably normalize this to limit the number of fields. I could seperate out several of the fields to another table but the way the data is being collected it would still be a 1 to 1 relation to the subtable.
>>
>>I could really use some advice. Thanks in advance,
>>
>>Randy