>Yes I am using remote views.
I worked a contract a couple of months back. A large global enterprise system was converted from remote views to "pass thru" cursors. Stored procedures on the back end. It made a big difference. There are a lot of performance problems with remote vies. They're easy to code, but slow and unpredictable to use.
The way it worked: SQL read into local VFP cursors, which then populated VFP / AX controls. Changes made were updated or inserted back to the server as single record buffers. 86 the the RVs if you need a hot system.
T
Imagination is more important than knowledge