I know you must have thought of this one too. But do you really need "Key & Updatable Fields" for the update type. Otherwise, you could just use "Key Fields Only" or "Key Fields and Modified Fields"
>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
- Jayesh