In addition to Yuri's suggestion, you can also try these settings on your views:
FetchAsNeeded = .F.
FetchSize = -1
MaxRecords = -1
These will force the view to retrieve all records before moving on to the next statement in your code. You could do the same by issuing a RECCOUNT()/GO BOTTOM or anything that forces the record pointer to traverse the record set completely, but IMO these settings do the job in a cleaner manner.
When we were struggling with these issues earlier this year, I stumbled upon a fantastic white paper-esque website with exhaustive research (including time trials) on these properties and how they interact. Unfortunately, I didn't bookmark it. >:( If I find it again, I'll send it to you.
Hope that helps,
---J
>Hello
>
>I' trying to insert some data into a remote view.
>
>this is the way i go about it. This code is in an onclick event
>
>use testdata!my_remote_view alias remote
>* wait window 'wait a bit'
>insert into remote (cols) values (values)
>
>This only works WITH the wait window command
>otherwise I get an "connection remote_01 is busy" error.
>
>Can anyone tell me what's going on here?
>
>tia