ARe you sure you have the PK checked. Update without a where will do that.

You can turn on odbc tracking to see the sql string sent.


>Hello Everyone!!!!
>I have a remote view that is based on an oracle table.
>When I issue a SQL UPDATE to change one record, It changes
>every stinkin' record in the oracle table.
>
>We have tried buffering and no buffering.
>we have tried parameterized views to find only that one record.
>when it finds that record, it changes that record and every record in the table.
>We are at the end of our ropes and thinking about jumping ship. :-)
>
>Help we are sinking fast and will surely perish.
>
>Thanks in advance
>
>LeRoy