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 VFP 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.