It's a normal behavior (and also a Feature), I'm pretty sure you are using Record Buffering (3), and as default it came with an Implicit TableUpdate() when you SKIP records. If you want to No-Save records while you are skipping, try Optimistic Table Buffer (5).
By the way Remote Views have Implicit Transaction.



>I'm having an issue with table buffering in VFP7 using MSSQL Server 2000. I can set table buffering in VFP7 but when I skip to the next record or add a record the changes are sent to SQL Server in an implicit transaction.

>This was not the behavior when using Visual FoxPro Tables.

>Let me clarify the situation:

>I create a local view. I can use it. Set it to buffer the table - in this case the local view. I can edit to my hearts content, begin a transaction, perform a tableupdate() and end the transation. Everything works peachie!

>I create a remote view. I can use it. Set it to buffer the table - in this case the remote view. I edit to my hearts content... but, everytime I skip to the next record the changes are sent back to the server.

>Is this a bug or feature??? Or am missing something?

>Also, when I step through the debugger I notice the buffer level changes from Table to Row Buffering. Is this also a bug or a feature???

>Can someone please clarify or suggest a work around.