Tim,

A few things off the top of my head:

1. Make sure you're not updating the identity field or the timestamp field, SQL Server does that automatically.

2. Are you saying that you have a GROUP BY clause on the primary key of the table? That wouldn't make sense since the primary key must be unique.

3. If you have record buffering on, VFP will automatically update the underlying table when you TABLEUPDATE() or when the record pointer moves. If you are using table buffering nothing will be updated until you use TABLEUPDATE().


>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???)
>
>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?