Hi Joel,

If you are sharing connection this way, you should use FetchSize=-1 for both views.

Thanks,
Aleksey.



>This is a VERY SIMPLE program and yet it never runs and it is obviously something I am doing wrong.
>
>I get a Connection Busy error before this program can complete the first pass through the Do While loop.
>
>The SQL file Remote_view2 is a fairly large file and my guess is that the view is still loading and thus CONNECTION BUSY.
>
>I even commented out the =Tableupdate() and was going to update all of the records AFTER the loop with no success.
>
>
> HELP
>
>
>
>open database SQL_Views
>Store SQLCONNECT(jsql, 'joel', 'password') TO hsql
>Select a
>Use Remote_view1 Connstring hSql
>Select b
>Use Remote_view2 Connstring hSql
>Select a && small file of a couple dozen records
>Do While Not Eof()
> Scatter Memvar
> Select b && Large file with many records and Indexed on ID
> Locate For Id=m.arfeed_id
> If Found()
> Replace b.Status With "D"
> *=Tableupdate()
> Else
> *** Do nothing
> Endif
> Select a
> Delete
> *=TABLEUPDATE()
> Skip 1
>Enddo
>Quit