>I have a remote view...
>It has a group by clause on the mainkey!
>
>the table is on a SQL server.
>It has a key field which is an identity field on the server.
>It also has a timestamp field.
>
>I set Send SQL update on and Update all
>fields.
>IThe SQL where clasue is Key and Modified fields...(But I tried them all)
>
>The update is using UPDATE.
>
>WHat happens is when I browse the table...
>If I delete a line or change a line then move to the next line.
>It automatically saves the record. (Does it do a tableupdate
>when you change line s in the browse???)


If you're set to row buffering, yup.


>But the main thing of confusion is that when I use this view in a grid on my form.
>Nothing will save at all.
>Except if I delete one line in the grid!
>
>Anyone got any ideas?!?!What's going on here?

Groping here, but are you issuing a TABLEUPDATE(.T., .T., 'myremoteview')?