>I have one form that uses a local view. It had been working fine, but now I'm having a problem and I'm not sure if it's related to our recent upgrade to VFP8. I am using an updateable, local view. In the DataEnvironment, the Buffering is set to Optimistic Row Buffering. In the Load event I have =CURSORSETPROP("SendUpdates",.T.,"myview")
>In my code I replace the values in a few of the fields of the current record and then when I try to leave the record (by doing a SUM or just a SKIP) the system freezes. On my status bar I see a message "Record not available...please wait." I'm the only one using the file. What's happening?
I suspect you haven't properly defined a keyfield for this view. Since you're not setting SendUpdates to .T. until you open the view, it sounds like you didn't set things up on the "Update Criteria" page. Did you define this view through the View Designer or in code? In either case, you can set the SendUpdates, plus all the other criteria at the time you define the view.
And about that Keyfield...it's important that the field or fields you identify as the key correspond to a single record in the source table. Otherwise, it will try to update multiple records.