In the STAR WARS hype. "Luke use the Force"
Your playing with the different buffering and disaster is awaiting. Just my opinion, but it sounds like your going to get bit.
I recommend the use of views for upgrade to SQL Server capabilities.
Sounds like it's just SHOW data, and not EDIT data.
__Stephen Russell
>I found my problem that was producing the "Cannot update the cursor" error. When I reran the program which creates the local view (PVAITEMS) the buffering property defaulted to 3 (Optimistic Row Buffering). I can see now that it needs to be 5.
>
>I have added a call to cursorsetprop to the PVAITEMS.PRG so that I can't forget to do this in the future.
>
>I was able to calculate the running balance with the SCAN just as you (Stephen) did and as I had already coded it. But I'm a little nervous about this approach. It means I've got a live table buffer which I have to revert before leaving the form or executing a requery. And I've got other buffering for new detail items happening on this same form. I'm unsure about how these buffers might interact.
>
>The grid based on this view is read-only so I think I'm going to base it on an array instead of a local view. I have another motivation for doing this: the logic for calculating new closed items really needs to have an array to work with anyway.
>
>Thanks to all for your help.
>
>Peter Robinson