>>I believe it's 254 or 255.
>>
>>>Can someone refresh me on this number?
>
>It appears to be 30...I have, in a view, 37 updateable fields. After doing an insert, the first 30 (in create view SQL order) get updated, the last 7 are left blank...I did a search and found an old thread about a 24-field limit, but mine appears to be 30...???
>
>This means doing Replaces on extra fields after a tableupdate, or (horrors(s)) doing insert on base table and then requery, defeating purpose of view...unless there is something else I'm missing here? I have Key and Modified set for update type...

Bruce;

Check out kb169367..according to it your prob is with Key and Modified. However, it goes on to say the prob was fixed in 6.0. Anyway, its a very lengthy kb article and explains the fix.

good luck,
Terry